Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

Sql Server Domain not showing up when adding users

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
Drecy
Asked:
Drecy
  • 2
  • 2
1 Solution
 
reb73Commented:
Did you install when logged in using a domain admin account or as a local administrator..
0
 
DrecyAuthor Commented:
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
 
DrecyAuthor Commented:
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
 
reb73Commented:
"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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now