November 28, 2007 at 10:32 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 10:44 am
- first be sure you have other access as sysadmin (windows or another user)
- just give it a password you cannot remember (mixture and very long) 😉
- Create a new sqluser an add it to the sysadmins sql group.
- If you don't need to use sql-id's at all, give it the password mentioned above and then swith to windows only mode.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply