November 28, 2007 at 9:37 am
I will be renaming the SA login of my SQL 2005 server, and was wondering if any one has some advice about what I need to be aware of, and what the implications of renaming it are.
Will it automatically read the new name everywhere it is used? ex. Jobs?
Thank you for any advice you can give me
Sandra
November 28, 2007 at 7:08 pm
Internally, SQL should be using the login SID, so anything referencing the sa login should reflect the new name automatically.
If you have any custom procedures or views that reference the sa login by name, they will need updating.
Externally, if anything is using sa it will need to be updated to reflect the new name. An obvious note here - nothing should be using sa except the DBA, manually.
Other than that, test, test and test again.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
November 28, 2007 at 7:15 pm
I'd just change it, specifically so that things using it break and you change them to another account. As mentioned above, you shouldn't really be using this for much of anything.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply