Windows authentication with SQL Server for Invantive settings.xml

Settings.xml

Invantive’s software products for Windows use a configuration file (settings.xml) that contains a description of the available services. The file settings.xml is looked for in different locations, such as the installation folder and the pfile folder. When you open an Invantive software product in Windows you can also indicate where the settings.xml file is located.

Within settings.xml you can indicate the links between the database and the Invantive web service, including any routing and additional connections. Each group of connections has the characteristic that the authentications takes place based on Invantive Producer (local user list and/or LDAP and/or Microsoft Active Directory) or based on database authentication.

Database authentication is usually used when Invantive Producer is not used and you want to connect to the database directly to use SQL. This is usually done with the Invantive Query Tool, Invantive Control and Invantive Composition.

Windows authentication for Microsoft SQL Server with settings.xml

People often ask how they can use their Windows user name and password for database authentication in settings.xml in combination with Windows authentication on the Microsoft SQL Server.

In the following example you can see how the connection ACME\Sample1 specifies the DBNAME database SQLEXPRESS instance on the server HOSTNAME. In Sample2 there is no instance.

<?xml version="1.0" encoding="UTF-8"?>
<settings default="ACME\Sample1" forcedefault="false">
  <group name="ACME">
    <connection name="Sample1">
      <database connectionstring="Server=HOSTNAME\SQLEXPRESS;Database=DBNAME;Trusted_Connection=True;" provider="System.Data.SqlClient">
      </database>
    </connection>
    <connection name="Sample2">
      <database connectionstring="Server=HOSTNAME;Database=DBNAME;Trusted_Connection=True;" provider="System.Data.SqlClient">
      </database>
    </connection>
  </group>
</settings>