Exact Synergy

Pre Conditions - MS SQL Server 2000

Introduction

Introduction:

The Exact e-Synergy program uses a Microsoft SQL database to store all information. The database server can be installed on a Windows NT 4 server (SP3) but is preferably installed on a Windows 2000 or Windows 2003 server. There are several versions of MS SQL server 2000 for various platforms and purposes, three are mentioned below:

SQL Server Edition	CPU	Memory	Supported OS
SQL Server 2000 Enterprise Edition	32	64 GB	NT 4 Server(SP3), 2000 Server (Advanced, Datacenter), 2003 Server
SQL Server 2000 Standard Edition	4	2 GB	NT 4 Server(SP3), 2000 Server (Advanced, Datacenter), 2003 Server
SQL Server 2000 Personal Edition	2	2 GB	NT 4 Server(SP3), 2000 Server (Advanced, Datacenter, Professional), 2003 Server, Windows XP, NT 4 Workstation, Windows ME, Windows 98

For more information about which version of MS SQL Server 2000 should be chosen go to the Microsoft web site.

Installation:

The installation of MS SQL Server 2000 can be started from the CD, the installation will start automatically if not, activate the autorun application found on the root of the CD

Start the installation by choosing the option 'SQL Server components' and then 'Install Database server'
Click on next and select the computer on which you want to install SQL server, click on 'next'
Choose 'Create a new instance of SQL server, or install client tools', click on 'next'
Enter the requested information, name and company, click on 'next'
Click 'yes' to agree on the license terms
Select 'Server and client tools', click on 'next'
Leave the option 'Default' marked, click on 'next'
Select the option 'Custom Installation' and enter the correct paths (see Pre-Conditions Windows 2000 Server)
Select the following Options and Sub options, unmark all other options and click on 'next'
- Server Component
  - SQL Server
- Management Tools
  - Enterprise Manager
  - Query analyzer
- Client Connectivity
The SQL Server service needs to be configured with the local System account
the NT user who start the SQL Server Agent Service must be a user who has access in e-Synergy. This NT user must also have a SQL Server login on the SQL Server and have write access to the e-Synergy database
!!! Choose the option 'Mixed Mode' and enter a password for the sa user, this option is the only option that can not be left default since e-Synergy uses the SQL user baco to get access to the database server!!!, click on 'next'
Leave the collation settings default, this setting is based on the settings specified in the 'Regional Options' functionality of the OS, click on 'next'
Leave the settings for the network library default, 'Named Pipes' and 'TCP/IP' should be marked, click on 'next'
Click on 'next' to start the installation of the SQL server

After the installation has finished you can restart the server in order to get the SQL service up and running or you can start the service manually in the 'Services' snap inn tool. If the installation tells you to reboot the server, do so.

Tools:

MS SQL Server comes with several tools used for administrating and maintaining the database server and the databases it stores. The tools that are installed were chosen during the installation and can be found in the 'Programs, Microsoft SQL Server' folder in the Start menu. Two of the tools are mentioned here:

'Enterprise Manager', complete graphical administrating tool for SQL server. The tool can be used for de- and attaching of databases, backing up databases, administrating Security and lots of other tasks.
'SQL Query Analyzer', tool for direct manipulation and consulting of databases with the help of the Microsoft implementation of the Structured Query Language (SQL).

Configuration:

There are a few configuration settings of the sql server that can cause problems when not configured properly. The most common encountered problems are described below:

Authentication method is configured to use 'Windows Authentication only'. During the installation one should choose to use mixed mode for authentication but the default is set to 'Windows Authentication only'. It is possible to change the authentication methods that can be used afterwards.
- Start up the 'Enterprise Manager' and right mouse button click on the SQL server, choose 'Properties'.
- Go to the tab 'Security' and change the Authentication mode to 'SQL Server and Windows'

SQL User baco does not exist. When a Synergy database is created on a certain SQL server a SQL login baco is created. When a database is moved from one SQL server to another this user will not be available on the destination server and the Web server will not be able to connect to the SQL server. The user should be created manually in this case.

Start up the 'Enterprise Manager' and open the SQL server that stores the Synergy database.
Open the container 'Security' and click on the 'Login' option
In the right pane a list with authenticated users appears, both SQL and Windows users
Right mouse button click on the white area in the right pane and select 'New login...'
Name the user 'baco' and choose the option 'SQL Server Authentication'
Enter the password ***** for the user baco and click on 'OK', confirm the password and click on 'OK'

Pre Conditions - MS SQL Server 2000

Introduction:

Installation:

Tools:

Configuration:

Related Documents: