Unable to access database in SQL Server 2000

Last Post 19 Feb 2006 02:47 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
New Member
New Member

11 Feb 2006 03:45 PM
I have SQL Server 2000 running on a Windows 2000 server with
Service Pack 4. Recently, I have installed a customized software
which uses a SQL server database and front-end developed in Visual
Basic. This software has locked out the entire database / SQL server instance and I am
unable to access any of my database either through Enterprise
Manager or Query Analyzer. When I tried to log in through
Enterprise Manager to take database backup, the following message
appeared :

A connection could not be established to (server name).
Reason : Login failed for user (server name)/Administrator)
Please verify SQL Server is running and check your SQl Server
Registration properties (by right-clicking on the (sever name)
node and try again.

When I tried to login through query analyzer using sa login, the
following message appeared :

Unable to connect to server (server name) Server : Msg 18456,
Level 16, State 1 [Microsoft] [ODBC SQL Server Driver] [SQL
Server] Login failed for user 'sa'.

I need help regarding this. I need to access the databases on my
server to take backup, which I am not able to do now. I need to
know how can I reset the password back and access my databases.


New Member
New Member

19 Feb 2006 02:47 AM
Stop the application.

Reboot the server.

Probably the app puts the server into 100% cpu spin.

Kalman Toth, Database, Data Warehouse and BI Architect
The Best SQL Server 2005 Training in the World
You are not authorized to post a reply.

Acceptable Use Policy