How to RESET SQL SERVER DATBASE PASSWORD?
Hello,
I've an application which uses a database running on SQL Server 2000. I forgot the administrator login to the database, so that I can't login into the application. I opened the SQL Manager and changed the password to SA user. But I can't find the username for Administrator.
I think the application stores password inside the database itself. Is there any way to reset the login password to the database?
Any help would be greatly appreciated. Thank you.
I've an application which uses a database running on SQL Server 2000. I forgot the administrator login to the database, so that I can't login into the application. I opened the SQL Manager and changed the password to SA user. But I can't find the username for Administrator.
I think the application stores password inside the database itself. Is there any way to reset the login password to the database?
Any help would be greatly appreciated. Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ied_servername should read copied_servername.
(My keyboard doesn't spell well. :-D )
(My keyboard doesn't spell well. :-D )
ASKER
I think you guys misunderstood my question. I need to reset the password for a custom database! I've a TopsData database in SQL Server. I can login into SQL Server Manager tool and even I can change the password for SA or create another user.
But I'm looking for a way to reset the custom logins for the database! The database itself stores logins for users!
But I'm looking for a way to reset the custom logins for the database! The database itself stores logins for users!
Once you have the sa password you can change any user in any database.
The user passwords for the application will be in a table and they might even be plain text.
The user passwords for the application will be in a table and they might even be plain text.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've the database in working stage. I spoke with the application provider and they told me that I need to modify the table to reset the password for an Administrator, so that I can login into the software as an Administrator.
I think, I need to check all tables for login details! :(
I think, I need to check all tables for login details! :(
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I frequently use one I call Permissions; however, as Number-1 has indicated, the tables are usually fairly obvious . . . unless the software provider is extremely paranoid. ;-0
ASKER
It's look different in SQL Server 2000 Manager. I will import it into SQL Server 2005 or 2008 and look for log-in table. Is there any identifies or commands to look for "something" in the database? I mean, Is there any option to search for "something" in the tables? Sorry, I'm completely novice to SQL!
Thanks to everyone for your support.
Thanks to everyone for your support.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The above command will try to connect to database ied_servername using a Trusted Connection (-E). Now, if that Trusted Connection doesn't happen to be able to execute system stored procedures, then you will probably not be able to do the next command that was provided. So, you will need to be logged onto your system as a Windows User that has admin privileges.
I sure wish that I could reply privately because there is a way to reset the sa password without having any access to the database but I don't want to post it here where any hacker could stumble upon it. :-D