Results 1 to 4 of 4

Thread: SQL SERVER DB connection throug STATIC IP

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Posts
    5

    SQL SERVER DB connection throug STATIC IP

    HI guys....
    i developed ASP.NET web application. i have my own web server with static IP. i have also installed winproxy. i m using DSL modem/router...

    www.connectionstrings.com
    where i got the connection string for how to connect with ip address..
    but its not working... the firewalls of windows and winproxy are disabled.. but i dont understand why i m not connecting with sql server databse througu staic ip.

    one more thing that i wana include my web server databse at my home pc.
    SQL SERVER 2000 ENTERPRISE EDITION is instlled at my web server and home pc too.

    i try to register it but the following messages come.. somes times timed out expired comes

    ---------------------------
    SQL Server Enterprise Manager
    ---------------------------
    SQL Server registration failed because of the connection failure displayed below. Do you wish to Register anyway?

    General network error. Check your network documentation. ConnectionRead (recv())

    ---------------------------
    SQL Server Enterprise Manager
    ---------------------------
    SQL Server registration failed because of the connection failure displayed below. Do you wish to Register anyway?

    Invalid connection.
    ConnectionOpen (ParseConnectParams())
    ---------------------------

    Please help me in this regard... i m in gr8 trouble

  2. #2
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: SQL SERVER DB connection throug STATIC IP

    I am slightly puzzled. Why do you want to connect remotely from a web application? Is the database on a different server to the website?

    Regardless, have you forwarded the appropriate port in your router configuration?

  3. #3

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Posts
    5

    Re: SQL SERVER DB connection throug STATIC IP

    yes web site is host at another web server and databases are on different web server... and i have all their static ips
    i wana also register these databse in SQL SERVER 2000 ENTERPRISE MANAGER.

  4. #4
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: SQL SERVER DB connection throug STATIC IP

    SQL 2000 by default uses port 1433 - have you permitted that port through your router?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width