SQL SA Account Question

Bransby-IT
Bransby-IT used Ask the Experts™
on
SQL 2008

Can I change the SA account on a single database? or does it replicate to the whole of the database's
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
No, you can't change the password for a single database.
Instead create a new credential similar with sysadmin rights and set the password accordingly...
SA account is for the server, not for particular database. What exactly you mean under "change SA account"?

Author

Commented:
Well I have just arrived at a company and most of the users have the password for the SA account?

Thanks, I thought so.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
I am assuming that there are dependency’s relying on the SA account which would need to be changed?

Author

Commented:
trofimoval...Sorry I ment password. I didnt think so but now I know.

Thanks guys.
This is not good practice to have everyone use sa.
Check what users need to do DBs, then you can give them specific rights.
Usually giving user "DB owner" rights on particular DB allow to do anything they need but  just with this DB.
Some may just be just fine with read/write

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial