ODBC SQL Server Error 17 and SQL Server Error 2

2

There is a BI application on a workstation that has an ODBC connection configured to fetch the database from another server. If I open the BI on the server where the SQL database is and perform connection testing, import, query processes with positive feedback. However, if you do the same process on the server that is not in the SQL database, the error does not find the database server.

With these situations, I performed the ODBC connection test and the following message is displayed.

Has anyone fixed this error yet?

See you soon

    
asked by anonymous 01.02.2015 / 15:33

1 answer

1

As soon as we perform access to SQL Server, the login screen (Connect to Server) is displayed. In the SERVER NAME field, for example, 192.1.1.1. This name is reported in the ODBC settings, but generated the error in print.

Remaining the initial steps of configuring the database was seen that the name of the database 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.

    
22.03.2015 / 17:12