Microsoft ODBC SQL Server Driver Cannot generate SSPL context

Asked By Miguel M Burch 50 points N/A Posted on - 05/26/2014

Hi,

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

Connection failed:

SQL State: ‘S1000”

SQL Server Error:0

[Microsoft][ODBC SQL Server Driver] Cannot generate SSPL context.

• Status: Open
• Question Views: 1361
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Nortan gabriel 5 points N/A #170593

Microsoft ODBC SQL Server Driver Cannot generate SSPL context

Hello,

 

The following general steps should help you resolve this issue:

 

1. Verify that the domains, your system and the target, you are using can communicate.

2. Configure the SQL server to spawn SPNs (Service Principal Names) dynamically by changing access settings in the Active directory.

3. Verify that both the server and client are properly configured for use by checking all settings, hardware, and software for appropriate conditions.

4. 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.

About Nortan gabriel

Questions
0

Answers
157

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/29/2015
• Question Category: MS SQL Server