12 กรกฎาคม 2553 6:19
I have upgraded SQL SERVER 2000 standard edition server to SQL server 2008 with SP1 standard edition. No errors noticed. OS is Windows server 2003 with sp2, Service accounts are configured using domain user account, and mixed mode authentication is enabled.
Both windows and SQL authentications are working fine from the local (server), able to access all SQL server resources.
Server is accessible remotely using SQL authentication, but unable to connect with windows authentication, though user has local admin and SQL admin rights on the server.
Let me know any solutions for this. Appreciate your support
12 กรกฎาคม 2553 6:45I have seen once that date and time were different on the server and client machine...
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
12 กรกฎาคม 2553 7:07
Thanks Uri for the quick response. I matched the clinet date time with the server date time, still the same error.
12 กรกฎาคม 2553 8:06
Have you changed your Windows password before you try to connect to the SQL box? If you did, try to log off and log in again. If the problem still persists, try this article for troubleshooting.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.
12 กรกฎาคม 2553 18:33
I reset the windows password but no use. Also i tried this document already , it is also not helping me with my situation.
13 กรกฎาคม 2553 15:58Problems with Kerberos authentication often result in SSPI errors. For hints about the root problem, look in the Windows event log for other errors near the SQL Server authentication attempt.
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
28 กันยายน 2553 11:06I'm having the same problem. I've uninstalled and reinstalled SQL to no avail.
28 กันยายน 2553 16:22Is this error for every user or only some users? Have a read at this article; SSPI Context errors are pain to resolve in most cases.
- เสนอเป็นคำตอบโดย Ramshna 29 กันยายน 2553 22:14
29 กันยายน 2553 22:19I faced this issue lot of times. This error is displayed due to issues with kerberos authentication, especially when you are using domain account to run the SQL services. You can refer to http://support.microsoft.com/kb/319723 for more info.
23 พฤศจิกายน 2553 2:43check your SQL Server's registered ServicePrincipalNames on AD using SETSPN.exe and remove entries starting with MSSQLSvc - looks like SQL2008 don't like them
12 มกราคม 2554 6:03I am getting same error but in Windows server 2008 standard edtn installed, SQL server 2008 Standard edition
"SQLSERVER DBA" "INDIA"
8 กุมภาพันธ์ 2554 0:53
Make sure that the account that runs SQL Server Service has the correct password -I was getting the same error after changing the account password-. Note that with the wrong password, the server was running fine , Both windows and SQL authentications were working fine from the server, and Server was accessible remotely using SQL authentication.
8 กุมภาพันธ์ 2554 13:15
This solve my problem!! :)
5 พฤษภาคม 2554 1:27
I know this is a little old, but thanks for the info. I was receiving the same "Cannot generate SSPI context" error message. After I set all my SQL services to LogOn as Local System, everything started working correctly. I plan on testing Step 3 from Ramshna's link (http://support.microsoft.com/kb/319723) some day soon, once our AD admins are available for consult. Hopefully all works out correctly.
17 กุมภาพันธ์ 2555 6:19I received this error
and solved by restarting "DNS Client" service from services.msc
26 กันยายน 2555 9:53
Thanks Sherwyn this working for me ..
a remove the all the MSSQLSvc in the ServicePrincipalNames, then i reboot the sqlserver.
and it's working
21 พฤศจิกายน 2555 19:36Can someone give me a understandable resolution to this problem, I cannot reboot my server everytime my VPN has droped. I am not an SQL Server expert. But, I now when the VPN has reconnect after ADSL line has droped and my server reconnect to the host domain and works fine. Why does the SQL server replication not want to reconnect to the Host server?
21 พฤศจิกายน 2555 20:47
Suggest that you start a new thread for your question.
If you do, plesae provide additional details such as Windows and SQL Server versions, protocols in use, and so forth. Also describe your replication landscape. Since replication is your problem, you probably want to post your question at this forum: