SQL Server Performance

unable to connect a sql server on internet

Discussion in 'General DBA Questions' started by shreesoft00, Jan 12, 2003.

  1. shreesoft00 New Member

    i am unable to connect a server on my local machine i have sql 2000 standard and i have the ip address but its saying server doesnt exist
    how to rectify it?
  2. Chappy New Member

    make sure you both support a common netlib (such as TCP/IP). Check this from Client Network Config on your start menu.

    Also make sure the administrator knows youre trying to connect across the internet, and has opened any firewall rules which may have been applied.
    If you still have no luck, are you able to ping the server ?
  3. shreesoft00 New Member

    yes i am able to ping the server and i am able to connect it through terminal client also
    and it also have tcp/ip enabled and i have adm rights on that remote server
    but the message showing is server doesnt exists or accress denied
  4. mkarekar New Member

    How r u trying 2 connect to the SQL Server thru SQL server name or IP. If ur trying to connect thru name then try connecting thru IP address. If this does not work out try testing a ODBC Connectivity from ur local machine. It will give u some clu..

  5. bradmcgehee New Member

    Are you trying to login using SQL Server to Windows Security? You will need to use SQL Server security. Also, have you checked your firewall, if you have one?

    Brad M. McGehee
  6. satya Moderator

    Basically you have to open up the ports that SQL Server uses. If you've done this and it still doesn't work then look at the firewall logs (if you have) to see what packets it is dropping or do a network trace either side of the firewall to see what packets are not getting through. (You may want to disable/allow all through the firewall during testing to see what extra packets are allowed through).

    Which ports to open depends on the net-lib you are using for tcp-ip sockets the default port for SQL Server is 1433.


    Satya SKJ

Share This Page