If you choose to create the Booking Pro database on a SQL Server other than that supplied with the software then you will need to configure SQL Server to ensure that Users have the correct level of access to the database. There are two ways of granting access and these are as follows:

• Use SQL Server Management Studio
• Execute SQL script

Please note than you will need to ensure that Booking Pro is configured correctly using the Database Settings option on the File menu of the Welcome page for any new logins to be used correctly.

Using SQL Server Management Studio

To use SQL Enterprise Manager to grant a User access, start SQL Server Management Studio, select the Logins folder within the Security folder of the server containing the Booking Pro database and create a new User. This will then allow you to select the Windows user account of the User you wish to grant access and to grant them access as a "db_owner" of the Booking Pro database.

Executing an SQL Script

Following is an example of a script which can be used to create a suitable login:

USE master
EXEC sp_addlogin 'username', 'password', 'bookingpro'
USE bookingpro
EXEC sp_grantdbaccess 'username'
EXEC sp_addrolemember 'db_owner', 'username'

This script can then either be accessed directly using a program such as SQL Query Analyser or saved to a file (e.g. using Notepad) and executed using a program such as Osql. Osql is a command line utility supplied with SQL Server which you can use as follows:

Osql -E -S servername/instancename -i scriptfile.sql
 

Why does Booking Pro need "db_owner" rights?

Booking Pro needs "db_owner" access rights to the Booking Pro database because it is capable of downloading new releases and automatically making changes to the schema.

How can I remove a login added using a SQL script?

You can remove a login created using a SQL script using the following SQL script as an example:

USE bookingpro
EXEC sp_revokedbaccess 'username'
USE master
EXEC sp_droplogin 'username'