rename sa

Question

rename sa

ramyours2003

SSChampion

Points: 12268
More actions
August 7, 2020 at 2:59 pm

#3778214

i want to rename the sa login with different name , is the jobs will impacted if we rename the sa login ?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27055 More actions · Answer 1

If you are going to rename it, are you also going to disable it?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

ramyours2003 SSChampion Points: 12268 More actions · Answer 2

no i will not disable the login after renaming the sa .

Michael L John One Orange Chip Points: 27055 More actions · Answer 3

Ok, what are you trying to accomplish? I would recommend leaving sa as is, disabling it, and create a new login that is a sysadmin.

Are your applications or users logging in using this account???

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 4

Some things can be affected, some not. It depends if the underlying part of the system (SSMS or SQL), refers to the item by name or by SID. The SID is fixed. The name can change, but some things look for the name.

So, maybe.

ramyours2003 SSChampion Points: 12268 More actions · Answer 5

Thanks for the responses ..not sure whether the applicatoins will use the sa login .