Re: Opening a TCP/ IP Port or Port Listener

From: Kevin (ReplyTo_at_Newsgroups.only)
Date: 07/30/03 

Date: Wed, 30 Jul 2003 08:58:08 -0700

if you're going to specify a port number in the hostname, you'll need to
make sure you are using tcp as your default client network protocol. you
can force this in qa as follows:

tcp:hostname,portnumber

in application code, use the connection string bit: NETWORK=DBMSSOCN 

--
----------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
"Carlos Eduardo Rojas" <carloser@mindspring.com> wrote in message
news:#A$NC0qVDHA.484@TK2MSFTNGP09.phx.gbl...
> Go to server network utility and specify the new tcp port there (you have
to
> restart the sql server service for this change to take effect). You can
> verify that it's working connecting from query analyzer and specifying
> instead of just the servername, the servername a comma and then the port.
> For example:
> servername,1888
>
> --
> Carlos E. Rojas
> SQL Server MVP
> Co-Author SQL Server 2000 Programming by Example
>
>
> "Steve Smith" <ssmithmail@yahoo.com> wrote in message
> news:0b2801c356a2$422ad5a0$a601280a@phx.gbl...
> > We are planning to give access from Web Server to SQL
> > Server through a different port other than 1433.
> > It is giving an error.
> >
> > On SQL Server side, is there anything that we have to do
> > to listen to the new port.
> >
> > Thanks
> >
> > Steve
> >
> >
>
>

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Failed connections to remote 2k SQL Server
    ... It could be a port issue - that would be my first guess. ... you need to open up UDP 1434 for SQL Server name ... TCP Ports Needed for Communication to SQL Server ... >server's network utility, and client network utility, and ensured that they ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to an instance in a cluster
    ... Each virtual server has its own IP address so you can reuse port numbers between instances. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: hack using xp_cmdshell
    ... I'm no security expert, so please forgive if I'm not using the right ... install SQL Server in Windows Only mode and then Switch down to Mixed mode, ... Is the SQL Server instance a default instance? ... > port 65300, which has never been open on my firewall. ...
    (microsoft.public.sqlserver.server)
  • Re: Failed connections to remote 2k SQL Server
    ... > It could be a port issue - that would be my first guess. ... you need to open up UDP 1434 for SQL Server name ... TCP Ports Needed for Communication to SQL Server ... >>server's network utility, and client network utility, and ensured that they ...
    (microsoft.public.sqlserver.setup)