Change History

Version	Date	Comment
Current Version (v. 1)	Apr 27, 2015 16:51	Katie Gielarowski

Overview

Microsoft's SQL Server Express is a scaled down, free edition of SQL Server, which includes the core database engine. While there are no limitations on the number of databases or users supported, it is limited to using one processor, 1 GB memory, and 10 GB database files.

TallySales has been tested and found compatible with the following versions of SQL Server Express:

- SQL Server Express 2008
- SQL Server Express 2008 R2
- SQL Server Express 2012

The same installation process can be used for all versions of SQL Server Express listed above.

While the newer versions of SQL Server Express allow for backwards compatibility, a database from a newer version cannot be attached to an older version.

System Requirements

	SQL Server 2008 Express	SQL Server 2008 R2 Express	SQL Server 2012 Express
Operating Systems	Windows Server 2003 Service Pack 2 Windows Server 2008 Windows Vista Windows Vista Service Pack 1 Windows XP Service Pack 2 Windows XP Service Pack 3	Windows Server 2003 Windows Server 2008 Windows Server 2008 R2 Windows 7 Windows Vista Windows XP	Windows Server 2008 SP2 Windows Server 2008 R2 Windows 8.1 Windows 8 Windows 7 Windows Vista SP2
Processor	32-Bit Systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended. Only a single processor is supported.) 64-Bit Systems: 1.4 GHz or higher processor (2 GHz or faster is recommended. Only a single processor is supported.)	32-Bit Systems: Pentium III-compatible processor or faster (Processor Speed - 1.0 GHz or faster) 64-Bit Systems: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support (Processor Speed - 1.0 GHz or faster)	32-bit systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.) 64-bit systems: 1.4 GHz or faster processor
Memory	256 MB (1 GB or more is recommended)	512 MB (2 GB or more is recommended)	512 MB (2 GB or more is recommended)
Disk Space	1GB	2.2 GB	2.2 GB
.Net Framework	.NET Framework 3.5 Service Pack 1	.NET Framework 3.5 Service Pack 1	.NET Framework 4.0
Windows Installer	Windows Installer 4.5	Windows Installer 4.5	Windows Installer 4.5
Windows Powershell	Windows PowerShell 1.0	Windows PowerShell 1.0	Windows PowerShell 2.0

Installation

Execute the SQL Server Express installation file (The SQL Server Installation Center screen appears).

The installation file varies by version and operating system.
Ensure Installation is selected on the task listing on the left hand side of the screen.
Select New SQL Server stand-alone installation (The SQL Server Setup License Agreement screen appears).
Select Accept the License Terms.
Select Next (The Product Updates screen appears).
Select Next (Any available updates are installed and the Install Setup Files screen appears).
Select Install (The Feature Selection screen appears).
Select the Select All button.
Select Next (The Instance Configuration screen appears).
Change the Named Instance to TallySoft.
Select Next (The Server Configuration screen appears).
Change the Startup Type of SQL Server Browser to Automatic.
Select Next (The Database Engine Configuration screen appears).
Select Mixed Mode.
Enter the Password for the System Administrator.

Contact TallySoft Technical Support for the recommended password for SQL Server's System Administrator account.
Select Next (The Reporting Services Configuration screen appears).
Select Next (The Error Reporting screen appears).
Select Next(The Installation begins and the Complete screen appears).

The installation can take up to 20 to 30 minutes depending on the configuration of the computer.
Select Close.

Creating TallySoftAdmin SQL User

Open the SQL Server Management Studio (SSMS).
Login to SSMS using the System Administrator (sa) account.

For more Information on opening and logging into the SQL Server Management Studio, please visit Microsoft's SQL Server Manager Studio Tutorial.
Expand Security.
Right Click Logins and select New Login (The Login - New screen appears).
Enter TallySoftAdmin as the Login name.
Select SQL Server authentication.
Enter the Password and Confirm Password for the TallySoftAdmin user.
Uncheck Enforce Password Policy.
Select the Server Roles page.
Select Sysadmin.
Select OK.

Enabling Network Protocols for SQL Server Express

From the Windows Start menu, Select Run (The Run window opens).
Enter compmgmt.msc, and then Select OK (The Computer Management window opens).
Expand Services and Applications.
Expand SQL Server Configuration Manager.
Expand SQL Server Network Configuration.
Select Protocols for TallySoft.
Right Click Named Pipes and Select Enable.
Right Click TCP/IP and Select Enable.
Right Click TCP/IP and Select Properties (The TCP/IP Properties window opens).
Select the IP Addresses Tab.
Locate the IP2 section and set the following values:
1. Set Active to Yes.
2. Set Enables to Yes.
3. Change the IP Address to the Unit’s IP Address.
4. Ensure TCP Dynamic Ports is set to 0.
5. Ensure TCP Port is blank.
Locate the IP All section and set the following values:
1. Ensure TCP Dynamic Ports is 0.
2. Ensure TCP Port is blank.
Select Apply.
Select OK.

The computer must be restarted prior to the changes taking effect.

Configuring the Windows Firewall

Creating a Firewall exception for SQL Browser

SQL Browser is a component within SQL that allows a SQL instance to be visible on the network. An exception may be needed within the Windows Firewall to allow the SQL Browser to accept and receive the required connections.

From the Windows Start menu, Select Run (The Run window opens).
Enter WF.msc, and then Select OK (The Computer Management window opens).
Select Inbound Rules.
Select New Rule From the Action pane (The New Inbound Rule Wizard appears).
Select Program as the Rule Type.
Select Next.
Select "This program path."
Select Browse (The Open window appears).
Navigate to the instance of SQL Browser.

By default, SQL Server 2008 R2 and 2012 installs the SQL browser in the C:\Program Files\Microsoft SQL Server\90\Shared\ folder of a 32-bit system. In a 64-bit system, it can be found at C:\Program Files (x86)\Microsoft SQL Server\90\Shared\.
Select Open (The Open window closes).
Select Next.
Select Allow the connection.
Select Next.
Ensure all profiles are selected.
Select Next.
Enter the Name as "SQL Browser".
Select Finish (The New Inbound Rule Wizard closes).

Creating a Firewall exception for SQL Server

SQL Server is the main component within SQL Server Express.

From the Windows Start menu, Select Run (The Run window opens).
Enter WF.msc, and then Select OK (The Computer Management window opens).
Select Inbound Rules.
Select New Rule From the Action pane (The New Inbound Rule Wizard appears).
Select Program as the Rule Type.
Select Next.
Select "This program path."
Select Browse. (The Open window appears).
Navigate to the instance of SQL Browser.
- SQL Server 2008 R2, by default, installs the SQL Server in the C:\Program Files\Microsoft SQL Server\MSSQL10_50.TALLYSOFT\MSSQL\Binn\ folder of a 32-bit system. In a 64-bit system, it can be found at c:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.TALLYSOFT\MSSQL\Binn\.
- SQL Server 2012, by default, installs the SQL Server in the C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\ folder of a 32-bit system. In a 64-bit system, it can be found at c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.TALLYSOFT\MSSQL\Binn\.
Select Open (The Open window closes).
Select Next.
Select Allow the connection.
Select Next.
Ensure all profiles are selected.
Select Next.
Enter the Name as "SQL Server".
Select Finish (The New Inbound Rule Wizard closes).

TallySoft Knowledge Base

Installing SQL Server Express

Table Of Contents