Creating a Login

Hi;

This may not be the correct location for this thread; but it does relate to what I'm trying to do.

I have SQL Server [2005] setup on a Windows XP pro system. I also have Windows 2003 server setup (on another system). I want to setup a login account for SQL Server using a domain account (defined on the Windows 2003 server configured with Active Directory). When I open locations list in the new Login dialog box I only see the local system [computer name]; no domain is listed [in the list].

Now I can see the other computers on the network (all registered with the domain managed by active directory); and can access the other computers (via domain account signon credentials), My guess is that things are setup properly.

What I'm not getting is how do I use domain accounts when setting up a new login for SQL Server. I have read a bunch of things and tried them all (like making sure DNS is installed on server system; loginig on to SQL Server machine with domain account) but nothing seems to work.

So my question is; does anyone know what I'm missing here -- should I be able to see the domain listed in the location list for SQL Server (that is installed on a XP system)?

Peter

hi peter,

Your windows XP should be a member of the domain.

In short, you should be able to login to the domain from your XP box.

for instruction on joining a domain please consult this links.

http://www.windowsnetworking.com/articles_tutorials/wxpjoind.html

thanks,

joey

|||

Hi;

I guess my question was unclear. All computers in the network are part of the domain. I'm not looking at how to connect an XP box to the domain; as my question stated; I am looking for information on creating a login account in SQL SERVER 2005 using a domain account. The problem I'm having is I cannot see any domain listed in the location list when creating thew new login for SQL SERVER.

Peter

|||

is this what u r looking for?

CREATE LOGIN [YourDomainName\DomainUserName] FROM WINDOWS;

Madhu

|||

Hi;

Wasn't looking for script. I am using SQL Server Management Studio and I am creating a new login from the new login dialog. One of the options in the new login dialog is a search (for user) accessed via the search button on the main dialog. This will bring up the standard Select User or Group dialog where you can select from a list of users recongized by the system. On the select User or Group dialog there is a button marked Location; and when selected it will bring up the standard location dialog. This dialog should show all the possible locations that can be used for locating a user. On my system it only shows the local computer [name]. The local computer is registered and belongs to a domain. My assumtion was that I should be able to see the domain [name] as one of the locations listed. It is not. I am trying to figure out how I get the domain to show up in the location list. The local computer is running Windows XP pro; and I wan't to know how to have it configured so that it shows the domain in the location list. I have tried a bunch of things recommended by others but I still cannot see the domain in the location list.

If I attempt to do what you had suggested via the dialog gui (i.e. DOMAINNAME\USERNAME) I get the following error when I do a check names on the specified user:

The object named "adomain\adomainuser" is not from the a domain listed in the Select Location dialog box, and is therefore not valid."

Peter|||

thats wonderful.

then....

Why dont you just

logging into to your XP box as the Domain Administrator?

if my memory servers me right

thats a member of the administrators NT group

which is by default administrator to Sql server as well

via builtin\administrator.

From there you should be able to access all Domain resources

If that is not possible... hehehe

try logging in using any of your domain accounts.

before doing anything in the box.

by the way...

Are your sql services running under

the domain account or local XP account?

The steps are of course.

1. make sure your box is a member of the domian

2. make sure you can login to the box using a domain account

3. your sql box services is runing under a domain account

no 3 should be a sure way to answer your problem

|||

Also I would like to suggest to contact your network administrator to see controllers in your domain. Depending on how you’ve set up Active Directory, you could miss a few of your domain controllers. The second way is a little bit more complicated, but barring any unforeseen circumstances, should always return a list of all your domain controllers.