Cannot drop article ''TABLE60'' from publication ''DB_Comp''...

[ Merge Replication ]
I work with a software that the act deletion and creation of the table
and deletion and creation and change of the field by the users happens
so much.
for deletion of the table using this command :
sp_dropmergearticle @.publication='DB_Doc',
@.article = 'TABLE65',
@.force_invalidate_snapshot=1
, but after execute this command displayed below message :
"Cannot drop article 'TABLE65' from publication 'DB_Doc' because its
snapshot has been run and this publication could have active
subscriptions."
how can i drop the table in active merge replication with T-SQL(System
Stored Procedure)?
thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
As far as I know, you can't. The best you can do is synchronize all
subscribers until no change is applied, drop the publication, change the
table on the publisher and subscribers, readd the publication and do a
nosync initialization.
Rgds,
Paul Ibison

Cannot detach suspect db

A db is flagged as suspect. I tried to detach it or take
offline but was unable to as the db is replicated (merge
replication). At the same time I was unable to cancel the
replication because the db wasn't found.
The suspect status was caused by the db failing to close
cleanly after a failed back-up. I also haven't been able
to succesfully run sp_resetstatus.
Any ideas onhow to break out of this catch 22 situation?
RegardsHere's an old post i found that explains how to fix a suspect db :-
http://groups.google.co.uk/groups?q=sql+2000+suspect+fix&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=dcde2a5a.0309151952.424b43cb%40posting.google.com&rnum=1
--
HTH
Ryan Waight, MCDBA, MCSE
<japan11@.hotmail.com> wrote in message
news:074901c39147$f819ece0$a301280a@.phx.gbl...
> A db is flagged as suspect. I tried to detach it or take
> offline but was unable to as the db is replicated (merge
> replication). At the same time I was unable to cancel the
> replication because the db wasn't found.
> The suspect status was caused by the db failing to close
> cleanly after a failed back-up. I also haven't been able
> to succesfully run sp_resetstatus.
> Any ideas onhow to break out of this catch 22 situation?
> Regards

cannot deliver sp_repldropcolum schema change

