user id already exists (Microsoft SQL Server, Error:15025
I have a user who is using the application except for one view she cannot get access to.
she has rights to it in the application however, when look at the sql users she is not there as the integrated windows login or as a user under the database
when I try and recreate her I get
The server principal 'mydomain\goldiee' already exists. (Microsoft SQL Server, Error: 15025)
any suggestions on how to resolve
she has rights to it in the application however, when look at the sql users she is not there as the integrated windows login or as a user under the database
when I try and recreate her I get
The server principal 'mydomain\goldiee' already exists. (Microsoft SQL Server, Error: 15025)
any suggestions on how to resolve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
CREATE LOGIN [MY DOMAIN\goldiee] FROM WINDOWS
Msg 15025, Level 16, State 2, Line 1
The server principal 'MYDOMAIN\goldiee' already exists.
Yet when i run the following query
SELECT name, sid FROM sys.server_principals where name = 'mydomain\goldiee'
I still get no results.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have been reading this articile but its not helping my issue, I have tried to create the user but like it said she already exists, but when you select using
i get no results.
SELECT name, sid FROM sys.server_principals where name = 'mydomain\goldiee'
strange thing is she can use the application fine, but not some of the customised views.
i get no results.
SELECT name, sid FROM sys.server_principals where name = 'mydomain\goldiee'
strange thing is she can use the application fine, but not some of the customised views.
have you checked for orphaned users?
run this
EXEC sp_change_users_login 'REPORT'
see http://sqlblog.com/blogs/eric_johnson/archive/2008/10/17/fixing-orphaned-users.aspx
run this
EXEC sp_change_users_login 'REPORT'
see http://sqlblog.com/blogs/eric_johnson/archive/2008/10/17/fixing-orphaned-users.aspx
ASKER
yes ran this script
EXEC sp_change_users_login 'REPORT'
but got no results
EXEC sp_change_users_login 'REPORT'
but got no results
ASKER
the user had got married and nobody told me there was a name change...
ASKER
i have also ran the statement on sys.server_principals
SELECT name, sid FROM sys.server_principals where name = 'mydomain\goldiee'
and got no results.