Innotech eServer - Manual (Page 85)

Page 85
eServer Setup and Site Installation Instructions
© Mass Electronics Pty Ltd 2009 Chapter 4 – Configuring eServer Communications
4-3.2 Default SQL Server 2008 R2 Express Edition Settings
Use the SQL Server Configuration Manager to manage Communication Protocol settings. This tool
is accessible from the Windows Start Menu once SQL Server 2008 R2 Express Edition is installed.
Recommended for advanced users only!
IMPORTANT
Table 4-1: Default SQL Server 2008 R2 Express Edition connection settings
Parameter Recommended Setting Notes
Default Instance MSSQLSERVER
Instance ID MSSQLSERVER
Authentication Mode Mixed Mode
Required for remote access to SQL
Server.
SQL Server Authentication Enabled
Communication Protocol Configuration
Shared Memory Protocol Enabled
Named Pipes Protocol Enabled
TCP/IP Protocol Enabled
TCP/IP Protocol Default
Port
1433
Ensure no other applications are
using port 1433 and 1434. Ensure
a firewall is not blocking incoming
or outgoing traffic on port 1433
and 1434.
UDP/IP Protocol Default
Port
1434
VIA Protocol Disabled