Tech Support Thursday: Enterprise Server Requirements
Hello everybody, welcome back to another edition of Tech Support Thursday.
I got a call earlier this week asking about what the requirements were for the Enterprise edition of the software. Then it dawned on me that, beyond needing a full Microsoft SQL Server, we didn’t have this listed. So I’ll put it in here and refer back to it as needed.
If you plan on upgrading and/or implementing the Enterprise Version of TapRooT® System Software, the quicker you can get this info to your IT Department the better.
The requirements are after the jump.
• 500 MHz Pentium processor or better
• Microsoft Windows 2000 Server or Windows 2003 Server with 512MB of RAM or greater
• 350 MB of available hard disk space
• CD-ROM drive is required for software installation
• Monitor with XGA (1024 x 768) resolution or better
• The password to your Server’s Administrator account is required to install the software
Please note that Windows 3.1, 95, 98, ME, and NT 4 are not compatible. Database connections to the server are made using the TCP/IP network protocol. Enterprise Edition users have the option of installing MSDE 2000 (supplied) or any version of Microsoft SQL Server 2000 (purchased and installed separately).
Installing Microsoft SQL Server 2000 for the Enterprise Edition
The Enterprise edition of the TapRooT® System Software can be used with MSDE or any edition of Microsoft SQL Server 2000. Prior versions of SQL Server are not supported. Note that Single User and Workgroup editions of the software are only compatible with MSDE. If you wish to use SQL Server to host your TapRooT® database, it must be purchased separately. A license for SQL Server is not included in the TapRooT® System Software license agreement. You must install and configure SQL Server prior to configuring the TapRooT® System Software. Refer to your Microsoft SQL Server 2000 documentation for detailed installation instructions.
The following guidelines should be observed:
• Only one TapRooT® database may be installed per PC regardless of the number of SQL Server instances that are installed.
• A maximum of 16 instances of MSDE and/or SQL Server may be installed on a single PC. Install the Database Server component of SQL Server 2000. The Analysis Services and English Query components are not required.
Setup and Configuration
• Install the Server and Client Tools option. Do not select the Client Tools Only or Connectivity Only options.
• Install a dedicated, named instance of SQL Server for the TapRooT® database to minimize any possible interaction between it and any other database that may be on this PC. Sharing the same SQL Server with other applications is allowed but not recommended.
• The recommended instance name for the SQL Server is “TAPROOT”. You may choose another instance name. You may install the default (unnamed) instance.
• The Typical installation is adequate.
• Under Service Settings, the Use the Local System account option is adequate. You may specify other account information if desired.
• Under Authentication Mode, select Mixed Mode (Windows Authentication and SQL Server Authentication). Windows-only authentication is not currently supported.
• Set a password for the SQL Server’s System Administrator (sa) account.
• Install the most recent service pack for SQL Server and the operating system.
• When you launch the TapRooT® System Software for the first time, you will be required to enter the SQL Server’s System Administrator (sa) password so that it can install the TapRooT® database into the server.
— End —
Phew! It’s exhaustive, but complete. I hope we all learned something. See you next week!