0 Replies Latest reply on Apr 15, 2016 5:52 AM by jgrosso RSS
    jgrosso Newbie

    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