SQL Server Cluster definition?

[Former Member]

We are creating a UD Connect from our (Unix-based) BW system, dual stack, to a SQL Server Database.  I have reviewed the relevant documentation recommended by SAP and, while it would be cleaner to create a DB Connect, it looks like UD Connect is the way we have to go because of the underlying Unix OS of our BW system.  The main sticking point right now is that the SQL Server database resides within a SQL Cluster and we can't seem to find the right definition so it can be recognized.  The SQL Server name is USEVTSQLCL2005.  We can ping that just fine.  The SQL Cluster within it is USEVTSQLCL2005/IN2005.  The SQL Server database we are trying to reach is CatEditMaster.  How do we define the UD Connect to be able to see the database.  Thanks in advance.

Steve Ullman

[Former Member]

Worked like a charm.  Thank you Eduardo!

[former_member184473]

Hello Steve,

Good to know!

Regards,

Eduardo

[former_member184473]

Hello Steve,

Could you connect to the server setting the URL like the following:

URL:
jdbc:microsoft:sqlserver://<server>;database=<Database>

You mentioned:

<server>=USEVTSQLCL2005/IN2005

<Database>=CatEditMaster

URL:
jdbc:microsoft:sqlserver://usevtsqlcl2005\in2005;database=CatEditMaster

Also, check note 1601608 for further information.

Regards,

Eduardo Rezende