I have to access a database that resides on the SQL 2008 server through the UCCX scripts. To achieve this, I am trying to establish an ODBC connection to the SQL2008 named instance from the UCCX server but I get the following SQL connection error:
SQL Server Error:53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
SQL Server error:17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denied.
The ODBC driver version is 3.526.3959.0 and UCCX is installed as a standalone server with version7.0(1).
Note: I am able to access this named instance through the SQL2008 management studio from me desktop.
Any thoughts is highly appreciated!