 |
 |
ASNA DataGate® 7.2 for SQL Server ®
Contents
Preparing to Install DataGate for
SQL Server for .NET
Review the Installation Options
Install Microsoft SQL Server or verify
installation
Check SQL Server Service options
Installing DataGate for SQL Server for .NET
Licensing DataGate for SQL Server for .NET
Uninstalling DataGate
for SQL Server for .NET
To run ASNA DataGate for SQL Server 7.2 for .NET and ASNA DataGate 7.2, you must have certain hardware and software installed
on your computer.
The system requirements include:
·
Microsoft
Windows 2000, XP, or Windows NT 4.0 Workstation 4.0 or later.
·
TCP/IP;
·
You
must be signed on with Administrative privileges in order to start the DataGate
Service and to license both products;
·
A
CD-ROM disc drive.
·
VGA
or higher-resolution screen supported by Microsoft Windows.
·
A
minimum of 64 MB of RAM.
·
A
mouse or other suitable pointing device.
·
At
least 130 MB free disk space (includes a new installation of AVR, ADB and
DATAGATE FOR SQL SERVER).
Recommendations:
·
Application
Development should be on Windows NT 4.0 or higher (i.e. Windows 2000/XP
Professional).
·
Run
your mission critical Database on Windows NT 4.0, 2000 Server, or XP
Professional running a backup Power Supply with NTFS (not FAT or FAT32) OR on
an AS/400.
·
Run
your mission critical Applications on NT 4.0, 2000, XP Professional with NTFS.
·
Memory
requirements for Windows NT / 2000 / XP should triple the minimum.
·
Keep
recent Data Backups.
The Release Notes lists any issues regarding the current
release of DataGate for SQL Server.
You
can also view the Release Notes by selecting the Getting Started book in the
AVR help file or from the ASNA Product Suite CD browser, as noted below.
·
Insert the ASNA Product Suite CD-Rom, and when the Menu
screen displays, select Products - DataGate for SQL Server - View Release Notes.
·
Insert the ASNA Product Suite CD-Rom and using Windows
Explorer, go to the \Help
directory and select an HTML file titled AVRNET71_release_notes.htm.
Before
installing ASNA DataGate for SQL Server 7.2 for .NET, consider the following:
·
Be sure the computer meets the system requirements for DataGate for SQL Server 7.2 for .NET. For more information, see System
Requirements.
·
Read the Release Notes for DataGate for SQL Server for the latest on product
issues, as well as known fixes, known bugs, etc.
·
Review the installation
instructions
for installing DataGate for SQL Server 7.2 for .NET and be prepared to make the
appropriate selections when running Setup.
·
Ensure that Microsoft for SQL
Server has
been installed, or install Microsoft for SQL Server. Refer to Microsoft SQL Server documentation
for further information.
·
Verify that the Microsoft SQL Server
Service is
started, and that the Auto-start service when OS starts is selected. See Starting, Pausing, and Stopping SQL
Server for more information.
If this option is not selected, DataGate for SQL Server
will not install, and you will receive an error indicating that the License
Server Manager could not be started.
The following includes the basic steps to install
Microsoft SQL Server. Please refer to
the Microsoft SQL Server documentation for further information.
To
install Microsoft SQL Server 2000
1.
Insert the Microsoft® SQL Server™ 2000 compact disc in your CD-ROM
drive. If the compact disc does not automatically run, double-click Autorun.exe in the root directory of the
compact disc.
2.
Select SQL Server 2000 Components.
3.
Select Install Database Server and setup prepares the SQL
Server Installation Wizard. At the
Welcome screen, click Next.
4.
In the Computer Name dialog box, Local Computer is the
default option and the local computer name appears in the edit box. Click Next.
For a remote installation, click
Remote Computer. You can then type a computer name or click Browse to locate a
remote computer.
If a cluster is detected, Virtual
server is the default option.
5.
In the Installation Selection dialog box, click Create a new instance of SQL Server,
or install Client
Tools, and
then click Next.
6.
Follow
directions on the User Information, Software License Agreement and related
screens.
7.
In the Installation Definition dialog box, click Server and Client Tools, and then click Next.
8.
In the Instance Name dialog box, if the Default check box is available, you
can install either the default or a named instance. If the Default check box is
not available, a default instance has already been installed, and you can
install only a named instance.
·
To install the default instance, select the Default
check box, and click Next.
·
To install a named instance, clear the Default check
box, and type a new named instance in the Instance Name edit box. Click Next.
9.
In the Setup Type dialog box, click Typical or Minimum, and then click Next.
If you want to select components
and subcomponents, change character set, network libraries or other settings,
click Custom, and then click Next.
10.
In the Service Accounts dialog box, accept the
default settings, enter your domain password, and then click Next.
11.
In the Authentication Mode dialog box, accept the
default setting, and click Next.
12.
When you are finished
specifying options, click Next in the Start Copying Files dialog box.
13.
In the Choose Licensing Mode dialog box, make selections
according to your license agreement, and click Continue to begin the installation.
Click Help for information about licensing or see your system
administrator.
14.
In the Setup Complete dialog box, click Yes, I want to restart my computer
now, and then
click Finish.
SQL Server Service Manager is used to start, stop, and
pause the Microsoft® SQL Server™ 2000 components on the server. These components run as services on Microsoft
Windows NT® or Microsoft Windows® 2000 and above.
SQL
Server Service implements the SQL Server database engine. There is one SQL Server service for each
instance of SQL Server running on the computer.
SQL
Server Service Manager is a taskbar application and follows the standard
behavior of taskbar applications. The
task bar icon will display whether the Server is running 
, paused, or stopped 
.
Important!!!!
There is a field within the SQL Server Service Manager that you need to
select, or ensure that it is enabled. It
is called “Auto-start service when OS starts”.
Please ensure this option is selected, especially when installing AVR as
well, as the system will reboot after installing AVR. If this option is not selected, the SQL
Server Service will be stopped, so when the installation process continues and
tries to install DataGate for SQL Server, you will receive an error, and
DataGate for SQL Server will not be installed.
Note
that this option is not selected by default.
You must select this option prior to installing DataGate for SQL Server
(if installing AVR at the same time).
To
Open, Start, Pause or Stop the SQL Server Manager
1.
After Microsoft SQL Server is installed, the SQL
Service Manager icon for the local machine will display in the right hand
corner of your taskbar. To open SQL
Server Service Manager, either double-click on the 
, or right-click
on the icon to display a list of menu options.
The following dialog will display.
Enter or select the following to SQL Server Service
Manager:
Server:
The name of the local computer will display. Clicking on the arrow to the right will
display all of the SQL Servers that you have access to.
Services:
The SQL Server service will display. Clicking on the arrow to the right will
display the other SQL services you have access to, such as SQL Server Agent,
and Distributed Transaction Coordinator.
Refresh
services…
Select this button to refresh the services.
Start/Continue
Selecting this button starts the SQL Server Service. After it is started, the option will be
dimmed, and the icon will display with a green start icon next to it,
indicating the service is started.
Select this option when the service is either currently paused, or
stopped.
Pause
Select this button to temporarily pause the SQL Server
Service. To continue service, select
the Start/Continue button.
Stop
Select this button to stop the SQL Server Service. To start the service again, select the
Start/Continue button.
Auto-start
service when OS starts:
Select this option to ensure that the SQL Server Service
automatically restarts after your system has been restarted.
Note
that this option is not selected by default.
You must select this option prior to installing DataGate for SQL Server
(if installing AVR at the same time).
2.
To close SQL Server Service Manager, right-click the SQL Server
Service Manager icon on the taskbar, and then select the Exit menu option.
DataGate
for SQL Server for .NET is easily installed by selecting the appropriate
options from the CD Browser that will automatically display when the ASNA
Product Suite CD is inserted in the CD-Rom drive. An installation, a Setup program will
decompress and install the files in the appropriate directories.
DATAGATE
FOR SQL SERVER can be installed from either AVR 7.2 for .NET or Deployment
options from the ASNA Product Suite.
Installing
AVR for .NET 7.2 will also automatically install Release 7.2 of DataGate. However, to install DataGate for SQL Server, there are
several options you must select to install (as shown in step 4 below).
When
installing DataGate for SQL Server, you should be signed on with Administrative
Privileges to start the DataGate NT Service. If you are not signed on with Administrative
Privileges, a Warning will display – stating that you need to have
Administrative privileges to start the DataGate NT Service. Therefore, you may want to check with your
Network Administrator prior to installing to ensure you have Administrative
privileges.
To
Install DataGate for SQL Server for .NET from CD
1.
Insert the ASNA Product Suite CD into your CD drive.
·
If your CD drive has AutoPlay, a screen will
automatically appear. Select the options
below to install DataGate for SQL Server.
·
If you do not have AutoPlay installed on your CD drive,
start Microsoft Windows and from the Start Menu, select Run, and enter the
path: E:\INSTALL.EXE, where ‘E’ is the
CD-Rom drive. Then select the options
below to install DataGate for SQL Server.
2.
Click on Products.
3.
Click on either AVR 7.2 for .NET or Deployment.
4.
Click on the Install… option for the product selected in the previous step.
Note
that you can also View the Installation Notes help file or View the Release
Notes HTML file from the CD.
After the setup file is located, the Welcome screen
will display, along with several others.
Simply follow the instructions on the screen. When you get to the Component screen, the following
components will be selected/unselected by default, and this screen will vary
depending upon the product and options selected.
Note
that a description of each component will display in the Description
section in the middle of the dialog box.
5.
To
install the DataGate for SQL Server components, you must at have the following
components selected, as explained below.
6.
Select the Next > button to continue with the
installation.
7.
When the installation is complete, you will be prompted
to reboot the system. Then the
installation process for DataGate Client will automatically display. Follow the instructions on the screen. The main screens that will occur are:
·
License Agreement
·
Registration
·
Directory locations and selecting which files to
install
ASNA DataGate for SQL Server 7.2 for .NET must be properly
licensed prior to using it. The steps to
license DataGate for SQL Server is exactly the same as licensing AVR for .NET
or DataGate Client.
Refer
to the Registration
Assistant
help file (Regasist.chm) in C:\Program Files\Common Files\ASNA
Shared for
more information!
After
you have completed the installation procedure, you can start any of the
products included with DataGate at any time.
1.
Start DataGate Database Manager by selecting Start – Programs - ASNA Product
Suite – DataGate – DataGate Database Manager.
2.
For help on using any of the products, select Contents
from the Help menu to display the On-line help file.
To Remove ASNA DataGate for SQL Server
1.
Select Start – Settings - Control Panel.
2.
Select Add/Remove Programs.
3.
Select ASNA DataGate for SQL Server 7.2 for .NET.
4.
Click the Add/Remove… icon.
5.
Click Yes to begin removing DataGate. Click No to return to the previous
screen.
SQL Server Service Manager is used to start, stop, and
pause the Microsoft® SQL Server™ 2000 components on the server. These components run as services on Microsoft
Windows NT® or Microsoft Windows® 2000 and above.
SQL
Server Service implements the SQL Server database engine. There is one SQL Server service for each
instance of SQL Server running on the computer.
SQL
Server Service Manager is a taskbar application and follows the standard
behavior of taskbar applications. The
task bar icon will display whether the Server is running , paused, or stopped .
Important!!!! There is a field within the SQL Server
Service Manager that you need to select, or ensure that it is enabled. It is called “Auto-start service when OS
starts”. Please ensure this option is
selected, especially when installing AVR as well, as the system will reboot
after installing AVR. If this option is
not selected, the SQL Server Service will be stopped, so when the installation
process continues and tries to install DataGate for SQL Server, you will
receive an error, and DataGate for SQL Server will not be installed.
Note
that this option is not selected by default.
You must select this option prior to installing DataGate for SQL Server
(if installing AVR at the same time).
To
Open, Start, Pause or Stop the SQL Server Manager
1.
After Microsoft SQL Server is installed, the SQL
Service Manager icon for the local machine will display in the right hand
corner of your taskbar. To open SQL
Server Service Manager, either double-click on the , or right-click
on the icon to display a list of menu options.
The following dialog will display.
Enter or select the following to SQL Server Service
Manager:
Server:
The name of the local computer will display. Clicking on the arrow to the right will
display all of the SQL Servers that you have access to.
Services:
The SQL Server service will display. Clicking on the arrow to the right will
display the other SQL services you have access to, such as SQL Server Agent,
and Distributed Transaction Coordinator.
Refresh
services…
Select this button to refresh the services.
Start/Continue
Selecting this button starts the SQL Server Service. After it is started, the option will be
dimmed, and the icon will display with a green start icon next to it,
indicating the service is started.
Select this option when the service is either currently paused, or
stopped.
Pause
Select this button to temporarily pause the SQL Server
Service. To continue service, select
the Start/Continue button.
Stop
Select this button to stop the SQL Server Service. To start the service again, select the
Start/Continue button.
Auto-start
service when OS starts:
Select this option to ensure that the SQL Server
Service automatically restarts after your system has been restarted.
Note
that this option is not selected by default.
You must select this option prior to installing DataGate for SQL Server
(if installing AVR at the same time).
2.
To close SQL Server Service Manager, right-click the SQL Server
Service Manager icon on the taskbar, and then select the Exit menu option.
|
04/29/2007
© 2007.
Amalgamated Software of
|