Monday, February 13, 2012

'sa' User Map error

Hello all,

I'm having a problem with my sa account, we just migrated from sql server 2000 to sql server 2005 and 1 of our production applications is failing on the sa login.

I checked the 'User Map' setup to the 'sa' account and the databases that need accessing aren't mapped.

When I try to add the map, I get error "Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)". I get the same error when trying to remove a user map for sa (there are a couple db's already mapped), and I don't remember how I mapped them in the first place, but it certainly isn't working now!

Thanks in advance,
102020

What is ther error that you get back and for waht operation do you get it back? Please also check the server error log and copy the relevant errors logged there.

Thanks
Laurentiu

|||I have fixed this already, thanks though.

The problem was that the db owner was the domain admin and not sa, so I couldn't change the mapping.

Thanks,
102020
|||

Hi,

I have the same problem. I am trying to add sa to several databases created by other users than sa. We are getting error 15405:cannot use the reserved user or role name 'SA'.Microsoft SQL-DMO (ODBC-SQL State:42000)

Is there no solution to this problem? We are using SQL Server 2005

Regards Caroline|||

I found the solution!! Quit simple: exec sp_changedbowner 'sa','true'.

Thanks anyway

|||

Hey,

I find out how to change it using Management Stadio Express:

Right click the database to show properties. then change the owner under files to sa

then you can map it under Logins .

|||Caroline, thanks for posting this - it really helped me out!
|||Thanks Caroline, I've been searching for hours on how to do this, I kept geeting same as as above posts.

No comments:

Post a Comment