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 |
|
skbhaduri
Starting Member
3 Posts |
 Posted - 2005-10-12 : 08:24:30
|
| 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 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-12 : 10:44:55
|
| Are you saying the installation of this software actually changed the sa password, and dropped BUILTIN\ADMINSITRATORS? Can you log in with anything besides sa? Any other application logins? That will at least get you as far as seeing if BUITIN\ADMINSITRATORS was actually dropped. If so, I would consider this a real breach of ethics on the part of the people who wrote the software installation. They probably run their app as sa, too. Check the documentation for any word about security, to see if they own up to what they are doing. |
 |
|
|
skbhaduri
Starting Member
3 Posts |
Posted - 2005-10-13 : 01:22:08
|
| I went through the documentation of the software - it says that there is "enhanced security in this version of the software". To test if I am able to log on using any other login, I created a separate login before installing the software with full administrator rights. However, after installing the software, I am not able to log in using that user too. Please help me. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-13 : 09:10:22
|
| I smell a guy who went by the name poncho... Or someone very like him. But that is beside the point.I think you might be looking at trying to restore the master database from before the installation. That will get you into the server, and able to run any other databases you have on this server. When you go to try installing the software again, you should have an administrator connection open to the server at all times. Even if they change sa's password, you should still be able to use that connection to reset sa's password back. And re-add nt logins to the sysadmin group. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-13 : 14:44:17
|
quote:
Originally posted by skbhaduri
I went through the documentation of the software - it says that there is "enhanced security in this version of the software".
A program changing your server logins (if in fact it did) is not 'enhanced security" it is sabotage. Is there any documentation about what the enhanced security is or would do? Any warning?---------------------------EmeraldCityDomains.com |
|
|
|
skbhaduri
Starting Member
3 Posts |
Posted - 2005-10-13 : 22:53:52
|
| There is no details about this "enhanced security" in the documentation of the software. Installing this software ahs led me into deep trouble, as all my other softwares, working on SQL Server 2000, have stopped working now, and I have no method in sight to recover back the databases. I am in desparate need for help.Thanks |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-14 : 09:35:12
|
| If everything is failing with login failed errors, then you will have to restore the master database to a time before the installation. BOL is pretty good at describing the steps required. |
|
|
|
|
|
|
|
|
Unable to access my database in SQL Server 2000