November 12, 2008 at 11:07 am
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.
November 12, 2008 at 5:46 pm
Leo (11/12/2008)
A connection could not be established to LOCALReason : 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.
November 13, 2008 at 3:03 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply