The project database in Staffmap 4 can be converted from using the default, SQL Compact database, to SQL Server instead. This is generally a one-way conversion. The only way to convert back to SQL Compact is to create a backup copy of the project. In order to convert to SQL Server:
Once a project has been converted to SQL Server an indication icon will be visible on the project management screen:
1. Enter the project you'd like to convert and and go to Tools > Project Settings.
2. In the Database Type option, select the Convert button.
3. Enter the SQL Server address.
4. If the SQL Server is local, you can use Windows Authentication to connect. Otherwise, un-check 'Windows Authentication' and provide credentials.
ERROR: Cannot open database "MainProject" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\DefaultAppPool'.
ERROR: CREATE TABLE permission denied in database 'MainProject'.