SQL Server Pasword Changing
-
Dear friends, My SQL server was configured during its setup stage with userid = sa and password = sa. It means that any client application can access SQL server with this userid and password. Now i want to change the password. but i dont know from where to change it. I opened "Enterprise manager". From "tools menu" i select "SQL Server Configuration properties". Then i select "Security" tab. But there is no such option of changing the password. Please tell me how can i change the pasword for my SQL server. Also i want to change from SQL server authentication to domain user authentication. How can i do so ? Imtiaz
-
Dear friends, My SQL server was configured during its setup stage with userid = sa and password = sa. It means that any client application can access SQL server with this userid and password. Now i want to change the password. but i dont know from where to change it. I opened "Enterprise manager". From "tools menu" i select "SQL Server Configuration properties". Then i select "Security" tab. But there is no such option of changing the password. Please tell me how can i change the pasword for my SQL server. Also i want to change from SQL server authentication to domain user authentication. How can i do so ? Imtiaz
hi Imtiaz, Go to Enterprise Manager... Expand the left tree control and navigate to the database for which you want to change the password... Under the database name node u will find Users Click users and in right pane you will find the user "sa" right click and change property... I guess I have told you the right navigation.... because I don't have SQL server or client installed on my machine... itz not open infront of me... so sorry if I have told anything wrong... but the basic funda is: for each database therez a user section under which user list can be found... Hope this solves your prob... regards, Aryadip. Cheers !! and have a Funky day !!
-
Dear friends, My SQL server was configured during its setup stage with userid = sa and password = sa. It means that any client application can access SQL server with this userid and password. Now i want to change the password. but i dont know from where to change it. I opened "Enterprise manager". From "tools menu" i select "SQL Server Configuration properties". Then i select "Security" tab. But there is no such option of changing the password. Please tell me how can i change the pasword for my SQL server. Also i want to change from SQL server authentication to domain user authentication. How can i do so ? Imtiaz
Aryadip's answer is close: In Enterprise Manager, expand the node for the server, then expand "Security", then click on the "Logins" node. In the list of logins you'll see "sa." Right-click on the login and select "Properties." About halfway down the dialog you'll see the password box where you can type in a new password. On a side note, it's really not a good idea to use the sa (System Administrator) account for normal application access. You should create special limited-access accounts for your apps, or use Windows Authentication and manage users' database access through their login accounts.
Grim
(aka Toby)
MCDBA, MCSD, MCP+SB
-
Dear friends, My SQL server was configured during its setup stage with userid = sa and password = sa. It means that any client application can access SQL server with this userid and password. Now i want to change the password. but i dont know from where to change it. I opened "Enterprise manager". From "tools menu" i select "SQL Server Configuration properties". Then i select "Security" tab. But there is no such option of changing the password. Please tell me how can i change the pasword for my SQL server. Also i want to change from SQL server authentication to domain user authentication. How can i do so ? Imtiaz
You can use sp_password in the Query Analyzer the sintaxys is as follows sp_password [ [ @old = ] 'old_password' , ] { [ @new =] 'new_password' } [ , [ @loginame = ] 'login' ] the extra parameter is for the System Admin to change others people's passwords ex: sp_password 'sa', 'whateveryouwant'