How to connect to SQL server when using Mixed mode authentication.
I am having problems trying to connect to a DB in SQL Server 2012. Specifically, I am getting the following error message:
Unable to Invoke Service GetDataTest on MyThingTest : Login failed for user 'MyUserName'. ClientConnectionId:2115f651-90b3-432f-9b0c-fa6d22ce3688
My DB server is enabled for mixed authentication but in the properties of my DB it says only windows authentication. Would this be the issue? I also tried including the definition of Integrated Security within the connection string but then I got an error that the driver does not supprpor that. How can I solve the connection problem? I tried to connect to the same DB in a different software which also requires the connection string etc. and it works fine.