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.
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
- 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'
Related Documents:
Next
Main Category: |
Support Product Know How |
Document Type: |
Online help main |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
01.137.890 |
Assortment: |
Exact Synergy
|
Date: |
19-05-2018 |
Release: |
|
Attachment: |
|
Disclaimer |