Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Aug 30 '12 at 15:20

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

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

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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