Advertisement

03.24.2008 at 11:31AM PDT, ID: 23264835
[x]
Attachment Details

Can't open connection to SQL Express running on local domain box.

Asked by zorvek in SQL Server 2005

Windows XP SP2 on domain. SQL Express 2005. Named pipes and TCP/IP enabled. Services running under Local System.

I am getting the error "Cannot generate SSPI context" when opening a ADO connection with SSPI.

I can get the same ADO code to work on a workgroup Windows XP box with everything else equal.

Is there a way to set the security "mixed mode" option on in SQL Express? Do I have to install SQL Server Developer?

KevinStart Free Trial
 
Keywords: Can't open connection to SQL Expres…
Title
1 SQL Express Error "Cannot Generate …
2 Cannot Generate SSPI Context
3 Cannot Generate SSPI context
4 MS SQL ERRORS
5 SSPI Context errors
6 Cannot generate SSPI context
 
Loading Advertisement...
 
[+][-]03.24.2008 at 11:45AM PDT, ID: 21195742

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Sign Up Now!
Solution Provided By: tboy6423
Participating Experts: 1
Solution Grade: A
 
 
[+][-]03.24.2008 at 02:31PM PDT, ID: 21197146

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.25.2008 at 05:12AM PDT, ID: 21201078

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]04.22.2008 at 03:26PM PDT, ID: 21416170

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906