NTL Studio
SQL Database Installation & Configuration
NTL Studio v1 & 2 - Supported by Microsoft SQL Server Express 2005.
NTL Studio 2011 & 2012 - Supported by Microsoft SQL Server Express 2005 & 2008 R2
Index:
Introduction & Minimum Specifications...
Installing SQL Server Express ...
Installing SQL Server Management Studio Express...
Configuring SQL Server Express...
Creating NTL Studio Database Tables...
3 4 - 5
6 - 7
8 - 9
10 - 12
Introduction:
Microsoft® SQL Server is the database engine that NTL Studio will access to store all customer information as well as unit settings, schedules and audio file information. Additional SQL management tools will allow access to the database with custom applications while maintaining the integrity of the database.
Minimum Hardware Specifications:
• IBM compatible PC
• Intel Core™ 2 Duo
• 2GB RAM
• 80GB Hard Drive
• 10/100 LAN
• CD-ROM
• Super VGA (1,024 x 768) or higher-resolution video adapter and monitor
• Keyboard and Microsoft® Mouse or compatible pointing device
• Sound card
Server OS Versions Supported:
• Microsoft® Windows XP (Limited Support)
• Microsoft® Windows Vista®
• Microsoft® Windows 7® x86/x64
• Microsoft® Windows 2000 Server® with SP 4 or later (Limited Support)
• Windows Server 2003® Standard, Enterprise, or Datacenter with SP1 or later
• Windows Server 2003® Web Edition SP1
Installation Note: Depending upon the version of your operating system - some of the installation screens may look different from those pictured in the manual. This installation manual should be used as a guide and during the installation process if you have any questions please call Nel-Tech Labs for assistance.
Windows® must have a minimum of Microsoft® .NET Framework 3.5 SQL ServerExpress 2005 or 2008 R2 is required to run NTL Studio
DirectX 9.0c or above is required when using the TCA (Telephone Communication Appliance) Backup your database files everyday! - See "Backup and Restoring Databases" section.
For current updates goto www.nel-techlabs.com/ntl_studio.html
Installing Microsoft SQL Server Express:
It is highly recommended that you contact Nel-Tech Labs to install the SQL Server Express and the SQL Server Management Studio Express software. If your company has a dedicated SQL server we can use that server and just add the NTL Studio database to the existing server.
Pre install Recommendations:
1. Please take all the latest updates available for the PC or server that we will be installing SQL Server Express.
2. Make sure that Microsoft’s .NET Framework 3.5 or higher is installed and up to date.
3. Create a restore point and backup your system before making any changes.
4. Download and extract the “ntl_studio.zip” file to your server’s “C:\” drive.
5. Download the current version of SQL Server Express from Microsoft.
Installing Microsoft SQL Server Express:
Step 1: Click on the “sqlexpr.exe” (or “sqlexpr32.exe”) and run setup using the SQL Server Installation Wizard.
Step 2: Click on the “Next” to continue install.
Step 3: On the “Feature Selection” screen select “Entire feature will be installed on local hard drive” for both the Database Services and Client Components.
Step 4: Click on the “Next” to continue install.
Step 5: Click “Next” through the screens until you come to the “Authentication Mode” screen.
Step 6: Select “Mixed Mode” and set a password for the Server Admin (sa) account.
Click on “Next” to continue install.
Step 7: On the “Completing Microsoft SQL Server Express” screen click “Finish”.
Step 8: Install of SQL Server Express is complete.
Step 9: Move to next section “Installing Microsoft SQL Server Management Studio Express”.
Installing Microsoft SQL Server Management Studio Express:
Pre install Recommendations:
1. Download from Microsoft the current version of SQL Server Management Studio Express (or use the NTL Studio CD).
Installing Microsoft SQL Server Management Studio Express:
Step 1: Click on the “sqlserver2005_ssmsee.msi” and run setup using the SQL Server Management Studio Express Wizard.
Step 2: Click on the “Next” to continue install.
Step 3: On the “Feature Selection” screen select “Entire feature will be installed on local hard drive”.
Step 4: Click on the “Next” to continue install.
Step 5: On the “Completing Microsoft SQL Server Management Studio Express” screen click “Finish”.
Step 6: Install of SQL Server Management Studio Express is complete.
Step 7: Move to next section “Configuring Microsoft SQL Server Express”.
Configuring Microsoft SQL Server Express:
Pre Configuration Recommendations:
1. Verify Microsoft SQL Server Express & SQL Server Management Studio Express are installed.
Configuring Microsoft SQL Server Express:
Step 1: Launch the SQL Configuration Manager from Start>Programs>Microsoft SQL Server>Configuration Tools>SQL Server Configuration Manager.
Step 2: With SQL Server Configuration Manager open, expand the “SQL Server Network Configuration” folder.
Step 3: Click on the “Protocols for SQLEXPRESS” tab.
Step 4: Check that “TCP/IP” is the ONLY enabled protocol. If not, then right-click on each line and select
“Enable” for TCP/IP, and “Disable” for the other three protocols.
Step 5: A window will pop up each time a protocol is changed. Click “OK” to continue.
Step 7: Check that “TCP/IP” is the ONLY enabled protocol. If not, then right-click on each line and select
“Enable” for TCP/IP, and “Disable” for the other three protocols.
Step 6: Expand the “SQL Native Client Configuration” folder, then click on the “Client Protocols” tab.
Step 8: Move to next section “Creating NTL Studio Database Tables”.
Step 6: Click on the “SQL Server 2005 Services” tab.
Step 7: Verify that the Start Mode for both services is set to “Automatic”. If not, right-click on the service and select Properties. Click on the Service tab, and set the Start Mode to “Automatic”. Click OK.
Creating NTL Studio Database Tables:
Pre Database Creation Recommendations:
1. Verify Microsoft SQL Server Express & SQL Server Management Studio Express are installed.
2. Verify Microsoft SQL Server Express is configured.
Creating NTL Studio Database Table:
Step 1: Launch the SQL Server Management Studio Express from Start>Programs>Microsoft SQL Server>SQL Server Management Studio Express.
Step 2: Connect to Server using the password that was created during the install process.
Step 3: Right click on the “Databases” folder and select “Restore Database” from the drop down menu.
or
Step 4: On the Restore Database screen create a name (ex. NTL Studio Database) for the database folder and enter this in the “To database” field.
Step 5: Verify “From device” is selected and click “File” the browse button.
Step 6: On the Specify Backup screen select “Add”, then browse to the backup folder and select the backup file (ex. C:\NTL Studio\Blank SQL Database\NTLSudioDatabase.bak). Then click “OK”
Step 7: Verify “Restore” is checked then click “OK”.
Step 8: Once the restore is complete click “OK”.
Step 9: This completes the installation and configuration of the SQL Database and Management Tools. See the
“NTL Studio Software Manual” for the application installation and instructions.
Nel-Tech Labs, Inc.
4 Ash Street Extension Derry, NH 03038
1.603.425.1096 www.nel-techlabs.com
Rev. 2/12
