0 Replies Latest reply on Jan 16, 2018 3:13 PM by jgrosso RSS
    jgrosso Newbie

    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.

    Looking forward to your reply,