Help.......

sql experts

[lbeaty]

Hi, I just signed up for this & please excuse me if I posted incorectly just getting going on this one.
I have a question. I am trying to verify my SQL
admin password but I can not seam to figure out
where to go..... can anyone point me in the correct direction -I thank you in advance so much.

I am trying to update this software as it bombed last week due to the SA password. The designers of the software changed it on me.

I would like to check it that I have the correct one just can't seam to find it. I am running SQL 5.0 on Server 2000.

Thanks you so much!

[Dreamquick]

There is no way to "verify" your MS SQL admin password other than with a sucessfuly login - it's not displayed anywhere in plaintext, and in order to even get access to the table you need to be able to log in as an admin level user.

If you've lost the password (your post is a little unclear on the exact scenario) then you need to either log in to the database as another SQL-level admin user and change the admin login, if you can't do that your only other alternative would be to either attempt to guess / brute force the password.

You suggested that the designers of the software changed the SA password - if this is the case then your first stop should be to talk to them. If they have gone out of their way to keep people out of the database then it's likely they have chosen a password that isn't easily broken.

- Tony