ODBC -SQL Server Error 17 and SQL Server Error 2

Asked

Viewed 2,624 times

2

There is a BI application on a station that has an ODBC connection configured to fetch the database on another server. If I open the BI on the server where the SQL database is and perform connection testing processes, import, queries with positive return. However, if you do the same process on the server that is not the SQL database the error of not finding the database server.

With these situations I performed the ODBC connection test and is presented the following message. inserir a descrição da imagem aqui

Someone has already corrected this mistake?

See you around

odbc driver
  • 1

    Have you tried following these steps described in KB818047?

  • Qmechanic73 already performed the steps but it was not enough.

  • 1

    What is the version of SQL Server? com telnet <server-ip> 1433 succeeds?

  • 1

    After some testing and redoing the connection process was identified that the ODBC connection needed the inclusion of the SQL instance. In this case would be the IP 192.1.1.1 SQL2014. As soon as the instance was included the connection returned. See more

  • If you want to post an answer explaining how you did it, it would be important for other people who had the same problem as yours.

1 answer

1

Once we have access to SQL Server the login screen (Connect to Server) is entered. In the SERVER NAME field, example, 192.1.1.1. This name is entered in the ODBC settings, but generated the error in print.

By retracing the initial steps of database configuration it was seen that the name of the bank was changed, there was an instance 192.1.1.1 SQL2014. This instance was included in the OBDC configuration and then it was possible to connect again.

Browser other questions tagged odbc driver

You are not signed in. Login or sign up in order to post.