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

migrated from stackoverflow.com Aug 30 '12 at 15:20

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

2 Answers

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

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

Your Answer

 
discard

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