CODEWITHSUNDEEP
asp.net-mvc-3sql-server-2008windows-server-2008windows-8visual-studio-2012
Paul McDowell
Paul McDowell

Reputation: 144

Unable to locally debug because sql connection string is being ignored

I'm currently attempting to debug a solution that I've picked up as a side project but I'm not having much luck. The solution depends on data (user IDs, page content, etc) stored on an MSSQL server on my local network, but when I execute the solution in VS2012 debug mode the connection fails. The error I'm getting says that the connection failed, and that the user was rejected.

When I log into the SQL server and check the event logs I can see where the login ID was rejected, but it was rejected because it wasn't the login ID that I specified in the connection string. It seems to be trying to use my windows authentication instead (which in windows 8 is a live ID) which won't work because my windows ID doesn't (and shouldn't) have access to the server.

Some basic connection string info (all data changed to protect the innocent... aka my poor server)

Data Source=myServer; Initial Catalog=myDB; User ID=myUsername; Password=myPassword; Integrated Security=false;

Has anyone run into this issue?

Upvotes: 0

Views: 213

Answers (1)

Alex
Alex

Reputation: 35409

Do a search in the entire solution for myServer. This should shed light on the issue, given the connection string is defined somewhere else and it connects to the same server.

Upvotes: 1

Related Questions