How do I make Catalina Web Services connect to sql server using a windows account?


Some customizations require the catalina web service to run as a windows account. To do this:

In the sql strings field of the xml config file add the following values:
NET Connection string: Trusted_Connection=True;
OLE Connection string: Integrated Security=SSPI;

In IIS Admin, set the Application pool for the webservice to run under the required account.

Note:If the sql server is on a seperate server than your webservice you will need to use a domain account rather than a local/computer account.