Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-14 : 08:04:31
|
| S. K. Bhaduri writes "I have SQL Server 2000 running on a Windows 2000 server with Service Pack 4. Recently, I have inatalled a customized software which uses a SQL server database and front-end developed in Visual Basic. This software has locked out the entire database 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.Thanks" |
|
|
|
|
|
Unable to access database in SQL Server 2000