Forum Discussion

mishrg's avatar
mishrg
Advocate I
9 years ago

On premise data gateway: SQL server authentication error

I am getting the following error when I am creating a data source to connect to a sql server with a service account. But I am able to connect it with SQL server managment studio with same credentials...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi mishrg,

 

1. Is the data gateway installed on the same machine as the SSMS exists?

2. Try to update the data gateway to the latest version.

3. Please share the image about the page of Manage Gateways where the error throws and credential section.

 

Best Regards,
Qiuyun Yu 

  • mishrg's avatar
    mishrg
    Advocate I
    9 years ago

    Answers for questions below:

     

    1. Is the data gateway installed on the same machine as the SSMS exists? -- Yes, both are on the same machine.

    2. Try to update the data gateway to the latest version. -- I tried but of no help.

    3. Please share the imae about the page of Manage Gateways where the error throws and credential section. -- Image below. I have tried both with and without domain name in the user name. Also, have tried both basic and windows authentication.

    • mishrg's avatar
      mishrg
      Advocate I
      9 years ago

      v-qiuyu-msftDid you get chance to see the issue.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi mishrg,

       

      It seems that the svcdevcompsys is a Windows account. When you create a SQL Server data source under data gateway, please set the Authentication as Windows instead of Basic. Then please enter the user name in the format of <Domain>\<user>, make sure the password is correct and not expired yet.

       

      Best Regards,
      Qiuyun Yu

      • mishrg's avatar
        mishrg
        Advocate I
        9 years ago

        v-qiuyu-msft I had tried that option and it gave the same error. svcdevcompsys password has not expired, same password is working with the SQL server management studio.