Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Im trying to connect to a remote sql server using windows authenication. I'm using visual studio 2012 and going to a remote sql server 2012. I have already checked in sql studio that it is set up for both sql authentication and windows authentication. I'm getting an error message Login failed for user ad\dkboon01

share|improve this question

migrated from Aug 30 '12 at 15:20

This question came from our site for professional and enthusiast programmers.

are you able to connect SQL server using SSMS? Also try running visual studio "run as admin". – Hardik Aug 29 '12 at 12:43

Have you enabled Remote Connection to the server.
On 2008 (I assume 2012 is similar location)
Connect to Mgt Studio on local machine, right click on server & choose properties.
Connection Tab
Tick "Allow remote connection to this server"
Restart SQL Server

share|improve this answer

Are you sure that the Windows User ad\dkboon01 is added as a login in SQL Server? Just because you are able to use Windows Authentication doesn't necessarily mean that particular user has access. It has to be added as a principle, or be part of a Group that is a principle. Access is explicit.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.