Hello,
Server has 2 ins of sql server:
ESS_SQL
ESS_SQL\SQL_2000
Maybe this is known but no matter what I do I can't get it to point to
ESS_SQL\SQL_2000 as the distributor (always says ESS_SQL as the dist its
trying to connect to during a sync)
I think its truncating the \SQL_2000 (but just the @.distributor parameter)
@.distributor = N'ESS_SQL\SQL_2000',
I've tried ent manager to mod it after but cant seem to find a work-around--
This is how the the sub create scripts looks like:
exec sp_addmergepullsubscription @.publication = N'gwl', @.publisher =
N'ESS_SQL\SQL_2000', @.publisher_db = N'Intranet', @.subscriber_type =
N'anonymous', @.subscription_priority = 0.000000, @.sync_type = N'automatic',
@.description = N'Merge publication of gwb database from Publisher
ESS_SQL\SQL_2000.'
exec sp_addmergepullsubscription_agent @.publisher = N'ESS_SQL\SQL_2000',
@.publisher_db = N'Intranet', @.publication = N'gwl', @.distributor =
N'ESS_SQL\SQL_2000', @.subscriber_security_mode = 1, @.publisher_security_mode
= 1, @.distributor_security_mode = 1, @.enabled_for_syncmgr = N'true',
@.use_ftp = N'true', @.use_interactive_resolver = N'false', @.offloadagent =
N'false'
GO
Thanks!!!
Scott Kramer
CDS Technologies, Inc.
www.clevelanddata.com
www.groundzerohq.com
www.team501.com
hate to sound patronizing, but is ESS_SQL\SQL_2000 configured as the distributor for ESS_SQL?
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"S c o t t K r a m e r" wrote:
> Hello,
> Server has 2 ins of sql server:
> ESS_SQL
> ESS_SQL\SQL_2000
> Maybe this is known but no matter what I do I can't get it to point to
> ESS_SQL\SQL_2000 as the distributor (always says ESS_SQL as the dist its
> trying to connect to during a sync)
> I think its truncating the \SQL_2000 (but just the @.distributor parameter)
> @.distributor = N'ESS_SQL\SQL_2000',
> I've tried ent manager to mod it after but cant seem to find a work-around--
> This is how the the sub create scripts looks like:
>
> exec sp_addmergepullsubscription @.publication = N'gwl', @.publisher =
> N'ESS_SQL\SQL_2000', @.publisher_db = N'Intranet', @.subscriber_type =
> N'anonymous', @.subscription_priority = 0.000000, @.sync_type = N'automatic',
> @.description = N'Merge publication of gwb database from Publisher
> ESS_SQL\SQL_2000.'
> exec sp_addmergepullsubscription_agent @.publisher = N'ESS_SQL\SQL_2000',
> @.publisher_db = N'Intranet', @.publication = N'gwl', @.distributor =
> N'ESS_SQL\SQL_2000', @.subscriber_security_mode = 1, @.publisher_security_mode
> = 1, @.distributor_security_mode = 1, @.enabled_for_syncmgr = N'true',
> @.use_ftp = N'true', @.use_interactive_resolver = N'false', @.offloadagent =
> N'false'
> GO
>
> Thanks!!!
> --
> Scott Kramer
> CDS Technologies, Inc.
> www.clevelanddata.com
> www.groundzerohq.com
> www.team501.com
>
>
