Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-10 : 09:48:45
|
| Andrew writes "hi,I have logged in as a local admin user and installed sql server on a server. The server is on our domain.After installation, I opened SQL Server Enterprise Manager -> Security -> Logins -> New Login to add domain users (so as to give them access into SQL Server). However I get the error "You many not be able to browse all of the domains to which you have access because the following error occured: Could not find domain controller for this domain"I then right click on the instance and select "properties". I notice there is no "Active Directory" tab. I then opened up Query Analyzer and executed the following command:execute sp_activedirectory_scp @action='CREATE'I get the following error:Server: Msg 14359, Level 16, State 1, Procedure sp_ActiveDirectory_SCP, Line 170Active Directory is either not enabled on the network or not supported by the operating system.I then logged out and re-logged in as a domain admin user and I tried all the above steps, but still no luck. (also SQL Server was initially configured to start as local System account, but I also tried as a domain user account)I spoke to our network administrator, who has confirmed that the server is part of the domain and the network settings are correct. He suggested perhaps re-installing SQL Server, but this time as a domain admin user instead of local user.Could you advise why I can't see domain users.Ultimately, I want to add them into the logins so that they can have access to SQL Server.thanks for your helpAndrew" |
|
|
|
|
|
active directory tab not appearing