Connecting without SQL Browser

I'm unable to connect to my named instance of SQL Server 2005 when the
Browser service isn't running on the server.
I do specify the port that the SQL Server instance is listening to in the
connection string, as in SERVER:PORT
Is it impossible to connect to an instance of SQL Server when the browser
isn't running? I have verified that the server will accept remote
connections, and I can connect as soon as I start the browser.
Hello,
You may want to check the SQL 2005 process ID in task manager, and then run
the following command to see if the PID is listening on the proper port
netstat -aon
If it is OK, please try to telnet the port from client:
telnet <server name> <port number>
If not, it seems there is firewall blocking the port. Please check
Windows/third party firewall on the server to test
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Connecting without SQL Browser
>thread-index: AcZCiOBLNVbTQlN8TSihYXkvAvuyTQ==
>X-WBNR-Posting-Host: 84.147.139.248
>From: =?Utf-8?B?UGF0?= <pat@.online.nospam>
>Subject: Connecting without SQL Browser
>Date: Wed, 8 Mar 2006 00:18:27 -0800
>Lines: 7
>Message-ID: <87FE193F-FB5E-4CF3-ACA0-6AAA087B9E47@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:423714
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I'm unable to connect to my named instance of SQL Server 2005 when the
>Browser service isn't running on the server.
>I do specify the port that the SQL Server instance is listening to in the
>connection string, as in SERVER:PORT
>Is it impossible to connect to an instance of SQL Server when the browser
>isn't running? I have verified that the server will accept remote
>connections, and I can connect as soon as I start the browser.
>
|||From the SQL Server log:
Server process ID is 1552
Server is listening on [ 'any' <ipv4> 1743].
Server local connection provider is ready to accept connection on [
\\.\pipe\SQLLocal\S5 ].
Server local connection provider is ready to accept connection on [
\\.\pipe\MSSQL$S5\sql\query ].
Server is listening on [ 127.0.0.1 <ipv4> 1744].
Dedicated admin connection support was established for listening locally on
port 1744.
SQL Server is now ready for client connections. This is an informational
message; no user action is required.
From netstat -aon
TCP 0.0.0.0:1743 0.0.0.0:0 LISTENING 1552
TCP 127.0.0.1:1744 0.0.0.0:0 LISTENING 1552
Connecting with Telnet from the client gives "Connect failed", also when the
Browser is started.
"Peter Yang [MSFT]" wrote:

> Hello,
> You may want to check the SQL 2005 process ID in task manager, and then run
> the following command to see if the PID is listening on the proper port
> netstat -aon
> If it is OK, please try to telnet the port from client:
> telnet <server name> <port number>
> If not, it seems there is firewall blocking the port. Please check
> Windows/third party firewall on the server to test
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
>
|||Hello,
Apparently you have firewall on the server blocks port 1552. Please
temporarily disable firewalls to test the situation. If it works, you could
open port on firwall to solve the problem.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Connecting without SQL Browser
>thread-index: AcZCp+TVAS+gwqT9QQy7/KMJ33jN/g==
>X-WBNR-Posting-Host: 84.147.139.248
>From: =?Utf-8?B?UGF0?= <pat@.online.nospam>
>References: <87FE193F-FB5E-4CF3-ACA0-6AAA087B9E47@.microsoft.com>
<ODsJWLqQGHA.5448@.TK2MSFTNGXA03.phx.gbl>
>Subject: RE: Connecting without SQL Browser
>Date: Wed, 8 Mar 2006 04:00:29 -0800
>Lines: 87
>Message-ID: <7F0CD604-75BE-4858-9745-BC6E621A7D15@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:423729
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>From the SQL Server log:
>Server process ID is 1552
>Server is listening on [ 'any' <ipv4> 1743].
>Server local connection provider is ready to accept connection on [
>\\.\pipe\SQLLocal\S5 ].
>Server local connection provider is ready to accept connection on [
>\\.\pipe\MSSQL$S5\sql\query ].
>Server is listening on [ 127.0.0.1 <ipv4> 1744].
>Dedicated admin connection support was established for listening locally
on
>port 1744.
>SQL Server is now ready for client connections. This is an informational
>message; no user action is required.
>From netstat -aon
>TCP 0.0.0.0:1743 0.0.0.0:0 LISTENING 1552
>TCP 127.0.0.1:1744 0.0.0.0:0 LISTENING 1552
>Connecting with Telnet from the client gives "Connect failed", also when
the[vbcol=seagreen]
>Browser is started.
>
>"Peter Yang [MSFT]" wrote:
run[vbcol=seagreen]
rights.[vbcol=seagreen]
the[vbcol=seagreen]
browser
>
|||1552 is the process id of sql server in the example.
"Peter Yang [MSFT]" wrote:

> Hello,
> Apparently you have firewall on the server blocks port 1552. Please
> temporarily disable firewalls to test the situation. If it works, you could
> open port on firwall to solve the problem.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> <ODsJWLqQGHA.5448@.TK2MSFTNGXA03.phx.gbl>
> on
> the
> run
> rights.
> the
> browser
>
|||Hello Pat,
Sorry. My typo. Server port 1743 shall be opened by firewall. Also, client
network shall be configured to 1743 as well.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Connecting without SQL Browser
>thread-index: AcZMNgMtU2vKHeRwTEqMU7ZbMxx2xA==
>X-WBNR-Posting-Host: 84.147.154.98
>From: =?Utf-8?B?UGF0?= <pat@.online.nospam>
>References: <87FE193F-FB5E-4CF3-ACA0-6AAA087B9E47@.microsoft.com>
<ODsJWLqQGHA.5448@.TK2MSFTNGXA03.phx.gbl>
<7F0CD604-75BE-4858-9745-BC6E621A7D15@.microsoft.com>
<PBj2TK1QGHA.6216@.TK2MSFTNGXA03.phx.gbl>[vbcol=seagreen]
>Subject: RE: Connecting without SQL Browser
>Date: Mon, 20 Mar 2006 07:50:29 -0800
>Lines: 146
>Message-ID: <B93CC259-A26F-444C-93C7-1155FDC5310C@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:424932
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>1552 is the process id of sql server in the example.
>"Peter Yang [MSFT]" wrote:
could[vbcol=seagreen]
rights.[vbcol=seagreen]
locally[vbcol=seagreen]
informational[vbcol=seagreen]
when[vbcol=seagreen]
then[vbcol=seagreen]
port[vbcol=seagreen]
so[vbcol=seagreen]
the[vbcol=seagreen]
in
>