SQL Server Database For CustomTools

If you are using CustomTools in a network environment which have a database server machine separated from the client workstations, then all the CustomTools client workstations will establish the connection to the same database.

Configurations is needed to be made to the server and to the client workstations.


To do on the server side:

  1. Install Server side components of CustomTools.

    InfoNOTE: If the server machine is designed to be only a database server, then the License manager is not necessary.

  2. Download and install Microsoft SQL Server management studio.
  3. To run SQL Server management studio, click Start, All Programs, Microsoft SQL Server 20xx, SQL Server Management Studio.
  4. Login to your current CustomTools database server by using the SQL Server user account or the Windows authentication.

    InfoNOTE: In order to create a CustomTools database you need to be logged into the SQL Server as the sa user. In case you are not logged in to the SQL Server as the sa user, the CustomTools database creation wizard promtps you for the sa password before the database creation process starts.

  5. Click Security in the database tree.
  6. Right-click Logins and select New Login. The Login - New dialog box appears.
  7. Enter the requested information into the boxes and set the user rights for the new login.
Info TIP: To read more about the creation of the new login into the SQL Server, please see the Microsoft Developer Network article.

Creating CustomTools database to the client workstation:

If you are using e.g. a CustomTools evaluation workstation or you have an environment where all necessary CustomTools components are installed on the same workstation, use the following instructions to create the database for CustomTools purposes.

  1. Install Client components of CustomTools.
  2. Run CustomTools Administration.
  3. Create a database using the CustomTools Database Wizard. To open the Database Wizard, click Create Database in Server group of the Database tab.

Once the database have been created. You can start using the CustomTools and all of its' features.





Related Topics

CustomTools database creation wizard

Microsoft: SQL Server 2014 Express edition download page
MSDN: SQL Server Login Properties

Back to Top