Jason
Jul 14, 2017 11:51:53 AM

Connecting to MS SQL Database with Plugin.

I have serveral 2008r2 MS SQL servers that I just can not get the plugin to work with.  Not really sure what I'm missing.  TCP/IP is enabled and I can connect to the databases remotley from another PC on the network.  When I setup the plugin I input the Windows amdinistrator account for the login info and all I get is red X's to the right of the login fields.  I can use the same account on MS SQL Studio Management Utility just fine.  Is there a place I can check the logs of the client or something else I am missing?  I also tried the SA account and had no luck iether.

 



Synametrics support engineer
Jul 14, 2017 12:14:57 PM

Connecting to MS SQL Database with Plugin.

Jason,

There are two pre-requisites for the plugin to work:

  1. TCP/IP protocol must be enabled on your SQL server. The easiest way to confirm if TCP/IP is enabled is to open a Command Prompt and type:

    telnet localhost 1433

    You should see a blank screen confirming TCP/IP is enabled.
  2. You must use Mixed Mode Authentication in SQL server. Using the "Administrator" for the account will not work. You will have to use "sa" or any other SQL Server user that has permission to connect and run backup.

Check SyncrifyClientGUI.log file for the exact error after clicking the Test button.

 



Anonymous
Jul 14, 2017 12:42:56 PM

Connecting to MS SQL Database with Plugin.

Ok, thanks for the reply.  I do get the blank screen telneting to localhost 1433.  Mixed mode is enabled on all three SQL servers I've tried.  I looked in the Syncrify client folder for the log file but do not see one, where would I find it at?

 



Anonymous
Jul 14, 2017 12:47:24 PM

Connecting to MS SQL Database with Plugin.

Found the log file here: C:\ProgramData\SyncrifyData\logs

Looks like authentication, I will create a seperate SQL user.  

Thanks again.

Navigation

Social Media

Powered by 10MinutesWeb.com