Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5634
  • Last Modified:

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

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.  
0
yanci1179
Asked:
yanci1179
  • 2
1 Solution
 
gigglickCommented:
This sounds like you have Authentication set up as Windows and SQL but the user doesn't have a domain login.
0
 
yanci1179Author Commented:
how do i check /set up a domain login?
0
 
gigglickCommented:
You'd use active directory..if you don't know which server it's on ask your network admin
0
 
jfkruegerCommented:
So you have to create a domain login for each SQL Server login? That sounds a little strange to me.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now