Apr 05, 2016 02:36 PM|jp2code|LINK
My website is hosted, so I had been using the hosts connection string and database for a few months.
I am developing some new features now, and since the website is live I need to test these inserts before running through all of the records.
The remote database was setup using SQL Server Management Studio 2014 with a connection to the remote database.
I tried stepping through these in Visual Studio 2015 Pro, but the host does not allow remote connections like that.
So, I backed up the remote database and restored it to my local machine.
I went into the Database Connection's Properties > Settings to make sure both SQL Server and Windows Authentication mode were allowed.
I also added my database user and set him as the 'db_owner' for that database.
When I try to open the database in the VS2015 debugger, I get "Login failed for user".
What did I forget to do?