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.
Someone has already corrected this mistake?
See you around
Have you tried following these steps described in KB818047?
– stderr
Qmechanic73 already performed the steps but it was not enough.
– Diogo Malvezzi
What is the version of SQL Server? com
telnet <server-ip> 1433
succeeds?– stderr
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
– Diogo Malvezzi
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.
– stderr