Solved

Sql Server Domain not showing up when adding users

Posted on 2009-04-06
5
222 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 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

20 Experts available now in Live!

Get 1:1 Help Now