|
Database Connection |
  
|
|
Database Connection |
|
The Database Connection allows the configuration of the SQL Database Server TOOLMINDER will access.
Change Database Settings
You can edit and change the database settings any time by starting TOOLMINDER with the command-line argument DATABASE_CONFIG
Local DB File
Connection Properties |
|
Name |
The name of the Database, the default is TOOLMINDER and only needs to be changed for Multi-Company installations |
Ribbon Colour |
Set colour of the Ribbon, only required if for Multi-Company installation so can easily identify which Database is selected |
Local DB File is only suitable when only one user will be accessing TOOLMINDER.
SQL Server
Connection Properties |
|
Name |
Free text for you to give the connection a meaningful name |
Ribbon Colour |
Set colour of the Ribbon, only required if for Multi-Company installation so can easily identify which Database is selected |
Server Name |
The name of the server for eg HeadOffice1\DBServer1 |
Database Name |
Name of the database. Network installations require the database to already exist on the server. |
Schema |
The default is dbo |
User Name |
User name to connect to the SQL Database |
Password |
The password for the user |
Windows Azure SQL Database |
Select this option when the SQL Database is a Windows Azure SQL Database |
When you click Save & Close the values you have entered will be checked, if they are correct the window will close, if any of the values are incorrect this will be displayed and the window will not close.
SQL Sync
SQL Sync |
|
SQL Sync uses the Microsoft Sync Framework 2.1 to allow the data synchronization between SQL Database's
Information about Microsoft Sync Framework can be found at http://msdn.microsoft.com/en-us/library/bb902818.aspx |
|
Client |
Click the Client check box when the database will be a client and will Sync to another server, you will have to enter connection details of the database server to sync |
Network Installations
When configuring a login for TOOLMINDER to connect to the SQL Server you must assign db_owner role to the login.
