Renaming the SA login

• sandra pastrana

  SSC Eights!

  Points: 979

  More actions

  November 28, 2007 at 10:32 am

  #181580

  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

• Johan Bijnens

  SSC Guru

  Points: 134873

  More actions

  November 28, 2007 at 10:44 am

  #755050

  - 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