Error with SQL Server 2K5 "Cannot connect... Instance failure" -- sql server new users

ATJaguarX
2/20/2006 2:12:54 PM

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.

"Cannot connect to SERVER\SQLEXPRESS

Additional Information:
Instance Failure. (System.Data)"

Any help would be greatly appreciated.

ATJaguarX
2/20/2006 2:18:58 PM

One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".

So...

I stopped the following services and restarted them:

MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser

and it finally let me start "SQL Server (SQLEXPRESS)" !!

After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?

sql server new users : Error with SQL Server 2K5 "Cannot connect... Instance failure"