RE: SQL Server 2005 Connection Problems
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng[MSFT])
- Date: Fri, 10 Feb 2006 08:32:57 GMT
Hi Trex,
Welcome.
From your description, one of your server machine A have both Sqlserver2000 and 2005 instances installed and another client machine B(in same
local intranet) can connect both the two instances correctly through MDAC
UDL. However, when move to another machine C in different intranet, it can
only connect to the 2000 instance, correct?
As for this problem, I agree that we may first check the firewall setting
to see whether it has blocked the sql 2005 instance's listening port. To
lookup sqlserver instance's listening port, you can open the SQL Server
Configuration Manager, choose "SQL Server 2005 network configuration",
choose the certain 2005 instance. Then, in the right panel, select Tcp/ip
protocol and right click to select "properties" item. In the property
window, select "Ip address" tab, and you can find the port number
associated to each configured IP address. If the TCP port is assigned, it
will use that assigned port, if not, that'll use a dynamic choosed one
(which maybe a bit hard to detect). Anyway, for testing, you can explicitly
assign one if it isn't originally.
BTW, there is one tool called "processExplorer" on sysinternals site that
can help explore processes and its holding tcp ports:
#http://www.sysinternals.com/Utilities/ProcessExplorer.html
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
.
- Prev by Date: SQL 2005 2005 CTP Setup - ERROR
- Next by Date: Cant uninstall SQL2005
- Previous by thread: SQL 2005 2005 CTP Setup - ERROR
- Next by thread: RE: SQL Server 2005 Connection Problems
- Index(es):
Relevant Pages
|
