CCX and SQL 2000 DB

[JustForVoice_2]

I am trying to integrate CCX with DB. I have installed SQL 2000 on a lab server. In CCX I upload the following driver:

jtds-1.2.2.jar under class name net.sourceforge.jtds.jdbc.Driver.

under Datasource Configuration I have configured:

Name: TestDB

Username: Administrator

Password: Password

Maximum number: 5

Driver: the uploaded one before

JDBC URL: jdbc:jtds:sqlserver://192.168.1.16:1433/Master

Test Connection: Test Connection Failed

Any help?

[Gergely Szabo]

Hi,

jtds-1.2.2 is kind of outdated. You want to install a newer version. 1.3.0 or 1.2.7:

http://sourceforge.net/projects/jtds/files/jtds/

Also, there might be a quadrillion of reasons why you got that error message. For instance:

- is the login name correct?

- does this user exist in the database?

- password correct?

- are you trying to use SQL authentication or Windows authentication? If the latter, is it a domain user or a local server user?

- are you sure SQL Server is listening at port 1433? Some SQL server versions use a different port (for instance, SQL Server Express).

G.

[JustForVoice_2]

Thank you Gergely,

I tried the 1.2.7 and 1.3 but he same problem.

- is the login name correct? Username and password should be OK. And I tried the sa also.

- does this user exist in the database? Yes it is.

- are you trying to use SQL authentication or Windows authentication? If the latter, is it a domain user or a local server user?

I used SQL and windows, form the local >> right click>> properties >> Security

- are you sure SQL Server is listening at port 1433? Some SQL server versions use a different port (for instance, SQL Server Express). As I mentioned before I am using MS SQL 2000  and the port is OK

[Gergely Szabo]

I still believe there must be something wrong with the configuration.

Create a new database. Name it uccxtest.

Create a new SQL user, name it uccxtest, with the password uccxtest.

Try logging in with this new user, let's say, into Query Analyzer.

Use the simplest form of the JDBC URL: jdbc:jtds:sqlserver://10.20.30.40/uccxtest Set the username and the password to uccxtest.

G.

[JustForVoice_2]

Hi

I tried to do almost the same, I think I have problem in SQL server.

I created new user: test

Data Base: IP-IVR

Link:

jdbc:jtds:sqlserver://192.168.1.20:1433/IP-IVR

Thanks,

[Gergely Szabo]

Hi, were you able to log in with this new test user using Query Analyzer?

Also, can you give me a "netstat -ano" plus get the PID of the SQL server process (using Task Manager, perhaps).

G.