• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

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
0
Bransby-IT
Asked:
Bransby-IT
  • 3
  • 2
2 Solutions
 
Raja Jegan RSQL 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 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now