Tell me more ×
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.
up vote 2 down vote favorite

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

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

2 Answers

up vote 1 down vote

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
up vote 0 down vote

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

 
discard

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