UCCX 8.5.1: Database Connection to MS SQL 2008 Server

[dmohr]

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.

[Paul McGurn]

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).

[mohamed.afifi]

same issue here with server 2008 using instances.

does anyone have a solution?

[Gergely Szabo]

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.