Hello
As our customers use our product often offline, we implemted a sql server
2000 merge replication with msde anonymous subscribers.
With the new product release go some schemachanges, which we implemted with
sp_repladdcolumn and sp_repldropcolumn (e.g." exec sp_repldropcolumn
@.source_object = 'verlauf_ver', @.column = 'c_mandant',
@.force_reinit_subscription = 1").
I can complete the changes on the publisher without errors (only the
warning, that you can synchronize with sql 2000 and above only).
When I synchronize the subscriber, firstly it seems to work, but the it
stops and says, it cannot deliver the changes "exec sp_repldropcolumn..."
Are there any ideas?
Is it possible, there's a kind of restriction on the amount of changes?
Thanks for any help
Regards
Please can you post up the exact error message. Also you might want to
enable logging and see if that gives any more info (and post that up as well
please).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hello Paul
At the moment, I'm checking out something else.
But after that, I'll do what you ask me for. But can you tell me, how I can
enable Logging? And where to find this Log?
Thanks a lot
Aline
"Paul Ibison" wrote:

> Please can you post up the exact error message. Also you might want to
> enable logging and see if that gives any more info (and post that up as well
> please).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Hi Aline - this article explains it well:
http://support.microsoft.com/?id=312292
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hello Paul
Thanks for the Link, which was very useful. I didn't realise, I could enable
such a logging (though I've already read about it before)
So here's the statement:
exec sp_repldropcolumn @.source_object = 'c_controldef', @.column = 'mandid',
@.force_invalidate_snapshot = 1, @.force_reinit_subscription = 1
and here's the log (in German, sorry):
Microsoft SQL Server-Merge-Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Percent Complete: 0
Verbindung mit Abonnent 'winxpsp2\syseca'
Connecting to Abonnent 'winxpsp2\syseca.challenge'
Server: winxpsp2\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[16.11.2006 13:55:53]winxpsp2\syseca.challenge: {call sp_MSgetversion }
[16.11.2006 13:55:53]winxpsp2\syseca.challenge: {?=call
sp_helpsubscription_properties (N'vistatestpc\syseca', N'challenge',
N'challenge')}
Distributor security mode: 0, login name: rai_application, password: ********.
Percent Complete: 0
Verbindung mit Verteiler 'vistatestpc\syseca'
Connecting to Verteiler 'vistatestpc\syseca.'
Server: vistatestpc\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: guest
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[16.11.2006 13:55:53]vistatestpc\syseca.: {call sp_MSgetversion }
[16.11.2006 13:55:53]vistatestpc\syseca.: {call sp_helpdistpublisher
(N'vistatestpc\syseca') }
[16.11.2006 13:55:53]vistatestpc\syseca.distribution: select datasource,
srvid from master..sysservers where upper(srvname) =
upper(N'vistatestpc\syseca')
[16.11.2006 13:55:53]vistatestpc\syseca.distribution: {call
sp_MSadd_merge_anonymous_agent(N'0', N'challenge', N'challenge',
N'challenge', N'winxpsp2\syseca',?, 667)}
[16.11.2006 13:55:53]vistatestpc\syseca.distribution: {call
sp_MShelp_profile (2, 4, N'')}
Percent Complete: 0
Connecting to Verleger 'vistatestpc\syseca.challenge'
Initialisiert
Percent Complete: 1
Verbindung mit Verleger 'vistatestpc\syseca'
Server: vistatestpc\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[16.11.2006 13:55:53]vistatestpc\syseca.challenge: set nocount on declare
@.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255)
select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname,
N'COLLATION')) select collationproperty(@.collation, N'CODEPAGE') as
'CodePage', collationproperty(@.collation, N'LCID') as 'LCID',
collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
Connecting to Verleger 'vistatestpc\syseca.challenge'
Server: vistatestpc\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[16.11.2006 13:55:54]vistatestpc\syseca.challenge: {call sp_MSgetversion }
Percent Complete: 3
Ruft Publikationsinformationen ab
Percent Complete: 4
Ruft Abonnementinformationen ab
Connecting to Abonnent 'winxpsp2\syseca.challenge'
Server: winxpsp2\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
Server: winxpsp2\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[16.11.2006 13:55:54]vistatestpc\syseca.challenge: exec sp_datatype_info 0, 3
Percent Complete: 4
[16.11.2006 13:55:54]winxpsp2\syseca.challenge: exec sp_repldropcolumn
'[dbo].[c_controldef]', 'mandid', 1
Eine Spalte wurde zur replizierten Tabelle hinzugefügt oder aus dieser
gel?scht.
Das Schemaskript 'exec sp_repldropcolumn '[dbo].[c_controldef]', 'mandid',
1' konnte nicht an den Abonnenten weitergegeben werden.
Percent Complete: 0
Das Schemaskript 'exec sp_repldropcolumn '[dbo].[c_controldef]', 'mandid',
1' konnte nicht an den Abonnenten weitergegeben werden.
Percent Complete: 0
Category:NULL
Source: Mergereplikationsprovider
Number: -2147201001
Message: Das Schemaskript 'exec sp_repldropcolumn '[dbo].[c_controldef]',
'mandid', 1' konnte nicht an den Abonnenten weitergegeben werden.
at the end it says: The schemascript sp_repldropcolumn
'[dbo].[c_controldef]', 'mandid', 1' couldn't be delivered to the subscriber
Unfortunately it doesn't tell my why.
There are a lot of different changes before which work fine. And afterwards
are also 46 sp_repldropcolumn.
Strangely, if I comment out these 47 sp_repldropcolumn's, update the
publisher, synchronize the subscriber, and then update the publisher with
these 47 47 sp_repldropcolumn's and synch the subscriber, it works...
As the product is install at more than 100 customers, I need something
automatic.
Any further help?
Thanks
Aline
|||My guess is that something references the column on the subscriber. Please
take a look at this article and see if it applies:
http://support.microsoft.com/kb/816755
One way to test this would be to restore a backup of the subscriber database
to another database nema and try to drop the column directly and hopefully
you wont be able to and will get a message referring to the constraint that
prevents the drop. If you can get this, you can drop the constraint using
sp_addscriptexec (assuming it is nothing to do with a filter).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Paul
It still doesn't work correctly. I've got the following error, when adding a
script:
Script:
....
exec sp_addscriptexec @.publication = N'challenge',
@.scriptfile='c:\programme\syseca\DB-Scripts\Replikation\ReplicationScripts\DropConstra ints.sql'
exec sp_repldropcolumn @.source_object = 'c_controldef', @.column = 'mandid',
@.force_invalidate_snapshot = 1, @.force_reinit_subscription = 1
...
error:
xpsql.cpp: Fehler 997 von GetProxyAccount in Zeile 604
Meldung 21330, Ebene 16, Status 1, Server VISTATESTPC\SYSECA, Prozedur
sp_MScopyscriptfile, Zeile 31
Fehler beim Erstellen eines Unterverzeichnisses unter dem
Replikationsarbeitsverzeichnis. (md
"\\vistatestpc\snapshot\20061116210031497")
--> error while building subdirectory...
I think, the path should be something like this:
"\\vistatestpc\snapshot\unc\SERVERNAME$INSTANCENAM E_PUBLICATION_DATABASE\20061116210031497"
Shouldn't the distributor handle this? By the way: Distributor and Publisher
are installed on the same server and dbms.
what can I do?
Thanks a lot
Aline
|||I'm not familiar with the normal log messages, but it looks like you have
configured a proxy account. Is the proxy account that the merge agent is
using in the Local admins group on the server? (or at least set up with the
necessary rights)? (it's generally much easier to have the merge agent run
as the sql server agent although SQL Serever 2005 uses these proxies by
default) Also, is there enough space on the server?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||sql server agent runs as a local administrator. so I think it has all
necessary rights.
what confuses me is, why does it try to make a new folder and why are these
typical "unc\servername..." missing in the path?
|||I'll take a proper look tomorrow when I get back to work if nobody's solved
it by then.
Before that, can you confirm is you are using a proxy account for
non-sysadmins or not, and that the account (if you are) has the necessary
rights.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

