Create a Networked Database
This section provides instructions for users who wish to set up a new Evolve Repository on SQL Server.
|
|
The details in this section are intended to be used by an experienced database administrator - you should not attempt to perform these tasks if you are not an experienced SQL user. |
Before You Begin
Before You Begin
It is a prerequisite of this guide that you have already installed Microsoft SQL Server and that it meets the Evolve Suite System Requirements. The database should be on a different computer to the one which you will install the Evolve Suite client software on.
Get The SQL Script Files
Get The SQL Script Files
We have provided a set of SQL scripts which should be used when configuring the database, so please ensure you have these ready when preparing to set up the database. The script files are available from Quest website. The website files are zipped in files titled:
l erwin EvolveSuite_MSSQLScriptFiles_****_*_*_*.zip
Instructions for SQL Server
Instructions for SQL Server
The following table shows high-level steps for setting up the Evolve Repository on Microsoft SQL Server and should only be performed by a SQL Server administrator.
|
1 |
Create a new SQL Instance |
Note the name as: [database_name] Make sure the collation is: Latin1_General_CI_AS |
|
2 |
Run SQL Script Files |
Run each of the supplied SQL Script files against your database, in the following order: 1.CreateMSSQLSchema.sql 2.CreateMSSQLCopyModelProcedure.sql 3.CreateMSSQLDeleteModelProcedure.sql 4.GetNextId.sql 5.CreateCasewiseRWRole.sql 6.GrantAccessToSchemaForCasewiseRWRole.sql |
|
3 |
Create a new login |
Create a new login specifically for Evolve Suite use. We recommend using Windows Authentication, however you can also use SQL Authentication if you wish. Note the login name as [login_name] For Windows Authentication Make sure the User Group you assign to the login includes all users who need to access Evolve Suite. For SQL Authentication Note the password as [login_password] |
|
4 |
Create a new user |
Create a new Database User for the Evolve Database [database_name] and link the user to the login [login_name] you just created. Set Owned Schemas and Membership (Role Members) to CasewiseRW |