Solved

Sql Server Domain not showing up when adding users

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

895 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

12 Experts available now in Live!

Get 1:1 Help Now