Updating Sa account - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Updating Sa account

Author

Topic

shareen
Starting Member

6 Posts

Posted - 2014-12-17 : 07:52:24

Hi all

I am trying to update the user mappings on the sa account but I get the following error:

Create failed for User 'sa'

An exception occured while exuecting a Transact-SQL statement or batch. Cannot use the special principal 'sa'

Shareen

skhalil

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-12-17 : 08:57:05

sa account by default has access to all the databases on the server.
you cannot change the mappings for sa

if you are concerned about the database security,you may want to create users with access to particular database only.

Javeed Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources