cannot generate sspi context

Howdy,

Firstly, I have read through so much information on this, that my eyes are starting to bleed and I am right at the end of my rope with it all..

This issue has only started showing since I re-installed my dev box, so my server has not changed at all..

Server is 2003 with SQL 2005.

Dev box is

Vista (Ultimate)

Visual Studio Pro 2005..

A quick but painful solution is for me to log out of my box and then back in, but this is unworkable at times... about the only difference I can think of this install from the last is that now I have also installed SQLExpress on the dev box. I have gone into services and made sure that the service does not start auto. I have connection to the server and am running as administrator on both until such time as I can sort this out, but the error still occurs.

Authentication for the dbase is both windows and credential.

Can someone please give me a stratight out solution for this.

Cheers

So, do you actually have two problems ? Conencting to the server on the 2003 box and starting your SQL service on Vista ?

Jens K. Suessmeyer.

-
http://www.sqlserver2005.de
-|||

Howdy Jens,

I dont have either of those problems... I can connect to the box and I could stat the SQL service on Vista if I needed to...

The problem is that after about 20 minutes of logging on to the Vista machine, using the domain admin, all of a sudden any connection trying to be made to an SQL Database on the Server, using Visual Studio, a custom application etc, it generates the error message, "Can't generate SSPI".

In my mind, there is an issue with the authentication being used that is trashed on the Vista box.

I dont have this problem when accessing the server with a Laptop that also has Vista on it. The only difference between the two (the dev box and the Laptop) is that the Laptop doesnt have SQLExpress installed.

Cheers for any help.

|||

There are two pointer which can be important in your case:

http://blogs.msdn.com/sql_protocols/archive/2005/10/19/482782.aspx
http://support.microsoft.com/kb/811889

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks Jens,

I had seen those articles before but I missed the section on the DNS... I could kick myself right now....

I went into my network connections and changed the DNS settings and it would appear to be working correctly now... I will keep an eye on it, and let you know if it changes...

Thank you very much for your persistence with this matter.. I really appreciate it.

Cheers