sql server replication: I am attempting to replicate between a sqlserver 7.0 on
NT and a msde 2000 on win2k. I have set up the sqlserver
machine as the publisher and have attempted to push a
subscription out to the msde machine (through a firewall
with 1433 open). I am using ip addresses in sql
enterprise manager from my workstation as the enterprise
manager in the sqlserver machine cant connect to the msde
2000.

I get the following error:

Line 38: Incorrect syntax near ')'.
(Source: msde_ip_address(Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
xp_execresultset: unable to execute result set
(Source: msde_ip_address (Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
Line 38: Incorrect syntax near ')'.
(Source: msde_ip_address (Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
xp_execresultset: unable to execute result set
(Source: msde_ip_address (Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
..

I don't exactly know why you are getting this error. But few suggestions:

You say that you have registered one of the servers using IP address.
Enterprise Manager creates some problems with IP addresses. So, I'd suggest
you add an alias (using Client Network Utility) on your SQL Server, pointing
to the remote server. The alias name should be the same as the remote server
name. Now register this server in Enterprise Manager using this alias name.

Also make sure you are on latest service packs for both SQL Server 7.0 and
2000.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
I am attempting to replicate between a sqlserver 7.0 on
NT and a msde 2000 on win2k. I have set up the sqlserver
machine as the publisher and have attempted to push a
subscription out to the msde machine (through a firewall
with 1433 open). I am using ip addresses in sql
enterprise manager from my workstation as the enterprise
manager in the sqlserver machine cant connect to the msde
2000.

I get the following error:

Line 38: Incorrect syntax near ')'.
(Source: msde_ip_address(Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
xp_execresultset: unable to execute result set
(Source: msde_ip_address (Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
Line 38: Incorrect syntax near ')'.
(Source: msde_ip_address (Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
xp_execresultset: unable to execute result set
(Source: msde_ip_address (Data source); Error number:
50007)
----------------------------------------------------------
-----------------------------------------------------
..