Visokio website     Downloads     Video tutorials     KnowledgeBase  
Sources: Connecting to Microsoft SQL Server 2014? - Visokio Forums
Sources: Connecting to Microsoft SQL Server 2014?
  • Mark_berger November 23, 2015 5:37AM
    Hi all,

    I am desperately trying to connect to a Microsoft SQL version version 2014, but without any luck.
    Has anyone succeeded doing this? What am I doing wrong?

    It is not a firewall issue and the naming is correct too.

    Looking forward for your replies. A huge "Thanks" in advance.
    Attachments
    Udklip.PNG 7K
  • 2 Comments
  •     chris November 23, 2015 5:41AM
    Hi Mark,

    I've sent you a private message.

    Regards

    Chris
  •     chris November 25, 2015 8:57AM
    This issue has now been resolved. A SQL server login was being attempted but SQL Server was configured to only accept Windows Authentication.

    To fix this issue:

    Open SQL Server Management Studio, right click on the server and then click "Properties".

    Under Server authentication, click the SQL Server and Windows Authentication mode option button, then click OK.

    You will need to restart SQL Server for this to take effect.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership