user mapping issue - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

user mapping issue

Author

Topic

Disco Patrick
Starting Member

18 Posts

Posted - 2009-10-01 : 11:24:30

I have made a backup of a db on a remote server. The remote server had a login called 'webapp' mapped to a user on the db called 'webapp'.

I have now restored the db onto a local server. The db still has the user called 'webapp'. On the local server there is already a login called 'webapp'.

How do I map the existing login on the local server to the existing user on the db?

If I try to do it through the SSMS UI I get the error:

quote:

Create failed for User 'webapp'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476

...but I'm not trying to create a new user!!! I'm trying to map to an exisiting user!!!

mivey4
Yak Posting Veteran

66 Posts

Posted - 2009-10-01 : 22:20:19

Commonly known issue.

Reference this for your solution:

http://msdn.microsoft.com/en-us/library/ms174378.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources