Solved

Sql Server Domain not showing up when adding users

Posted on 2009-04-06
5
244 Views
Last Modified: 2012-05-06
I have just installed an Evaluation copy of SQL Server 2005. The server name is ccprojectserver and is on the domain webauth. When I log into Sql Server using the webauth\administrator login which is part of the BUILT-IN group in the WebAuth domain and go to try to add a user the only name that shows up in the Location is the server name, which is ccprojectserver. Why isn't the domain showing up. I have tried everything and can not get the SqlServer App to see my domain WebAuth. When I go to the domain controller I can see ccprojectserver registed and joined in the domain but can not add a user into the WebAuth domain. I can only add users that are local to the computer which for example is ccprojectserver\drecy.  Please help.
0
Comment
Question by:Drecy
  • 2
  • 2
5 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 250 total points
ID: 24083017
Did you install when logged in using a domain admin account or as a local administrator..
0
 

Author Comment

by:Drecy
ID: 24083037
I installed using a domain account. From looking at other post the Location should say ENTIRE DIRECTORY instead of the actual server name of ccProjectServer when adding a user
0
 

Author Comment

by:Drecy
ID: 24089452
After reviewing my inital install, you were correct. I initally installed the Sql Server 2005 logged into the computer instead of the actual domain. Once I deleted the SQL Server install, logged into the computer as a domain user and re-ran the setup the Directory Tree Showed up when I went to add a user. Thanks for the update and follow-up
0
 
LVL 25

Expert Comment

by:reb73
ID: 24089602
"After reviewing my inital install, you were correct"

If so, surely my post merits points as it did assist you in troubleshooting the root cause of the issue?
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

785 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