Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NarayanaMoorthy
Starting Member
19 Posts |
 Posted - 2007-10-05 : 08:29:35
|
| Hai,I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?Narayanamoorthy |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:32:47
|
| Which step listed in the article did you try? |
 |
|
|
NarayanaMoorthy
Starting Member
19 Posts |
Posted - 2007-10-06 : 01:58:16
|
quote:
Originally posted by rmiao
Which step listed in the article did you try?
I tried pinging the ip address as well as default gateway.It worked fine and I got 4 replies back with 0% loss. I have Windows XP SP2 istalled on my computer and whenever I open SSMS I get a pop up message indicating "SSPI error context".Narayanamoorthy |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 12:26:58
|
| Do you use Kerberos? Did you check SQL Server Service Principle Name? Go through all steps listed in the article. |
|
|
|
|
|
|
SSPI context error message