Prev: KB955706 Error Code 0x2B2F
Next: SQL 2008 Installation Error - There was an error generating the XML document. Error code 0x84B10001.
From: Jeffrey Williams on 16 Nov 2009 22:35
You can run the following to identify what login is associated with each
database principal.

Select u.name As [Name]
,u.principal_id As [ID]
,isnull(suser_sname(u.sid) ,N'') As [Login]
From sys.database_principals As u
Where u.type In ('U' ,'S' ,'G' ,'C' ,'K');

Jeff

"Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message
news:Xns9CC569EA4D087Yazorman(a)127.0.0.1...
> Chuck (no-spam-for-me(a)cfcug-dotcom) writes:
>> I got the following error when I executed the create statement against
>> the
>> database.
>> CREATE LOGIN RPS WITH PASSWORD = 'yourchoicehere'
>> Msg 15025, Level 16, State 1, Line 1
>>
>> The server principal 'RPS' already exists.
>
> Well, I'm sitting on a distance and have to guess what is goin on.
>
>
>> If I try to update it I get this error...
>>
>> USE RPS
>> GO
>>
>> EXEC sp_change_users_login 'update_one', 'RPS', 'RPS', 'password'
>> GO
>>
>> Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 108
>> Terminating this procedure. The User name 'RPS' is absent or invalid.
>
> So what if you use ALTER USER as I suggested in an earlier post?
>
>> If I run this EXEC sp_change_users_login 'Report'
>> I get no records returned.
>> If I run this SELECT * FROM sys.database_principals
>> I get back 15 rows with RPS being one of them.
>
> Can you post the full output from
>
> SELECT suser_sname(sid), *
> FROM yourdb.sys.database_principals
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

First  |  Prev  | 
Pages: 1 2 3
Prev: KB955706 Error Code 0x2B2F
Next: SQL 2008 Installation Error - There was an error generating the XML document. Error code 0x84B10001.