<div>
We are considering getting a second server for SQL but until then I need to get this going. I you give me more insight on how to configure the group policy for random port exceptions.
</div>


We are considering getting a second server for SQL but until then I need to get this going. I you give me more insight on how to configure the group policy for random port exceptions.

<div>
We installed the second instance successfully
</div>


We installed the second instance successfully

<div>
We successfully installed a second instance
</div>


We successfully installed a second instance

<div>
<div class="content wysiwyg-content">
I have a new installation of SQL 20082 running on SBS 2011 premium. 2 installed applications will not connect via TCP/IP we need to create an OBDC data connector with named pipes. &nbsp;These applications connected in the old SQL server. &nbsp;DNS seems to work OK. &nbsp;This box is SBS 2011 Premium and SQL is installed on that servernot a second server. &nbsp;<br />
<br />
Note: this may be a licesing problem. &nbsp;When I look at the properties on my computer is lists this as Windows SBS 2011 standard not Premium. &nbsp;I have a primium license key not I am not sure where to enter it.
</div>
</div>


I have a new installation of SQL 20082 running on SBS 2011 premium. 2 installed applications will not connect via TCP/IP we need to create an OBDC data connector with named pipes.  These applications connected in the old SQL server.  DNS seems to work OK.  This box is SBS 2011 Premium and SQL is installed on that servernot a second server.  

Note: this may be a licesing problem.  When I look at the properties on my computer is lists this as Windows SBS 2011 standard not Premium.  I have a primium license key not I am not sure where to enter it.

SQL 2008 R2 instances will only connect with named pipes not TCP/IP

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).