p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   Stupid but true (http://p2p.wrox.com/showthread.php?t=6904)

Adam H-W December 5th, 2003 04:46 AM

Stupid but true
 
Hello there

I've forgotten my username/password for QA - does anyone know how to reset it?

Many thanks

Adam

jemacc December 5th, 2003 02:26 PM

well lets see!

1.Do you have the SA Account name/password. If you do there is your answer. If you don't see 2

2.Do you have another account with system administrator permission?
3.Are you using windows authentication?

if you the sa account you can access that user account to make changes to any account in your database
Using windows authentication, your domain account (if it has the permissions) already logs you in authentication.

if you are using SQL authentication, using the sa account or any other account with privileges. go to security, logins, right click user, under password type in new password then verify the new password. I hope this helps.



melvik December 6th, 2003 01:01 AM

forget SQL too:D

Adam H-W December 6th, 2003 12:16 PM

Great - got it - thanks a mill!


All times are GMT -4. The time now is 06:29 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.