SQL Server Examples - SQL Server Examples - OnBase - Data Capture Server - OnBase/Data-Capture-Server/Foundation-24.1/Data-Capture-Server-Deployment-Guide/Data-Capture-Server-Installation/ADO.NET-Connection-Strings/Connection-String-Components/Connection-String-Examples/SQL-Server-Examples - Foundation 24.1 - Foundation 24.1

Data Capture Server Deployment Guide

Platform
OnBase
Product
Data Capture Server
Release
Foundation 24.1
License
Premier
Standard
Essential
ft:lastPublication
2024-09-03T13:31:51.971000
ft:locale
en-US

This connection string would create a data source called ConnectSQL, used to connect to the database TestDB hosted on a SQL Server instance named Serv001\instance:

<connectionStrings>

<add name="ConnectSQL" connectionString="Data Source=Serv001\instance; Encrypt=Mandatory;

Database=TestDB;User Id=username;Password=password"

providerName="System.Data.SqlClient"/>

</connectionStrings>

Similarly, this example would connect to the same database, but it would use integrated security instead of database user authentication:

<connectionStrings>

<add name="ConnectSQL" connectionString="Data Source=Serv001\instance; Encrypt=Mandatory;

Database=TestDB;Integrated Security=true;"

providerName="System.Data.SqlClient"/>

</connectionStrings>