N/APosted on - 05/26/2014
When I am trying to connect my system through a MS Access tool to a Virtual Machine, which has SQL server installed. The error says the connection failed and it cannot generate SSPI context. How do I login in Server now? Please help me to establish a connection. Hunting for solution, please help me. Your help is great. Thanks.
Microsoft SQL Server Login
SQL State: ‘S1000”
SQL Server Error:0
[Microsoft][ODBC SQL Server Driver] Cannot generate SSPL context.
Microsoft ODBC SQL Server Driver Cannot generate SSPL context
The following general steps should help you resolve this issue:
Verify that the domains, your system and the target, you are using can communicate.
Configure the SQL server to spawn SPNs (Service Principal Names) dynamically by changing access settings in the Active directory.
Verify that both the server and client are properly configured for use by checking all settings, hardware, and software for appropriate conditions.
Manually create a Service Principal Name for the SQL server.
Essentially, you must check your system at all points and perform deep analysis. The instructions provided here are obviously not at the level of detail you need. You must consult software documentation for further instruction.