<div>
You can add an alias name including the port number in SQL Server Configuration Manager:<br />
<br />
<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/ms174212.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms174212.aspx</a><br />

</div>


<div>
Hi Icohan,<br />
But why do you need to set up an alias. Surely the SQL Server Browser should take the client connection &nbsp;in and return back with the the port number automatically so it does not have to be explicitly defined in the client connection?
</div>


<div>
But then why do we need DNS and host files.....<br />
<br />
Did you tried that?<br />
<br />
And BTW - you mention &quot;&quot;... I can only connect to it when I specify the port number...&quot; however you don't mention what type of &quot;connection&quot;. You mean SSMS, ADO, .NET,....what &quot;connection&quot; you are talking about?
</div>


<div>
I am currently trying to connect using SSMS.<br />
Regards,<br />
&nbsp; &nbsp;Conor
</div>


<div>
<div class="content wysiwyg-content">
Just created a standalone SQL Server 2008 R2 instance. However I can only connect to it when I specify the port number even though SQL Server Browser is running.<br />
<br />
So I can connect &lt;servername&gt;,&lt;port no,&gt;\&lt;instance_name&gt;<br />
<br />
but NOT using &lt;servername&gt;\&lt;instance_nam<wbr />e&gt;<br />
<br />
Any ideas why that may be?<br />
<br />
Regards,<br />
<br />
&nbsp; Conor
</div>
</div>


Just created a standalone SQL Server 2008 R2 instance. However I can only connect to it when I specify the port number even though SQL Server Browser is running.

So I can connect <servername>,<port no,>\<instance_name>

but NOT using <servername>\<instance_name>

Any ideas why that may be?

Regards,

  Conor

You can add an alias name including the port number in SQL Server Configuration Manager:



http://technet.microsoft.com/en-us/library/ms174212.aspx


Hi Icohan,
But why do you need to set up an alias. Surely the SQL Server Browser should take the client connection  in and return back with the the port number automatically so it does not have to be explicitly defined in the client connection?

But then why do we need DNS and host files.....

Did you tried that?

And BTW - you mention &quot;&quot;... I can only connect to it when I specify the port number...&quot; however you don&#39;t mention what type of &quot;connection&quot;. You mean SSMS, ADO, .NET,....what &quot;connection&quot; you are talking about?

I am currently trying to connect using SSMS.
Regards,
   Conor

Specified named instance and browser is running but still need to specify port number.

Just created a standalone SQL Server 2008 R2 instance. However I can only connect to it when I specify the port number even though SQL Server Browser is running.

So I can connect &lt;servername&gt;,&lt;port no,&gt;\&lt;instance_name&gt;

but NOT using &lt;servername&gt;\&lt;instance_name&gt;

Any ideas why that may be?

Regards,

  Conor

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.