Solved

Got error in UserMapping

Posted on 2011-02-22
4
205 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
Comment Utility
0
 

Author Comment

by:lapucca
Comment Utility
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
Comment Utility
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
Comment Utility
Glad it worked !!!!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 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

15 Experts available now in Live!

Get 1:1 Help Now