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?
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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 FEACommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.