cannot deliver inserts

HI we are using merge replication and now i am getting the
error message as ' cannot deliver inserts to the publisher'
Kiran,
does restarting the agent fix the issue? If not, then are you replicating to
CE - known issue there
(http://support.microsoft.com/default...b;en-us;328314). If neither
of these apply, then please enable logging
(http://support.microsoft.com/?id=312292) and post up further details of the
schema and error message>
Thanks,
Paul Ibison
|||HI paul thanks,
but we are using sql2000 merge replication.
so this article deosn't apply to us.

>--Original Message--
>Kiran,
>does restarting the agent fix the issue? If not, then are
you replicating to
>CE - known issue there
>(http://support.microsoft.com/default.aspx?scid=kb;en-
us;328314). If neither
>of these apply, then please enable logging
>(http://support.microsoft.com/?id=312292) and post up
further details of the
>schema and error message>
>Thanks,
>Paul Ibison
>
>.
>
|||Kiran,
ok, then check that the subscriber can 'see' the publisher using QA. If not,
then it's a connectivity issue, if it can then enable logging and post up
the message.
Regards,
Paul Ibison
|||Hi paul,
it was happening becos of the conflicts we had for that
subscriber. It was taking so long to reconcoile the
conflicts. i ended up recreating subscription and now it
seems fine.
thanks
>--Original Message--
>Kiran,
>ok, then check that the subscriber can 'see' the
publisher using QA. If not,
>then it's a connectivity issue, if it can then enable
logging and post up
>the message.
>Regards,
>Paul Ibison
>
>.
>
|||Kiran,
thanks for the update. Recreating the subscription has removed the conflicts
so you don't experience the same problem straight away. To prevent this
error in future, you might want to create a custom profile for your merge
agent and increase the QueryTimeOut .
Regards,
Paul Ibison

Cannot delete merge publication

Hello...
I had a merge publication that I thought was removed...at least it does not
appear in Ent. Mgr under the list of Publications. However, in the
Replication Monitor the publication still exists. When I click on the
publication to delete or check its properties I get the mesage:
SQL Server could not retrieve information about publication 'My_Publication'
Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
MergePublications collection. If the name is a qualified name...'
I searched for that error code...but could not find anything that would help
me solve this problem.
if anyone has any ideas, it would be appreciated.
thanks
- dw
check sysmergepublications in the publications database. Do you find the
publication there?
If so you will need to delete it and the matching sysmergearticles columns.
Also delete the rows for this publication from
distribution.dbo.MSpublications
Hilary Cotter
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
"dw" <dw@.discussions.microsoft.com> wrote in message
news:85F329D5-E863-41A5-8AB3-8BB008C98EC7@.microsoft.com...
> Hello...
> I had a merge publication that I thought was removed...at least it does
not
> appear in Ent. Mgr under the list of Publications. However, in the
> Replication Monitor the publication still exists. When I click on the
> publication to delete or check its properties I get the mesage:
> SQL Server could not retrieve information about publication
'My_Publication'
> Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
> MergePublications collection. If the name is a qualified name...'
> I searched for that error code...but could not find anything that would
help
> me solve this problem.
> if anyone has any ideas, it would be appreciated.
> thanks
> - dw

Cannot create Merge Replication in 2005

Hi to All,
I had sql 2005 with sp3 and i was working succesfully with merge
replication on Sql ce.
Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4)
Now i am here in sql 2005 trying to create a new merge replication on
windows mobile 2005 and i get to the final step this error
------
TITLE: New Publication Wizard
New Publication Wizard encountered one or more errors while retrieving
publication names.
For help, click:
http://go.microsoft.com/fwlink?ProdN...s&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'snapshot_jobid'.
Invalid column name 'use_partition_groups'.
Invalid column name 'replicate_ddl'.
Invalid column name 'publication_number'.
Invalid column name 'allow_subscriber_initiated_snapshot'.
Invalid column name 'allow_web_synchronization'.
Invalid column name 'web_synchronization_url'.
Invalid column name 'allow_partition_realignment'.
Invalid column name 'retention_period_unit'.
Invalid column name 'decentralized_conflicts'.
Invalid column name 'generation_leveling_threshold'.
Invalid column name 'automatic_reinitialization_policy'.
Invalid column name 'snapshot_jobid'.
Invalid column name 'use_partition_groups'.
Invalid column name 'replicate_ddl'.
Invalid column name 'publication_number'.
Invalid column name 'allow_subscriber_initiated_snapshot'.
Invalid column name 'allow_web_synchronization'.
Invalid column name 'web_synchronization_url'.
Invalid column name 'allow_partition_realignment'.
Invalid column name 'retention_period_unit'.
Invalid column name 'decentralized_conflicts'.
Invalid column name 'generation_leveling_threshold'.
Invalid column name 'automatic_reinitialization_policy'. (Microsoft SQL
Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
------
Can anyone please help ?
Thanks
Savvas
What all did you do when you upgraded?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1139562228.104138.260770@.f14g2000cwb.googlegr oups.com...
> Hi to All,
> I had sql 2005 with sp3 and i was working succesfully with merge
> replication on Sql ce.
> Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4)
> Now i am here in sql 2005 trying to create a new merge replication on
> windows mobile 2005 and i get to the final step this error
> ------
> TITLE: New Publication Wizard
> --
> New Publication Wizard encountered one or more errors while retrieving
> publication names.
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...s&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'snapshot_jobid'.
> Invalid column name 'use_partition_groups'.
> Invalid column name 'replicate_ddl'.
> Invalid column name 'publication_number'.
> Invalid column name 'allow_subscriber_initiated_snapshot'.
> Invalid column name 'allow_web_synchronization'.
> Invalid column name 'web_synchronization_url'.
> Invalid column name 'allow_partition_realignment'.
> Invalid column name 'retention_period_unit'.
> Invalid column name 'decentralized_conflicts'.
> Invalid column name 'generation_leveling_threshold'.
> Invalid column name 'automatic_reinitialization_policy'.
> Invalid column name 'snapshot_jobid'.
> Invalid column name 'use_partition_groups'.
> Invalid column name 'replicate_ddl'.
> Invalid column name 'publication_number'.
> Invalid column name 'allow_subscriber_initiated_snapshot'.
> Invalid column name 'allow_web_synchronization'.
> Invalid column name 'web_synchronization_url'.
> Invalid column name 'allow_partition_realignment'.
> Invalid column name 'retention_period_unit'.
> Invalid column name 'decentralized_conflicts'.
> Invalid column name 'generation_leveling_threshold'.
> Invalid column name 'automatic_reinitialization_policy'. (Microsoft SQL
> Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
> ------
> Can anyone please help ?
> Thanks
> Savvas
>

Cannot create merge replication from SQLSERVER 2000 to ORACLE

Hello everybody,
I am trying to build a merge replication between 2 servers
i managed to create it between to SQLSERVER 2000 with no problem
but now i am trying to do it between SQLSERVER 2000 and ORACLE server
when i try to do a transactional replication it work fine between the two
servers
but when i try to do the merge replication the following error occur:
The step did not generate any output. The step failed
i searched the topics and did not find any help but i managed to try writing
the output error on a file and it gave me the following message:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
Category:NULL
Source: Merge Process
Number: -2147200933
Message: The process could not load the Merge Replication Provider for
'Oracle'. Check to see if the component is registered correctly.
if anyone can help me with, please do
best Regards
Nicolas
This is not supported, you can only replicate to SQL Server, MSAcess and SQL
CE. You will have to cobble a solution together for this.
Hilary Cotter
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
"Nicolas Akl" <c_khano@.hotmail.com> wrote in message
news:D66DB88D-29E0-449B-B578-D775BFDD2572@.microsoft.com...
> Hello everybody,
> I am trying to build a merge replication between 2 servers
> i managed to create it between to SQLSERVER 2000 with no problem
> but now i am trying to do it between SQLSERVER 2000 and ORACLE server
> when i try to do a transactional replication it work fine between the two
> servers
> but when i try to do the merge replication the following error occur:
> The step did not generate any output. The step failed
> i searched the topics and did not find any help but i managed to try
writing
> the output error on a file and it gave me the following message:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
> Category:NULL
> Source: Merge Process
> Number: -2147200933
> Message: The process could not load the Merge Replication Provider for
> 'Oracle'. Check to see if the component is registered correctly.
> if anyone can help me with, please do
> best Regards
> Nicolas
|||Dear Hilary,
As i understand from you, that there is no way to make a merge
replication from sqlserver 2000 to Oracle,
if so why does it support transactional replication and not the merge
replication
Best Regards
Carlo khanati.

Cannot connect to subscriber

Setup:
- SQL2000 SP3 running on Windows2000 servers.
I have a merge replication running between three identical servers. Two of
the servers, the publisher and subscriber1, receive data from different
sources and are synced every day at 4am. Subscriber2 is a query server only
and is updated by the publisher at 5am.
Replication has been running flawlessly since we upgraded everything nearly
a year ago. This morning the merge agent for Subscriber1 failed with the
following error (XXXX is the server name):
"The process could not connect to Subscriber 'XXXX'.
(Source: XXXX (Agent); Error number: 20084)"
"Cannot generate SSPI context
(Source: XXXX (Data source); Error number: 11004)"
Subscriber2 succeeded. Nothing has changed on the servers, and the logon
credential are the same for each.
I'm at a loss here. Anyone have any idea what might be happening and how to
fix it?
Thanks,
John Steen
There are some patches which seem to be causing this problem. The first
thing I would do is try to connect to the problem machine using SQL
Authentication. This might indicate that someone has changed the server from
mixed authentication to windows. Then try Windows - do you get the SSPI
error there too?
Hilary Cotter
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
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:ABA30CE3-CA41-481E-9195-35482227D318@.microsoft.com...
> Setup:
> - SQL2000 SP3 running on Windows2000 servers.
> I have a merge replication running between three identical servers. Two
of
> the servers, the publisher and subscriber1, receive data from different
> sources and are synced every day at 4am. Subscriber2 is a query server
only
> and is updated by the publisher at 5am.
> Replication has been running flawlessly since we upgraded everything
nearly
> a year ago. This morning the merge agent for Subscriber1 failed with the
> following error (XXXX is the server name):
> "The process could not connect to Subscriber 'XXXX'.
> (Source: XXXX (Agent); Error number: 20084)"
> "Cannot generate SSPI context
> (Source: XXXX (Data source); Error number: 11004)"
> Subscriber2 succeeded. Nothing has changed on the servers, and the logon
> credential are the same for each.
> I'm at a loss here. Anyone have any idea what might be happening and how
to
> fix it?
> Thanks,
> John Steen
>
|||Thanks for getting back to me so quickly, Hilary.
All three servers are using mixed authentication and identical credentials,
and there have been no patches or updates applied. I ran the merge agent for
Subscriber1 this morning manually and it succeeded. I did the same thing for
Subscriber2 but it failed. A second attempt succeeded. So it doesn't seem
to be an authentication issue.
We have a BU Exec SQL agent that does a differential backup at the same time
the merge agents run, so I'm going to to change the time that the agents run
to see if there's a conflict of some sort. If not, then I'll push it off to
our telecom people.
Thanks,
John
John Steen
remove (nospam) from e-mail address to send me a message
"Hilary Cotter" wrote:

> There are some patches which seem to be causing this problem. The first
> thing I would do is try to connect to the problem machine using SQL
> Authentication. This might indicate that someone has changed the server from
> mixed authentication to windows. Then try Windows - do you get the SSPI
> error there too?
> --
> Hilary Cotter
> 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
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:ABA30CE3-CA41-481E-9195-35482227D318@.microsoft.com...
> of
> only
> nearly
> to
>
>

Cannot connect to SQL Server through VPN

I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Win2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Win2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>

Cannot connect to SQL Server through VPN

I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>|||My suggestion would be to make network traces on both the client and the
server. This will tell you if the traffic is ever reaching the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Cannot connect to SQL Server through VPN

I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>

Cannot connect to FTP Site (Merge replication)

Hi;
We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber
are able to retrieve the subscription and replication. The error message on
the failing subscriber is "The computer is disconnected from the network".
The computer runs XP Pro like most of the others and is connected via a VPN
like the others.
The schema script '' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not connect to FTP site 'PL000' using port 21.
(Source: lachlan (Agent); Error number: 0)
The computer is disconnected from the network
(Source: (OS); Error number: 12163)
Any ideas what can cause this? The subscriber that fails was infected with a
virus earlier, but it is now clean the the virus software does not detect
any new or existing virus.
Thomas Born
there are many possibilities
1) the ftp server/site is not active
2) you have specified anonymous only in your ftp server and are trying to
connect using an NT account
3) the ftp server is listening on a different port
4) the snapshot folder does not have read rights for the NT account you are
using or if you are using anonymous authentication to the IUSER_MachineName
account
5) You are using an NT account that does not exist on the machine hosting
the FTP server.
6) your subscriber is on the deny acccess IP address list
Return to your publisher and confirm that all of the above is correctly set
up
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Hi;
> We have mulitple clients (subscribers) with MSDE SP3. All but one
subsriber
> are able to retrieve the subscription and replication. The error message
on
> the failing subscriber is "The computer is disconnected from the network".
> The computer runs XP Pro like most of the others and is connected via a
VPN
> like the others.
>
> The schema script '' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not connect to FTP site 'PL000' using port 21.
> (Source: lachlan (Agent); Error number: 0)
> ----
--
> --
> The computer is disconnected from the network
> (Source: (OS); Error number: 12163)
> ----
--
> --
> Any ideas what can cause this? The subscriber that fails was infected with
a
> virus earlier, but it is now clean the the virus software does not detect
> any new or existing virus.
> Thomas Born
>
|||Thanks for the respone,
I am using anonymous authentication from all the other subscribers as well
and they are working. Also very sure that the server listens on 21. Need to
check 6) but I don't think it is a problem.
I have tested it with having two different machines as the subscriber on my
network at home. One is working and the other one gets the computer
disconnected message. I am getting close to reinstall the operating system
on the failing subscriber, will see if that fixes the problem.
Thomas
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
> there are many possibilities
> 1) the ftp server/site is not active
> 2) you have specified anonymous only in your ftp server and are trying to
> connect using an NT account
> 3) the ftp server is listening on a different port
> 4) the snapshot folder does not have read rights for the NT account you
are
> using or if you are using anonymous authentication to the
IUSER_MachineName
> account
> 5) You are using an NT account that does not exist on the machine hosting
> the FTP server.
> 6) your subscriber is on the deny acccess IP address list
> Return to your publisher and confirm that all of the above is correctly
set[vbcol=seagreen]
> up
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Thomas Born" <tborn_news@.hotmail.com> wrote in message
> news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> subsriber
> on
network".[vbcol=seagreen]
> VPN
> ----
> --
> ----
> --
> ----
> --
with[vbcol=seagreen]
> a
detect
>
|||Re-installing the operating system to fix ftp is radical.
Can you open up IE, and in the address bar connect to the ftp site on the
publisher. What do the ftp logs on the publisher reveal?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:eWZ00$%23ZEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Thanks for the respone,
> I am using anonymous authentication from all the other subscribers as well
> and they are working. Also very sure that the server listens on 21. Need
to
> check 6) but I don't think it is a problem.
> I have tested it with having two different machines as the subscriber on
my[vbcol=seagreen]
> network at home. One is working and the other one gets the computer
> disconnected message. I am getting close to reinstall the operating system
> on the failing subscriber, will see if that fixes the problem.
> Thomas
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
> are
> IUSER_MachineName
hosting[vbcol=seagreen]
> set
message[vbcol=seagreen]
> network".
a[vbcol=seagreen]
number: -2147201001)
> ----
> ----
> ----
> with
> detect
>