Re: SQL server connection problem

Hi, I don;t think I have any firewall installed but how to verify that
no firewall is installed ? Also i have check that port 1433 is not
there on the server and client. Will SQL server only connect to this
port or any other port number ? I've read that SQL will dynamically
connect from port 1024 onwards, is it true ? If alias is not connected
with ip address , port number and even name , then how does it connect
to the server ?

Regards
Daniel


Erland Sommarskog wrote:
> (Danieltbt05@xxxxxxxxx) writes:
> > Yes I've check in my server the SQL service is running. No i tried to
> > connect from another machine. Server is Win2003 standard server and
> > client is Win2000 prof. Both netlib uses TCP/IP and port 1433. I
> > configure both named pipe to be the same. Each can ping each other
> > either by IP or host name. I never change any protocol, uses the
> > default TCP/IP. As far as i know there is no firewall between them,
> > unless there is the windows internal firewall security ? is it
> > possible? .
>
> I Windows Firewall is running on the machine with SQL Server, you will need
> to configure the firewall to permit connections to SQL Server.
>
> > Btw what is alias for ? by using alias i can find the
> > server host name but not IP . Thanks
>
> Aliases are good when connection by name does not work, and you don't want
> to use IP-address and port number all the time.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • RE: FTP Window of opportunity?
    ... does it seemingly accept the connections and drop them once the response ... Subject: FTP Window of opportunity? ... blocked by the firewall. ... the FTP port shows up. ...
    (Pen-Test)
  • RE: an error in the NMAP docs?
    ... normal "non-passive" FTP connections create a connection FROM the server ... FROM port 20 back to an ephemeral port on the client for data transfers. ... "Many naive firewall and packet filter installations make an exception ... Earn your MS in Information Security ONLINE ...
    (Security-Basics)
  • Re: Firewalls: whats the use?
    ... > local connections and it is not possible to connect to it from the ... > Since it is a web server I obviously need to allow traffic from anyone ... > to port 80. ... The basic thing that a firewall does is limit what you have to worry about. ...
    (comp.os.linux.security)
  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)