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
Go to Top of Page
   

- Advertisement -