Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

UCCX 8.5.1: Database Connection to MS SQL 2008 Server

Hi,

I'm rying to configure a Database Connection to a MS SQL 2008 Server, but so far unsuccessful.

What I've done is:

- installing the "net.sourceforge.jtds.jdbc.Driver" (jtds-1.2.5.jar)

- configuring a Data Source with the JDBC URL: jdbc:jtds:sqlserver://<IPADDRESS>:1433/<DATABASENAME>;InstanceName=<INSTANCENAME>

I've tried various URL-Formats but I always get the Error Message: "Test Connection Failed"

I've although tried to connect to the database with the DbVisualizer with the result:

Long Message:

Login failed for user 'USERNAME'

Details:

   Type: java.sql.SQLException

   Error Code: 18456

   SQL State: 28000

I can logon with the User using the SQL Management Studio, so the combination of password and user is correct.

Does anyone has an idea how to fix this?

Thank you for your help.

  • Contact Center
3 REPLIES
Bronze

UCCX 8.5.1: Database Connection to MS SQL 2008 Server

Are you configuring username and password via the fields in the UI, or via the connection URL?  You may want to give the latter a shot (not sure what the platform itself is doing with the username and password fields under the covers).

New Member

UCCX 8.5.1: Database Connection to MS SQL 2008 Server

same issue here with server 2008 using instances.

does anyone have a solution?

UCCX 8.5.1: Database Connection to MS SQL 2008 Server

Hi,

when it's "Login failed" - it means login failed. Make sure the user configured in the SQL Server has access to the specified database.

Also, read the JTDS FAQ, more precisely, the section about the URL format. You may be missing something. For instance, if your user in SQL is an AD user (not an SQL user), then you might need to add the domain parameter to the URL.

G.

3689
Views
0
Helpful
3
Replies
This widget could not be displayed.