cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect to SQL server when using Mixed mode authentication.

jgrosso
2-Guest

How to connect to SQL server when using Mixed mode authentication.

Hi,

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.


Looking forward to your reply,

Juan

0 REPLIES 0
Announcements