With the most recent update to 2009.031 the connect to database screen has changed. This new update automates the correct settings, if it remains unchanged it will work correctly.

1. Here is where you specify the location of your database. This is the Computer Name, or IP Address of the computer hosting your SQL database. It is now followed by the name of the SQL server instance that Office Tools Pro installs. "\north40systems".
2. The second box still allows you to specify which database to connect to. Your database will be listed as "Office Tools Pro". The "Sample" database has fake client and company information.

****IMPORTANT MUST READ****This document is for the intention of a read-only database not an existing database. If you choose to use this method with an existing database we can not be held responsible for any lost or damaged databases. If you would like to move you existing database please contact technical support: 661-951-9900.

If after initially linking the database you get the following error:

Then, while installing the Office Tools Professional SQL instance, the database mounted as "read only". Fixing this is easy, just follow these few steps.

1. First we need to check to see if SQL server Management Studio is installed. Go to Start > All Programs > Microsoft SQL Server 2005 > Microsoft SQL server Management Studio Express. If it is there, skip to step 3. If it is not installed, you will need to download it from the Microsoft website. You can obtain Management Studio Express for free here.
2. Run the SQL server Management Studio installer on the computer where the database was initially installed.
3. Go to Start > All Programs > Microsoft SQL Server 2005 > Microsoft SQL server Management Studio Express.
4. On open the Connect to Server screen will appear, click "Connect".
   
   
   
   
   
5. On the left hand side of the screen you will see 5 folders listed under the north40systems instance. Expand the Databases folder to find the OfficeToolsPro database file.
   
   
   



6. Right click on the OfficeToolsPro database and then go to Tasks > Detach...
   
   
   



7. Under where it says Databases to detach: make sure that Drop Connections is checked, Update Statistics is not checked, and Keep Full Text Catalogs is checked. Then click OK 
   
   
   




8. Right click on the Databases folder and select "Attach..."
   
   



9. Click the "Add..." button and the path of your database should still be correct, select the OfficeToolsPro.mdf and click OK, then click OK again.
   
   



10. Now you will be back at the main screen in Microsoft SQL Server Management Studio Express. On the left hand side of the screen you will see 5 folders listed under the north40systems instance. Expand the Databases folder to find the newly attached OfficeToolsPro database file. It should no longer be listed as Read-Only. You can now reopen Office Tools Professional and re-link your database; this should fix the error you'd encountered before. If this does not fix your problem, please call our technical support department. You can reach them at (661) 951-9900.