May 26, 2015 at 8:03 am
I have a Windows 2008 R2 server which is connected to a domain.
I logged in as a local admin on this server and installed MS SQL 2012 server.
Now I am able to login to sql server with local admin but when I try to add a domain user I am not able to do that, below is what I have tried.
-- Server > Security > Logins > New Login
-- clicked on Search button
when clicked on location button I can only see the local server name and do not see Entire Directory (domain) details, what could be the reason for that?
After adding the domain user how can I login to SQL server and check if the domain user is able to login to SQL server?
May 27, 2015 at 7:01 am
Can you ping your machine from the server, and can you ping the server from your machine? is the Windows firewall turned on on the server?
May 27, 2015 at 7:06 am
Logging in as a local admin you wont be able to browse the domain I expect. If you type in the new login search box domain\username and hit the check username button do you get prompted for domain user credentials to access AD?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply