Hi All
I have a software developed by someone using sql2005 as backend
Now i have to develop a new software which retrieve some data from existing Database
now my developer want the password of sa, we cant reset sa password , because if we reset the sa password the older software will stop working
Please help
thank you
If you just want to write a new application to interact with the database, then your best choice is to create a new user. Setting up applications to interact with the database using the sa account is a hugely bad practice.
You can't reverse-engineer it. Run SSMS as a Windows account that is in the Administrators group on the Windows server hosting SQL. Then you will be able to connect to SQL with sysadmin rights, and be able to grant access to developer's login.
You cannot retrieve the 'sa' password. That's a security feature, by design. If you've lost it, you'll need to change it. If an app was written using it, I would very strongly advise you to get that app changed. That is one of the primary means of hackers and viruses to steal or corrupt your data. I'll bet that app uses inline dynamic sql as well doesn't it?
Like Matt said, the best solution is to create another user. Sooner or later an auditor will force you to forgo all use of sa
or
If the connection is not encrypted, run WireShark and sniff the password off the network. This probably violates your network security policy, so check first (grin). Start a capture and run your app that connects to the db. Look for the tabular data stream packets. There will be a login packet. In the packet details window you will see something like this:
Login Packet Header Lengths and offsets Client Name: ADMIN-PC Username: sa Password: SSC App Name: .Net SqlClient Data Provider Server Name: 192.168.1.102 Library Name: .Net SqlClient Data Provider Database Name: NFL
