Configuring Windows authentication with SQL Server

Table of contents

You can use Cloud Cruiser with a Microsoft SQL Server system set for Windows authentication. There are two parts to this configuration: the database connection information and the local account used by Cloud Cruiser’s application server.

To enable Cloud Cruiser to use Windows authentication

On the machine where Cloud Cruiser is installed open the file <install_dir>/apache-tomcat-7.0.35/webapps/ROOT/WEB-INF/classes/database.properties in a text editor.

At the end of the line that sets the jdbc.url property, append ;domain=<ccServerName> where <ccServerName> is the local name of this machine. This tells Tomcat to ignore the jdbc.username and jdbc.password in the file and instead attempt to log in to SQL Server as the user account on this machine that is running the Cloud Cruiser service. For example, if your SQL Server machine is named dbserver5 and your Cloud Cruiser machine is named cloudfinance , your jdbc.url property would be: