The article here describes how to configure Cascade CMS to point to a back-end database.  As seen there, the standard JDBC connection string for a SQL Server database looks something like this:

url="jdbc:jtds:sqlserver://sqlserver:1433/cascade;SelectMethod=cursor"

In the url  string above:

  • sqlserver  - the host name of the SQL Server database to which you want to connect 
  • cascade  -  the name of your Cascade CMS database

In order to connect to a named instance of SQL Server, this url string can be modified as described below:

url="jdbc:jtds:sqlserver://sqlserver/cascade;instance=instanceName;SelectMethod=cursor"

In the string above, notice the following changes:

  • The port has been removed (since named instances in SQL Server use dynamically configured ports)
  • An additional instance  attribute has been added after the database name where instanceName  is the named instance to which you intend to connect
Did this answer your question?