The following are assumptions and requirements that need to be met before you continue installing Workbench:
Microsoft
...
Product Licencing
- Licencing of Microsoft products are the responsibility of the client.
Technical User Setup Skills Required
The person doing the installation has:
- a working knowledge of the networkIP based networking.
- a working knowledge of Active Directory.
- a working knowledge of Microsoft SQL Server Studio Manager
- is able to backup and restore SQL Server databases
...
- In Windows Active Directory you must have created a User Group called Workbench_Users. This user group will be used to grant access rights to the SQL database/s that are described later in this document
- All the users with logins in Active Directory who will need to use Workbench must have been put in this Group. You may want to create more than one user group if there will be different users for different Workbench instances.
- On the server that has SQL server installed a directory called Workbench must have been created.
- Share this directory (and all its sub directories) and allocate full control rights to the Workbench_Users Group. This directory will be used to store all the files needed to create and run Workbench.
- This install document is based on the 2005 Microsoft SQL Server, Workbench will work with both 2000 and 2008 versions but the installing instructions will differ from these. Contact Workbench International if you require further details. Please note that Workbench International recommend that all service packs be applied before installation.
Rights to Master Database
- Some export processes require user rights over the xp_cmdshell stored procedure in the Master database, either directly or via proxy.
- Follow this link on how to setup a proxy account for xp_cmdshell http://msdn.microsoft.com/en-us/library/ms190359.aspx.
Required Permissions
- The user account carrying out the installation has administrator rights on the server that Workbench is to be install onto.
- The user account has sysadmin or sufficient SQL Server rights to backup, restore and configure SQL user permissions.
Technical System Requirements
For a full list of Technical System Requirements needed for a Workbench installation, please read the Technical System Requirements guide.