SQL SA Account Question

SQL 2008

Can I change the SA account on a single database? or does it replicate to the whole of the database's
LVL 3
Bransby-ITAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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...
0
 
Lara FConnect With a Mentor EACommented:
SA account is for the server, not for particular database. What exactly you mean under "change SA account"?
0
 
Bransby-ITAuthor 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.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Take the quiz
 
Bransby-ITAuthor Commented:
I am assuming that there are dependency’s relying on the SA account which would need to be changed?
0
 
Bransby-ITAuthor Commented:
trofimoval...Sorry I ment password. I didnt think so but now I know.

Thanks guys.
0
 
Lara FEACommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.