Cannot map user to login in SQL Server 2005

Posted on 2008-11-14
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

    I figured it out. The user was in 2 databases. I guess you can only be in one.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    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…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now