Solved

user is not in db user table but it is in sysxlogins table

Posted on 2009-05-06
5
264 Views
Last Modified: 2012-05-06
expert,

One user login it is in sysxlogins but It is not in the db user table, how can I
map this user from sysxlogins to user table? it was in db user table before.
I used,
EXEC sp_change_users_login 'Report', ( this user is not in report list)
EXEC sp_change_users_login 'Auto_Fix', 'LLCK\usr1'
EXEC sp_change_users_login 'Auto_Fix', 'usr1', ''LLCK\usr1'', 'password'

but none of work. Please help!!!!

0
Comment
Question by:yrcdba7
  • 3
5 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24319883
are you sure you run it on the user database /
0
 

Author Comment

by:yrcdba7
ID: 24320388
EXEC sp_change_users_login 'Auto_Fix', 'LLCK\usr1'

output is:
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.

2. then I ran this one,
sp_change_users_login 'update_one', 'LLCK\usr1', 'LLCK\usr1'

output is like,
Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 88
Terminating this procedure. The User name "LLCK\usr1' is absent or invalid.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24321688
are you sure you haven't forgotten to create the user in the database?

0
 

Author Comment

by:yrcdba7
ID: 24326211

Yes, I checked that DB, the user is in the DB.  If the user is not with domain I usually delete the user in DB and security login, then create it again, but I can not del it.  If I do, I have to ask windows team to create it again. I think it should have some idear to fix it.  but I tired above, it did not work.
0
 

Author Comment

by:yrcdba7
ID: 24326231

Is any way to map sysxlogins user to db users ?
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now