Re: Getting error 17826 - please help

From: Allan Mitchell (allan@no-spam.sqldts.com)
Date: 02/26/03


From: "Allan Mitchell" <allan@no-spam.sqldts.com>
Date: Wed, 26 Feb 2003 15:34:11 -0000


Have you checked this article

http://support.microsoft.com/?kbid=165158

--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Marlon Brown" <marlon_brown@hotmail.com> wrote in message
news:OaITzoa3CHA.1260@TK2MSFTNGP12.phx.gbl...
> As per MS recommendation, I setup SQLServerAgent (From Ent. Manager) and
> then MSSQL server  (7.0) to run using a standard Domain User account.
>
> However, in eventvwr I am getting error:
>
> "Error:17826, Severity:18, State:1
> Category:ODS
>
> Could not setup ListenOn connection '1433. Operating system error 10013.
An
> attempt was made to access a socket in a way forbidden by its access
> permissions."
>
> Of course if add the domain user account back to local administrator the
> whole thing should work fine.
> Is there any way to make this work without using overpermissions though ?
I
> have other SQL (in that case SQL2k) running with SQLServer with domain
user
> accounts and I didn't have any problems - maybe what is craping my SQL7.0
> are third-party applications that rely on that damn overpermissions on
> SQLSErver and SQLServerAgent accounts to work...
>
> Thank you,
>
> MB
>
>
>
>


Relevant Pages


Quantcast