Microsoft SQL Server Connection Parameters
By default, Microsoft SQL Server LocalDB is used to store ABBYY FineReader Server databases. However, LocalDB allows incoming connections only from a computer that has the Server Manager component installed, which means that LocalDB cannot be used with clusters.
Microsoft SQL Server 2014 (or later) can be used instead of LocalDB.
Connection to the database can be set up using a connection string and the DatabaseConnection tag in the %PROGRAMDATA%\ABBYY FineReader Server 14\Configuration.xml configuration file.
Connection parameters for Microsoft SQL Server LocalDB:
Parameter | Value | Description |
DatabaseConnectionClass | LocalDB.ConnectionClass | |
LocalDbVersion | 12.0 | Recommended LocalDB version number. If it is not detected, the latest detected version will be used instead. |
LocalDbInstance | FineReaderServer | The name of the LocalDB server instance. |
DatabasePath | %PROGRAMDATA%\ ABBYY FineReader Server 14\Database | Path to the database files. |
Connection parameters for other versions of Microsoft SQL Server:
Parameter | Value | Description |
DatabaseConnectionClass | SqlServer.ConnectionClass | |
Datasource | Server address. For example: 127.0.0.1, localhost\SQLDEV or DATASERVER\CompanySQL. | |
Database | SQL Server database name. | |
Username | SQL Server user's username. If left unspecified, Windows authentication will be used instead. | |
Password | SQL Server user's password. |
When using a connection string, specify the parameters in the <parameter>=<value> format, separating them by a semicolon (”;”).
Below is an example connection string for connecting to Microsoft SQL Server:
<DatabaseConnection>Datasource=DEVSERVER\SQLDEV;DatabaseConnectionClass=SqlServer.ConnectionClass;Database=FineReaderServer;Username=frsuser;Password=password</DatabaseConnection>
A database should be set up prior to connecting to Microsoft SQL Server, using a computer accessible to either:
- the user specified in the connection string during the SQL Server authorization
or
- the user whose Windows account was used to launch the Server Manager.
LocalDB cannot be used with clusters. A connection to Microsoft SQL Server is required instead.
3/26/2024 1:49:48 PM