February 17, 2009 at 9:44 am
hi folks,
since we update SP3 we have been suffering many problems with our Sql Server 2005.
One is we can't connect to server through windows authentication (Cannot generate SPPI context), other is we can't consult the logs ( the message error is :failed to retrieve data for this request [Microsoft.SqlServer.SmoEnum]).
in event log we see this event:
"The description for event ID(17052) in Source (MSSQLSERVER) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use /AUX SOURCE = flag to retrive this description. The following information is part of the event:
Severity:16
Error:-2146893022
OS: -2146893022
[Microsoft][SQL Native Client] SQL Networks Interfaces: the target principal name is incorrect ".
we haven't changed more than update SP3.
thanks in advanced
regards
Th
February 17, 2009 at 12:10 pm
Try typing "localhost" or the server's IP address when you get to the "connect to server" prompt for management studio. You can also visit the following link for instructions on resolving this: http://support.microsoft.com/kb/811889
February 17, 2009 at 12:47 pm
use setspn -L at command prompt and see, if there is invalid SPN in active directory. Open a service call to active directory group to delete the invalid sql server spn from there.
most of times, this resolves the issue.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply