How can I ensure that clients do not change certain features that require exclusive use of the SQL database for Readykey Pro?
Certain activities require that there are not any applications logged into the SQL database. These activities include running a database backup, archive, database setup, or forms designer.
In some cases, a server has many clients logged into the database remotely. This makes it difficult to close all client connections. There is an easy way to work around this by running a few SQL commands.
This method does not prevent future connections to SQL Server. If an exclusive connection is required, the port SQL Server uses can be blocked by a firewall (for example, TCP port 1433). You should block ports with caution because it may also block local connections. A better solution would be to temporarily disable remote connections to SQL Server using SQL Server Configuration Manager.