Connection inconsistency - SQL 2005 1

[Glasgow]

I am having problems connecting to a SQL 2005 Express instance using Windows authentication.

I can consistently connect using SQL Server Management Studio Express and run queries etc without problems. However attempts to connect with OSQL using:

osql -E -Smypc\sqlexpress

are inconsistent - sometimes they work, sometimes I get a "Cannot generate SSPI context" error message.

I also get similar inconsistency when trying to connect with Visual Basic (VB6). In all cases I am attempting to use Windows Authentication - I supply no username or password.

I cannot tie this down to any sequence of events. Everything tends to work fine for a while then it fails and I either have to reboot or wait a while until the problem 'disappears'.

I have SQL 2000 Development edition installed on the same machine which may or may not be relevant.

Any ideas?

 

[mrdenny]

SMO has been superceeded with DMO (I beleive).

The error "cannot generate SSPI context" means that your SQL Server is having problems talking to the domain controller. Typically this error will popup when you have changed the password of the account that the SQL Server runs under and you have not yet restarted the SQL Server services. It can also popup if there were network issues talking to the domain controller that SQL has latched on to, and it hasn't failed correctly to another one. A SQL Service restart will typically correct this issue.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Glasgow]

I think SMO is the new one and DMO older - if that's what you mean.

Anyway, I have taken the plunge and uninstalled both SQL 2000 and SQL 2005 (Express) and reinstalled both. It's been running for a few hours without incident so, fingers crossed, let's hope the problem has gone away.

Many thanks for all the help along the way.

 

[mrdenny]

Yeah, that's what I meant.

My statement should have read "SMO has superceeded with DMO (I beleive)."

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Glasgow]

Fair enough! You earned a star I reckon. Thanks again.

Things ran all day yesterday without incident so I am now hopeful. If the problem returns (please god no!), I'll revive the thread.

 

[mrdenny]

thanks.

Some days the fingers are faster than the brain.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com