November 13, 2010 at 2:52 am
Hi!
I have recently installed a Microsoft SQL Server 2008 Workgroup Edition (64-bit) on Windows Server 2008 R2 Foundation and noticed that at every restart of the windows server causes the following error messages in SQL Server Agent error log:
[298] SQLServer Error: 773, SQL Server Network Interfaces: The requested security package does not exist [SQLSTATE 08001]
[298] SQLServer Error: 773, Client unable to establish connection [SQLSTATE 08001]
[298] SQLServer Error: 773, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [SQLSTATE 08001]
[382] Logon to server '(local)' failed (SaveAllSchedules)
What could be the problem? Any ideas?
Thank you!
November 13, 2010 at 5:09 am
Does the SQL Server Agent service start? If not check if the SQL Server Agent startup account has "sa" rights on the instance.
If SQL Server Agent starts, check if any of the jobs are failing at that time.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 24, 2010 at 4:50 am
Yes it starts. This events occur only when restarting or shutting down the server.
November 24, 2010 at 12:18 pm
Since this error message is not affecting SQL Agent, I assume that some job which was executing during the server restart is causing these messages to be logged.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply