Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment