The following parameters must be specified in the JSON configuration file or applied to the --connectionstring switch when Foundation DBUtils is used with SQL Server:
|
Parameter |
Description |
|---|---|
|
Data Source |
Enter the server\instance name of the SQL Server instance hosting the database. |
|
database |
The name of the database. |
|
User Id |
The user name of the database user account accessing the database. Note:
The User Id parameter is for the user account accessing the database, not an OnBase user account. |
|
Password |
The password of the database user account accessing the database. Note:
The Password parameter is for the user account accessing the database, not an OnBase user account. |
The following is an example of how the parameters are specified when using the --connectionstring command line switch:
--connectionstring "Data Source=Serv001\instance;Database=TestDB; User Id=username;Password=password"If using integrated security to connect to the database, remove the User Id and Password qualifiers and add the qualifier Integrated Security=true to the connection string instead. For example:
--connectionstring "Data Source=Serv001\instance;Database=TestDB; Integrated Security=true"For an example of how to set connection string information in a Foundation DBUtils JSON configuration file, see the Foundation DBUtils JSON Configuration File.