SQL Server Cannot connect anymore

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  November 12, 2008 at 11:07 am

  #99335

  Hi,

  My production server is suddently stopped and I am getting the following error.

  A connection could not be established to LOCAL

  Reason : Cannot Open user default database. Login failed.

  Pelase verify the sql server is running.........

  I checked the event viewer on my win server but I couldn't find anything strange. I got the follwing message in event viewer. Do you think becasue of this? Please explain........

  Event Type:Information

  Event Source:IPSec

  Event Category:None

  Event ID:4294

  Date:12/11/2008

  Time:12:14:00

  User:N/A

  Computer:ALPHA

  Description:

  The IPSec driver has entered Secure mode. IPSec policies, if they have been configured, are now being applied to this computer.

  Any Idea?

  Thanks.

• JeremyE

  SSCoach

  Points: 16261

  More actions

  November 12, 2008 at 5:46 pm

  #897850

  Leo (11/12/2008)

  ---

  A connection could not be established to LOCAL

  Reason : Cannot Open user default database. Login failed.

  Pelase verify the sql server is running.........

  Sounds like the default database for the SQL login was deleted/corrupted/recovering. If SQL is not running I would think something happened to the master db which is probably the deafult database for the SQL login.

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  November 13, 2008 at 3:03 am

  #897947

  Yes indeed.

  I took old database offline and users 'sa' and 'builtin\Administrator' default database is assign to one of the offline database. That's why I can't get back in anymore.

  But problem is now fix. I have applied PC\Administrator account to 'Master' in Osql. Now it works. Also bring that db online again. I hope should be all ok.

  ** strange things is - I don't understand, why SQL is not coming up the message when I took the db offline.

  Thanks.

  Leo