 |
 |
ASNA DataGate® 7.2 for SQL Server 2005® and SQL Server 2005 Express®
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.
Uninstalling
DataGate for SQL Server 7.2 for .NET
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.
|
10/24/2007
© 2007.
Amalgamated Software of
|