INSTALLING SQL SERVER 2012 EXPRESS WITH ADVANCED SERVICES FOR
REDHORSE CRM
This article will walk you through the installation of Microsoft SQL Server 2012 Express
Step 1: Download Microsoft® SQL Server® 2012 Express
Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
http://www.microsoft.com/en-us/download/details.aspx?id=29062
Please choose to “Save to Disk” when downloading so that this file may be used more than once. It is not recommended to choose to “Run” from the download site. Express with Advanced Services (contains the da- tabase engine, Express Tools, Reporting Services, and Full Text Search). This package contains all the compo- nents of SQL Express. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.
Depending on your computer’s operating system, please download either the 32-bit OR the 64-bit file.
ENU\x86\SQLEXPRADV_x86_ENU.exe 1.3 GB -OR-
ENU\x64\SQLEXPRADV_x64_ENU.exe 1.3 GB
The Microsoft® SQL Server® 2012 Express has two different methods to complete the installation process. For this document, we will be covering the Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the instal- lation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.
FEATURES
Version Express with Advanced Services
Database Engine X
Express Tools X
Full-text Search X
Reporting Services X
Management Studio X
For this document, we will be downloading and installing the 64-bit version of SQL and the required setup files.
Step 2: Identify System Requirements
http://msdn.microsoft.com/library/ms143506%28v=SQL.110%29.aspx
Component Requirement
Memory Minimum:
Processor Speed Minimum:
• x86 Processor: 1.0 GHz
• x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster Processor Type
• x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
• x86 Processor: Pentium III-compatible processor or faster
Step 3: Install database software prerequisites
3a) Enable Microsoft .Net Framework 3.5 SP1
Microsoft .NET Framework 3.5 Service Pack 1 is a full cumulative update that contains many new features building incrementally upon .NET Framework 2.0, 3.0, 3.5, and includes cumulative servicing updates to the .NET Framework 2.0 and .NET Framework 3.0 subcomponents.
http://www.microsoft.com/en-us/download/details.aspx?id=22
At the same time you can chose to download and install the Microsoft® Windows® Malicious Software Remov- al Tool (KB890830) x64.
After downloading, execute dotnetfx35setup.exe and follow the instructions to complete the installation. If you are running Windows 7, all you need to do is to enable the .NET Framework 3.5. To do this please follow these steps:
For Windows 7...
1. Click on Start | Control Panel | Programs
2. Under Programs and Features, select the “Turn Windows features on or off”
3. In the Folders Listing in the Windows Features, place a check mark by the “Microsoft .NET Framework 3.5.1”
to install/enable
4. .Net framework 3.5 SP1 will now be installed For Windows 8 ...
If you are installing on Windows 8, you would follow these steps to install the .NET Framework 3.5 on Demand:
1. In Control Panel, choose Programs and Features
2. Choose Turn Windows features on or off
3. Then select the .NET Framework 3.5 (includes .NET 2.0 and 3.0) check box
4. This option requires an Internet connection. You do not need to select the child items for Windows Com- munication Foundation (WCF) HTTP activation unless you are a developer who requires WCF script and handler mapping functionality.
3b) Enable Microsoft .NET Framework 4 (Web Installer)
http://www.microsoft.com/en-us/download/details.aspx?id=17851
After downloading, execute the downloaded file, dotNetFx40_Full_setup.exe and follow the instructions to complete the installation. Your machine may already have .NET installed and enabled. If so, you will see a dia- log box such as this which means you already have .NET 4 installed on your computer:
3c) Download and install:
1. Windows Management Framework Core (WinRM 2.0 and Windows PowerShell 2.0) 2. Windows Management Framework BITS (BITS 4.0)
... for your operating system. You can read about and download the installers from this web site:
http://support.microsoft.com/kb/968929
Step 4: Turn Off Windows User Account Control (UAC)
Ideally you would turn off User Account Control for the SQL Server installation and the RedHorse installation.
Once you have those components installed and you have properly configured SQL Reporting Services and RedHorse Reports, you can turn User Account Control back on. You can learn about how to do that from this web site:
http://windows.microsoft.com/en-us/windows/turn-user-account-control-on-off#1TC=windows-7
You may be prompted to restart your computer before proceeding. It would be a good idea to restart your machine after you have installed the .NET Framework and required software (listed above).
Step 5: Install SQL Server 2012 Express Edition
Double-click the file SQLEXPRADV_x64_ENU to start the product installation. The contents of the file are ex- tracted and the installation begins. The installation will begin on Installation Page.
We would strongly suggest checking your machine to see if all the components are installed BEFORE install- ing SQL Server 2012. You can do this by clicking on the Tools | System Configuration Checker
If your System passes the Configuration Check, the check will run and then close. This means your system is ready for the installation. If not, you will see a screen to show you the Details of the steps you need to take prior to installing SQL Server 2012.
Return to the Installation Tab on the left to continue the installation:
Click on the New SQL Server stand-alone installation or add features to an existing installation option (high- lighted in the above screen shot) to being the installation.
The installer will check and download any needed updates for the setup files. The installer should proceed to the Feature Selection screen... accept the defaulted selections. By default, SQL will install on your computer’s C: drive. You can redirect this to another drive if you would like, but the installer will still install some files on your C: drive. It is recommended to accept the default settings.
The installer will now give you the option to name your instance of SQL Server. It is recommended to accept the default name of SQLExpress, but if you want you can rename the instance to CRM or another name if you choose.
On the Server Configuration page, you just need to make one change... change the Startup Type of the SQL Server Browser to “Automatic” and then click Next.
On the Database Engine Configuration page, change the Server Configuration Authentication Mode to Mixed Mode (SQL Server authentication and Windows authentication). The default System Administrator for SQL is
If you want, you can specify a different Data Directory on the Data Directories page. If your computer has more than two hard drives installed... like a C: Drive and a D: Drive, then you can put the SQL Database file (*.mdf) on one hard drive array and put the SQL Transaction log (*.ldf) on a separate hard drive array. This gives you the best performance. Do NOT do this if your machine has only one hard drive but is partioned into a C: drive and a D: drive. If you are unclear as to your computer’s hard drive configuration, then just accept the default settings on this page.
Just change the drive letter C: to a D: (or the appropriate letter) if you want. Do not install SQL Server on a thumb drive or an external USB drive.
In the Reporting Services Native Mode, just accept the default of Install and configure.
On the next screen, Error Reporting, select whether or not you want to send Error Reports to Microsoft.
The SQL Installer will now run to install on your computer. This will take some time. It is recommended you do NOT use your computer during this installation process as to not to interrupt the installer.
Once completed you should see the following screen. Green check marks are good. You have successfully installed Micrsoft SQL Server 2012 Express.
Optional: Step 6
If you are installing SQL on your server and will be sharing RedHorse out to other users, you will need to fol- low a couple of additional steps.
Turning on the TCP/IP and Named Pipe Alias using the SQL Server Configuration Manager
Just right click on Named Pipes and TCP/IP and Enable both of these
You will be prompted to Restart the SQL Server Service (which we will do on the next screen)
Just go up to the SQL Server Services listing and right click on your SQL Server to Restart the Service
Optional: Step 7
Configuring SQL Server 2012 and the Microsoft Firewall to Allow Connections to SQL Server:
When you install SQL on a Windows 7 or 8 “server” or Windows 2008 or 2012 server and you are running Win- dows Firewall on the “server”, you may run into problems trying to connect the workstations to the RedHorse SQL Database. If so, these instructions will solve this problem.
In SQL 2012 Management Studio, ensure that “Enable remote connections to the SQL Server”
Right click on your SQL Server name at the top of the tree in the left hand pane. Select Properties. Make sure there is a check box to “Allow remote connections to this server”/
Modify the settings of the Windows Firewall
On the machine you just installed SQL Server and in the Windows Firewall Advanced Configuration…
1) Set up Inbound and Outbound rules for TCP port 1433 2) Set up Inbound and Outbound rules for UDP port 1434
3) Set up inbound and outbound exceptions for sqlservr.exe. I am running a 64 bit machine so this file was located here:
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe
4) Set up inbound and outbound exceptions for sqlbrowser.exe. Again, I am running a 64 bit machine so the file was located here:
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe
The following screen shots will show the example of setting up an Inbound Rule for TCP Port 1433. You can repeat similar steps to configure the remaining inbound and outbound rules.
... you can name your Rule anything you would like, but it is a good idea to be descriptive should you need to troubleshoot or easily find the rule in the future.
Congratulations... you have completed a fully configured Microsoft SQL Server 2012 Express installation. Your
“server” is now ready for the installation of the RedHorse CRM software. Please follow the installation instruc- tions which can be found here:
http://redhorsesystems.com/support/documents-and-links/
