Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leader12344
Starting Member
2 Posts |
 Posted - 2005-07-08 : 11:17:55
|
| Hi i have this problem which occurs after i install sql 2000 from win 2000 on win 2003.I have 2 servers one IIS server (win2000) where i have my webpage (also installed sql 2000 server), and one file server (win2003)with sql 2000 where are my databases. The problem is that i want my wabepage to communicate with sql on win 2003 but that seems not to be happen. When i had before sql on win 2000 no such problem occured.I search a lot in forums and i found that might be a problem with security of windows 2003 server. Thanks in advance |
|
|
Rudi
Starting Member
1 Post |
Posted - 2005-07-08 : 16:07:54
|
| Can you connect from your web server to your database server? Are you using ODBC to connect to the SQL server? This maybe a firewall problem. Windows 2003 SP1 and some antivirus programs have firewalls included. An easy way to test if the SQL port is open is to telnet to port 1433.Go to your web server and type “telnet servername 1433”. If the port is open you will see a curser and if you hit enter it will move down one line. If the port is not open telnet will disappear or it may say “Could not open a connection to host” |
 |
|
|
leader12344
Starting Member
2 Posts |
Posted - 2005-07-09 : 09:05:15
|
| Thanks for your answer, finally i find a solution that worked for me, i just have to installed internet service manager in win 2003 server and make some registry settings |
|
|
|
|
|
|
Can't connect to sql 2000 from web