05-20-2010 12:46 PM - edited 03-14-2019 05:46 AM
Hi,
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:
Connection failed:
SQLState: '010000'
SQL Server Error:53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection Failed:
SQL State:'08001'
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!
Thanks,
DM
05-21-2010 08:46 AM
Hi,
make sure it is UCCX 7.0(1) SR4.
Second, is it a SQL Server Express Edition? Those tend to be a bit tricky, listening on non standard ports etc.
G.
07-07-2011 06:49 AM
Any update? Im having the same issue on SQL 2008 Standard
07-07-2011 07:03 AM
Had to staticly set teh port to TCP 1433 instead of Dynamic
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide