Friday, February 17, 2012

Error ID 19011

Platform: Windows 2000 Server SP3
Hi,
I noticed the following error event in the Application Log
of our database server (SQL 2000 Server SP3) for the first
time three days ago:
Error ID: 19011
Source: MSSQLServer
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) :
Error 5.
This error appeared right after I shut down and restarted
the database, using the SQL Server Service Manager. I
always do this to backup the database, but never get the
error message.
I would appreciate if anyone could help.
ThanksAmir\
This is comment of Bill Cheng [MSFT]
According to my check, "SpnRegister" is to register in Active Directory.
8344 indicates insufficient access rights to perform the operation.
According to my experience, if the account starting SQL Server service does
not have enough permissions, it may also this message: SuperSocket Info:
Failed to get Exclusive port use(MSAFD Tcpip [TCP/IP]) : Error 10013 (An
attempt was made to access a socket in a way forbidden by its access
permissions.).
Could you check the account that starts SQL Server service? Make sure it
has enough permissions. Try to add it to LOCAL ADMINISTRATORS group to
check.
For more information on DsWriteAccountSpn ,visit the following Microsoft
website:
http://msdn.microsoft.com/library/d...-us/netdir/ad/d
swriteaccountspn.asp
"Amir M." <anonymous@.discussions.microsoft.com> wrote in message
news:df0901c40b68$d7e17d80$a501280a@.phx.gbl...
> Platform: Windows 2000 Server SP3
> Hi,
> I noticed the following error event in the Application Log
> of our database server (SQL 2000 Server SP3) for the first
> time three days ago:
> Error ID: 19011
> Source: MSSQLServer
> SuperSocket info: ConnectionListen(Shared-Memory (LPC)) :
> Error 5.
> This error appeared right after I shut down and restarted
> the database, using the SQL Server Service Manager. I
> always do this to backup the database, but never get the
> error message.
> I would appreciate if anyone could help.
> Thanks
>|||Thanks for the reply.
If it's a permission issue, then why the error message
didn't used to appear before?
Do you know how to find out the name of the SQL account?
Is it an account that was created by someone or is it
built in? Is it a domain account?
Thanks

>--Original Message--
>Amir\
>This is comment of Bill Cheng [MSFT]
>According to my check, "SpnRegister" is to register in
Active Directory.
>8344 indicates insufficient access rights to perform the
operation.
>According to my experience, if the account starting SQL
Server service does
>not have enough permissions, it may also this message:
SuperSocket Info:
>Failed to get Exclusive port use(MSAFD Tcpip [TCP/IP]) :
Error 10013 (An
>attempt was made to access a socket in a way forbidden by
its access
>permissions.).
>Could you check the account that starts SQL Server
service? Make sure it
>has enough permissions. Try to add it to LOCAL
ADMINISTRATORS group to
>check.
>For more information on DsWriteAccountSpn ,visit the
following Microsoft
>website:
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/netdir/ad/d
>swriteaccountspn.asp
>
>
>
>"Amir M." <anonymous@.discussions.microsoft.com> wrote in
message
>news:df0901c40b68$d7e17d80$a501280a@.phx.gbl...
Log
first
(LPC)) :
restarted
>
>.
>

No comments:

Post a Comment