Cannot map user to login in SQL Server 2005

Posted on 2008-11-14
Medium Priority
Last Modified: 2012-05-05
I have am in the process of trying to learn how to convert Access 2003 tables to SQL Server 2005 and link the tables to my Access frontend. I am new to SQL Server 2005.

I have SQL server set up using Windows Authentication mode. I have a database called db7 that I converted from Access 2003. I created a Login in Sql server called domain\username. However  under Login properties Security->Logins->User Mapping, I cannot select my database db7. When I select it, there are no error messages but when I open that page up again, it is no longer selected.

I can successfully select other databases.

Under db7->Security->Users, I have created a user with the same name domain\username and it is pointing to the correct database db7 (Extended Properties).

When I look at the properties for that database db7 (right click properties), when I go to Permissions, I cannot add the user either. Again it appears I'm adding it successfully (no error messages) but when I go back in, the user is no longer there.

Question by:mph23
1 Comment

Accepted Solution

mph23 earned 0 total points
ID: 22965600
I figured it out. The user was in 2 databases. I guess you can only be in one.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

578 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