Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jheds
Starting Member
17 Posts |
 Posted - 2006-12-28 : 09:07:58
|
| Hi Frnds, we have a demo instance for programmers to practice their new programs and forms etc. SQL SERVER is into use.now the 'sa' login and password for it 'sa'have been set.if we want to change this password to maybe 'adm', how can we achieve it?there is a demo financial database size 5GB residing on the SQL server. Will changing the 'sa' login have any effect on this database?Regards,Jheds |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-28 : 09:14:35
|
You can change it through EM or using stored proc - sp_password.Changin SA password won't affect the database, except in the case when you forget it!  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
homeri14
Starting Member
5 Posts |
Posted - 2006-12-28 : 09:17:15
|
| Jheds,Do you want to change the username from sa to adm or just change the password? Changing the password is easy however you should consult with your programmers to verify they are using this account and what will be impacted if you change the password. If you want to use an account such as "adm" the create this account and assign the needed rights. Most will tell you to never use the "sa" account for anything other than local server administration. Either way you should encourage your developers to code with another account. |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-28 : 22:00:50
|
never ever give the SA account details to any one other than those who are supposed to have them. quote:
Either way you should encourage your developers to code with another account.
why wld one give SA account to programmers? plz never do that instead assign roles to them, if every other person has the SA account then what is the fun in calling it SA.here are the ways to change SA password:To change the password from the command line on MSSQL Server :1)Open a command shell by selecting "Start"-->"Run...", and typing cmd in the Run dialog box. 2)Change to the directory in which the MSSQL utilities are stored Issue the following command where <newpassword> is the password you have chosen:osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa" or from enterprise manager1)Open the SQL Server Enterprise Manager2)Navigate to the "Logins" object under the "Security" folder on the SQL Server you wish to administer. Then, right click on the 'sa' account and select "Properties".3)enter a new password in the "Password" field under the "Authentication" options.its me monty |
|
|
|
Jheds
Starting Member
17 Posts |
Posted - 2006-12-29 : 00:56:58
|
| Harsh , Homeri & Monty,Thankyou guys so much .I really appreciate your help man :)Regards,Jheds |
|
|
|
Jheds
Starting Member
17 Posts |
Posted - 2006-12-29 : 08:00:26
|
| Hi , this is regrading the earlier topic of changing sa passwords.I am able to change this password from Enterprise manager and the other way is to run the sp_password file with required parameters.Our front end is Peoplesoft . and there are some password tables.We will have to also change some values there in the tables.can anyone help as to wheich tables will we have to update these values?Regards,Jheds |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-29 : 13:36:04
|
quote:
Originally posted by Jheds
Hi , this is regrading the earlier topic of changing sa passwords.I am able to change this password from Enterprise manager and the other way is to run the sp_password file with required parameters.Our front end is Peoplesoft . and there are some password tables.We will have to also change some values there in the tables.can anyone help as to wheich tables will we have to update these values?Regards,Jheds
You will need to contact your vendor for that information.Tara Kizer |
|
|
|
|
|
|
|
|
changing the sa login .