SQL Connection Problem

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  November 12, 2008 at 1:24 pm

  #128693

  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.

• Oasis

  SSC Enthusiast

  Points: 101

  More actions

  November 12, 2008 at 11:58 pm

  #897907

  Is server administrator password changes recently??

  If yes, you have to reset the SQL password inside windows services.

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  November 13, 2008 at 3:00 am

  #897945

  Thanks.

  Not because of that, 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.

  Leo