[ServerName].DOMAIN\INSTANCE, Port NO.
Fred.Fred.com\Ginger, 9876
or Fred\Ginger, 9876
Using SQL Server Browser
If the SQL Server Browser service is not running, you can still connect to
SQL Server if you provide the correct port number or named pipe. For
example, you can connect to the default instance of SQL Server with TCP/IP
if it is running on port 1433.
The following connections will not work:
* Any component that tries to connect to a named instance without fully
specifying all the parameters, such as the TCP/IP port or a named pipe.
* Any component that generates or passes server or instance information
that could later be used by other components to reconnect.
* Connecting to a named instance without providing the port number or
pipe. This includes Data Mirroring to a named instance and clustering a
named instance.
* Dedicated Administrator Connections to a named instance, or the
default instance if not using TCP/IP port 1434.
* The OLAP redirector service.
* Enumerating servers in SQL Server Management Studio, Enterprise
Manager, or Query Analyzer.
If you are using SQL Server in a client-server scenario, for example, when
your application is accessing SQL Server across a network, if you stop or
disable the SQL Server Browser service, you must assign a specific port
number to each instance and write your client application code to always use
that port number. This approach has the following problems:
* You must update and maintain client application code to make sure it
is connecting to the proper port.
* The port you choose for each instance might be used by another service
or application on the server, causing the SQL Server instance to be
unavailable.
On Fri, 29 Feb 2008 12:24:48 -0800, Rick Romack wrote
> Connect to a SQL 2005 server using a non default port and SQL
> browser is not running?
>
> Thanks
>
> Rick Romack
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> This e-mail message from State Compensation Insurance Fund and all
> attachments transmitted with it may be privileged or confidential
> and protected from disclosure. If you are not the intended recipient,
> you are hereby notified that any dissemination, distribution,
> copying, or taking any action based on it is strictly prohibited and
> may have legal consequences. If you have received this e-mail in
> error, please notify the sender by reply e-mail and destroy the
> original message and all copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page