Solved

Sql Server Domain not showing up when adding users

Posted on 2009-04-06
5
256 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delete from table 6 48
why sql server only update some statistics in the database ? 3 40
Loops and updating in SQL Query 9 66
Present Absent from working date rage 11 49
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

726 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