Cannot generate SSPI context---MS SQL ERROR

时间:2023-03-10 01:50:38
Cannot generate SSPI context---MS SQL ERROR

http://www.cnblogs.com/newr2006/archive/2011/08/25/2153253.html

Additional error information from SQL Server is included below.  Cannot generate SSPI context.

ConnectionString:'Data Source=sqlxxxxx;Initial Catalog=master;Integrated Security=True;Pooling=False;Asynchronous Processing=False;ConnectTimeout=15'

Cannot connect to database master at SQL server at sqlxxxxx. The database might not exist, or the current user does not have permission to connect to it.
 which manually add the service principle name for each SQL VM, which resolved the issue:

setspn -a MSSQLSvc/<SQLVMName>.cnblogs.com:1433 <SQLVMName>.
setspn -a MSSQLSvc/<SQLVMName>.cnblogs.com <SQLVMName>.

restart the sql services

~~~~~~~~~~

ADSI相关属性值如下:

Cannot generate SSPI context---MS SQL ERROR