UCCX9 connecting to SQL server 2008

 

 

 

 

After installing SQL server 2008, we need to create TCP/IP connection for testing connection and create a new account for management of DB.

Enable TCP/IP connection for specific instance

In IP2, put connection parameters

Scroll down to IPAll, then put specific port info, click OK

Use built-in account for login

find and open “SQL Management Studio”

Login as administrator user and create a new account as below

Right click “properties”  of the user and assign all roles to it

Download DB visualizer (http://www.dbvis.com/download/)    to generate URL for UCCX9

Login as “sqladmin” created last step

Right click server icon, then click “copy database URL”

Go to UCCX9, upload “jtds-1.3.1.jar” driver. Download from here: http://sourceforge.net/projects/jtds/files/latest/download?source=files

Go to datasource page, put all connection information and paste database URL that was copied from DB visualizer

Test passed