Microsoft® SQL Server® 2012 Bible

34

Part I: Laying the Foundations

Firewalls

As part of the deployment process, Database Administrators need to work along with

Network Administrators to ensure that network fi rewalls are confi gured to allow inbound

and outbound traffi c to the SQL Server instance. If a network fi rewall is not properly

confi gured, connections to SQL Server instances and related services will be blocked. Table

3-3 lists the default ports for common SQL Server 2012 Services.

TABLE 3-3 Default Ports for Common SQL Server 2012 Services

Service Description Port

SQL Server Database Services Default Instance

Dedicated Admin Connection

TCP 1433

TCP 1434

SQL Server Analysis Services Default Instance TCP 2383

SQL Server Integration

Services

Default TCP 135

SQL Server Reporting Services Non-SSL (http://)

SSL (https://)

TCP 80

TCP 443

SQL Server Service Broker Default TCP 4022

SQL Server Browser Service Default UDP 1434

TCP 2382

Selecting the Edition

Selecting the right SQL Server Edition is another important consideration in the deploy-

ment plan because some editions have feature limitations and hardware support restric-

tions, while other editions are geared toward more specialized workloads.. The three main

editions of SQL Server 2012 include Standard Edition, Business Intelligence Edition, and

Enterprise Edition. SQL Server 2012 editions can be categorized as follows:

■ (^) Core Editions:
■ (^) Enterprise
■ (^) Business Intelligence
■ (^) Standard
■ (^) Specialized Editions:
■ (^) Developer
■ (^) Free Editions:
■ (^) Express
■ (^) Express LocalDB
■ (^) Compact
c03.indd 34c03.indd 34 7/30/2012 4:09:58 PM7/30/2012 4:09:58 PM
http://www.it-ebooks.info