SQL 2005: Login name must be specified. (SqlManagerUI)

Posted on 2007-08-02
Last Modified: 2008-09-12
Using SQL 2005

I go to a user to add tables for permissions but when I click okay I get

Login name must be specified. (SqlManagerUI)

The Login name is grayed out so I can't do anything about it.  
Question by:yanci1179
    LVL 5

    Expert Comment

    This sounds like you have Authentication set up as Windows and SQL but the user doesn't have a domain login.

    Author Comment

    how do i check /set up a domain login?
    LVL 5

    Accepted Solution

    You'd use active directory..if you don't know which server it's on ask your network admin
    LVL 2

    Expert Comment

    So you have to create a domain login for each SQL Server login? That sounds a little strange to me.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now