Solved

Got error in UserMapping

Posted on 2011-02-22
4
212 Views
Last Modified: 2012-06-22
I attached a  database file and I keep getting the attached screen shot error.  I tried changing the database to a different name when attaching and still get the same error.  How to fix this?  Thanks.  I'm using sql 2005 Express.
sqlErr.jpg
0
Comment
Question by:lapucca
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
santoshmotwani earned 500 total points
ID: 34957235
0
 

Author Comment

by:lapucca
ID: 34957284
Hi Santos,
That link is kind of confusing for me.  I'm not sure what to follow or do I do all the steps and create/run the 2 sp to fix my problem?  Thanks.
0
 

Author Closing Comment

by:lapucca
ID: 34957294
Got it!  I follow the 2nd method and just drop the existing user then re-assign permission.  thank you.
0
 
LVL 16

Expert Comment

by:santoshmotwani
ID: 34957361
Glad it worked !!!!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 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