I am trying to find out which password I have assigned to the user schema on my SQL Server 2000. I know that you can change the password but I've had some grief with that application in the past. I know where the password is stored, but it is in encrypted format. Is there any way of displaying the current password?
There isn't a method to reverse the password stored by SQL Server. If you're using mixed mode, you might be able to use a network sniffer to see the password zoom by on the wire, but your best bet is to change the password and deal with the consequences.
Dig Deeper on SQL Server Security
Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner."
Learn how to set a SQL Server password to an SA login and why you can not set this account for access to separate SQL Server databases.
Get the code to connect SQL Server version 7.0 to Visual Basic 6.0.