|
-
Sep 5th, 2006, 05:07 AM
#1
Thread Starter
New Member
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
-
Sep 5th, 2006, 05:26 AM
#2
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?
-
Sep 5th, 2006, 06:49 AM
#3
Thread Starter
New Member
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.
-
Sep 5th, 2006, 07:17 AM
#4
Re: SQL SERVER DB connection throug STATIC IP
SQL 2000 by default uses port 1433 - have you permitted that port through your router?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|