SQL Server Instance

Introduction

IPTrade recommends installing SQL Server as default instance. Anyway, in some case, it is possible to install SQL Server as named instance.

How use SQL instance with IP Trade product ?

SQL Installation

During SQL installation you have the option to choose Named instance.

Edit connection string

By default, TSS/Console connection string does not support SQL named instance. You have to edit it manually after install to add instance name.

<add name="DatabaseConnection" connectionString="db://server_name/?driver=SQL Server;db=database_name;user=login;password=password"/>

Becomes…

<add name="DatabaseConnection" connectionString="db://server_name/?driver=SQL Server;instance=instance_name;db=database_name;user=login;password=password"/>