Change SA Password
-
Can someone please show me how to change the SA password? Running SQL2K I guess it has been absued and I need to change it ASAP.
Regards,
CEWalden -
Take a look at sp_password in BOL or sa -> password in BOL.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Enterprise manager --> right click SA, go to properties, type the new password in the password box, hit ok, type the new pwd again.
-
Walden,
Both Frank and Stacenic gave options for changing the SA password but also “IF” the sa password has been abused in the past you may have DTS packages and Jobs that are relying on the SA account. Before you change the password make certain that you are not negatively affecting these services before changing the account password. In some cases it’s a simple changing of the account that is used for these packages and jobs (including Replication) <Frank if you change the sa account password and DTS packages are running this will cause problems if you do not reset the Connection information and Transformations correct?)… Also if you need to secure the server from outside connections using the widely known SA Account you should not allow remote connectivity to the server after informing all client’s /Developers and etc. that the server will be unavailable. Though Stacenic's option is faster (GUI) its nice to know the commands to make these changes.
Again the T-sql Syntax to change a password is
--This changes the password for the login Cletus to redneck.
EXEC sp_password NULL, 'Redneck', 'cletus'
--Change a password
--This changes the password for the login Cletus from redneck to neck.
EXEC sp_password 'redneck', 'neck', 'cletus'
As per Frank's comments always reference BOL in any event...:sick:
Jbabington
Jbabington@hotmail.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply