Connection error while connecting to SQL Server.

Saseendra
Saseendra Member
in Connectors

I'm getting the below error while connecting to MS SQL Server. Please let me know if have any solution related to this error.
Thanks in Advance.

In the below images, we can see the steps I followed. and the error I got.

DOMO SQL ERROR 2.PNG DOMO SQL ERROR.PNG

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    It sounds like an issue with your username and password. Have you confirmed they are correct? Are you able to use the same connection information with the MSSQL application outside of domo to connect to the database? Have you confirmed the server name is correct?

    Do you have an IT department to work with to confirm the connection information?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    It sounds like an issue with your username and password. Have you confirmed they are correct? Are you able to use the same connection information with the MSSQL application outside of domo to connect to the database? Have you confirmed the server name is correct?

    Do you have an IT department to work with to confirm the connection information?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Saseendra
    Saseendra Member

    Hi Smith,
    Firstly thanks for the replay. The credentials used in the domo were the same as the MS SQL.

  • SharonM
    SharonM Member

    I'm getting the same error and I have verified user name and password and can log in through powerbi and ssms

Categories