merge error rowguidcol

I setup merge, but when it was attempting to connect to the subscriber I
received an error (don't know exact text) about not being able to find
column rowguidcol. I ran:
SELECT name FROM syscolumns
And found lots of entries for rowguidcol, which is odd because I don't
name it that (each rowguid column in my table have unique names specific
to the table).
What command can I type to figure out what tables these rowguidcol's are
in?
Thank
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Darin,
are you doing a nosync initialization? If so, it looks like the schema on
the publisher and subscriber are different. A rowguid column (with the
rowguid attribute) will be added to the replicated articles if it doesn't
already exist, and this should happen automatically.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I am doing a nosync. The rowguid isn't being added (shouldn't be) since
all of my tables have rowguid column, but it is named (some examples),
ccst_rowguid, chst_rowguid, etc. This is what is confusing me.
I would say the schema should be the same because he (the customer) says
he is copying the data from one computer to the other, then I am setting
up replication.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||OK - then adding the rowguid property to the table on the publisher and the
subscriber to the identical table should make it ok.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

Merge Dynamic filter problem

Hi!

I'm a merge newbie and have a couple of questions. I'm about to setup a merge replication with Sql Server 2005 and Sql Server CE as a subscriber. Situation is like this, we have 10 service technicians using pda.

I want to each pda user have their own data. What I understand I need to use dynamic filter and SUSER_NAME()? Do I need to create a "translation" table to map my system's UserId against SUSER_NAME? How have you solved this problem?

/Magnus

Hello magnus,

One easy approach is to have a column in the table for filtering purpose.

Please take a look on sp_addmergearticle (Transact-SQL) , from http://msdn2.microsoft.com/en-us/library/ms174329.aspx.

[ @.subset_filterclause = ] 'subset_filterclause'
Is a WHERE clause specifying the horizontal filtering of a table article without the word WHERE included. subset_filterclause is of nvarchar(1000), with a default of an empty string.

Important:
For performance reasons, we recommended that you not apply functions to column names in parameterized row filter clauses, such as LEFT([MyColumn]) = SUSER_SNAME(). If you use HOST_NAME in a filter clause and override the HOST_NAME value, you might have to convert data types by using CONVERT. For more information about best practices for this case, see the section "Overriding the HOST_NAME() Value" in Parameterized Row Filters.

Parameterized Row Filters - http://msdn2.microsoft.com/en-us/library/ms152478.aspx.

and

[ @.partition_options = ] partition_options
Defines the way in which data in the article is partitioned, which enables performance optimizations when all rows belong in only one partition or in only one subscription. partition_options is tinyint, and can be one of the following values.

Value Description
0 (default)
The filtering for the article either is static or does not yield a unique subset of data for each partition, that is, an "overlapping" partition.
1
The partitions are overlapping, and data manipulation language (DML) updates made at the Subscriber cannot change the partition to which a row belongs.
2
The filtering for the article yields non-overlapping partitions, but multiple Subscribers can receive the same partition.
3
The filtering for the article yields non-overlapping partitions that are unique for each subscription.

Merge always deletes inserts on subscriber

Hey.
Table1 replicates to table3
Table2, just another table with the same schema as Table1 and 3.
In my setup, I created a copy table, copied 66 rows from table1 on publisher
to table2 on subscriber and deleted all 66 rows. The changes were replicated
to the subscriber to Table2(66 deletes made). Now i insert all 66 rows from
Table2 to table3 on the subscriber side. The change should have gone to
publisher. Instead, the inserts get deleted on the subscriber... Why would
SQL do this?
The inserts done later should be taken as new changes on subscriber and
should be replicated to publisher, isn't it?
Forgot to add, it took it as a conflict between pub and sub and for me, by
default, the pub wins... The problem with this is though, it shouldn't be a
conflict. I've ADDED these rows right now and ONLY to the subscriber...
Any clues.

merge agent slowing performance

Hi,
I have setup merge replication with push subcription for every 10 min. I
have changed the agent profile to 'high Volume Server to server' but still
the duration and delivery rate remain almost the same. How can i increase the
delivery rate, or what should be the suggested agent profile be. Please help,
it is urget.
Thanks in Advance,
SVur
The history of the merge agent looks like this for hte last run:
# Actions : 32
Last action message: merged 3252 data changes(3209 inserts, 16 updates, 27
deletes)
Duration(secs): 00.00.43
Delivery rate (rows per sec): 73.0000
Inserts at Publisher:2912
Updates at Publisher:16
Deletes at publisher:27
conflicts at publisher:0
Inserts at subscriber:297
Updates at subscriber:0
Deletes at subscriber:0
conflicts at subscriber:0
Hi,
This is my merge agent history. the agent approximately took 9 min to merge
about 6500 changes in the last run. How can i improve the performance of the
merge agent? What are the implications of increasing the upload and download
batch size?
Thanks,
SVur
118/17/2004 8:20:18 AM8/17/2004 8:20:18 AM0Starting
agent.00000000000<Binary>1
118/17/2004 8:20:31 AM8/17/2004 8:20:31
AM0Initializing00000000000<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:20:31 AM0Connecting to Publisher
'01AL10015000025'00000000000<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:20:36 AM4Connecting to Subscriber
'01AL10015000026'00000000000<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:24 AM52Uploaded 104 data changes
(100 inserts, 0 updates, 4 deletes, 0
conflicts).18734200001000400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:24 AM52Uploaded 100 data changes
(100 inserts, 0 updates, 0 deletes, 0
conflicts).368903.92307692307600002000400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:26 AM55Uploaded 100 data changes
(100 inserts, 0 updates, 0 deletes, 0
conflicts).587185.52727272727200003000400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:29 AM57Uploaded 100 data changes
(100 inserts, 0 updates, 0 deletes, 0
conflicts).806247.08771929824500004000400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:47 AM76Uploaded 100 data changes
(100 inserts, 0 updates, 0 deletes, 0
conflicts).935936.63157894736800005000400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:51 AM80Uploaded 100 data changes
(100 inserts, 0 updates, 0 deletes, 0
conflicts).1079847.5500006000400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:54 AM82Uploaded 123 data changes
(123 inserts, 0 updates, 0 deletes, 0
conflicts).1247818.86585365853600007230400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:21:59 AM87Uploaded 104 data changes
(100 inserts, 4 updates, 0 deletes, 0
conflicts).1408599.55172413793100008234400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:11 AM99Uploaded 69 data changes
(69 inserts, 0 updates, 0 deletes, 0
conflicts).1408599.09090909090900008924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:14 AM102Downloaded 142 data
changes (0 inserts, 0 updates, 142 deletes, 0
conflicts).14151510.2156862745090014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:25 AM114Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14289010.017543859649100014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:26 AM115Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14406210.8200014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:27 AM116Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14520311.568965517241300014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:28 AM117Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14620312.324786324786400014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:42 AM130Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14726511.861538461538500014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:43 AM132Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14817112.439393939393600014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:45 AM133Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).14932713.097744360902700014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:46 AM134Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15012413.746268656716800014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:22:59 AM147Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15099913.210884353741900014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:00 AM149Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15198413.7046979865771000014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:01 AM149Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15295314.3758389261741100014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:01 AM150Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15381314.9466666666661200014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:11 AM160Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15471914.63751300014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:13 AM161Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15553115.1677018633541400014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:14 AM163Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15648515.5950920245391500014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:15 AM164Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15743816.109756097561600014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:26 AM175Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15822015.6685714285711700014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:27 AM175Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15898616.241800014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:28 AM176Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).15981416.7159090909091900014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:30 AM178Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16218917.0898876404492000014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:37 AM185Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16348616.9837837837832100014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:38 AM186Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16450217.4301075268812200014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:38 AM187Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16558017.871657754012300014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:39 AM187Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16650218.4064171122992400014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:52 AM200Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16725217.712500014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:53 AM201Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16809618.1194029850742600014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:54 AM203Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16895618.4334975369452700014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:23:55 AM204Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).16978418.8333333333332800014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:06 AM215Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17064318.334883720932900014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:07 AM215Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17137818.83000014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:08 AM217Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17242519.0875576036863100014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:09 AM217Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17341019.5483870967743200014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:22 AM230Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17445718.8782608695653300014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:23 AM231Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17555019.2294372294373400014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:23 AM232Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17664419.5775862068963500014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:24 AM232Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17762920.0086206896553600014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:32 AM240Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17847319.7583333333333700014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:33 AM241Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).17951920.0912863070533800014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:33 AM242Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).18041020.4214876033053900014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:34 AM242Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).18117620.8347107438014000014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:44 AM252Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).18258220.4047619047614100014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:44 AM252Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).18384820.8015873015874200014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:44 AM253Downloaded 115 data
changes (115 inserts, 0 updates, 0 deletes, 0
conflicts).18511421.1739130434784315014208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:45 AM253Downloaded 151 data
changes (100 inserts, 51 updates, 0 deletes, 0
conflicts).18634921.77075098814244155114208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:45 AM254Downloaded 100 data
changes (0 inserts, 100 updates, 0 deletes, 0
conflicts).18741122.07874015748441515114208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:46 AM255Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).18858222.38431372549451515114208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:46 AM255Downloaded 100 data
changes (99 inserts, 1 updates, 0 deletes, 0
conflicts).18972322.776470588235461415214208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:46 AM255Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).19091023.16862745098471415214208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:46 AM255Downloaded 100 data
changes (100 inserts, 0 updates, 0 deletes, 0
conflicts).19189423.560784313725481415214208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:48 AM256Downloaded 171 data
changes (170 inserts, 1 updates, 0 deletes, 0
conflicts).19278524.13671875498415314208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:48 AM256Downloaded 100 data
changes (98 inserts, 2 updates, 0 deletes, 0
conflicts).19373824.52734375508215514208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:48 AM257Downloaded 100 data
changes (99 inserts, 1 updates, 0 deletes, 0
conflicts).19475424.821011673151518115614208924400<Binary>0
138/17/2004 8:20:31 AM8/17/2004 8:24:49 AM257No data needed to be
merged.19475424.821011673151518115614208924400<Binary>0
128/17/2004 8:20:31 AM8/17/2004 8:24:49 AM257Merged 6379 data changes
(6073 inserts, 160 updates, 146 deletes, 0 resolved
conflicts).024.821011673151518115614208924400<Binary>1
"SVur" wrote:

> Hi,
> I have setup merge replication with push subcription for every 10 min. I
> have changed the agent profile to 'high Volume Server to server' but still
> the duration and delivery rate remain almost the same. How can i increase the
> delivery rate, or what should be the suggested agent profile be. Please help,
> it is urget.
> Thanks in Advance,
> SVur
> The history of the merge agent looks like this for hte last run:
> # Actions : 32
> Last action message: merged 3252 data changes(3209 inserts, 16 updates, 27
> deletes)
> Duration(secs): 00.00.43
> Delivery rate (rows per sec): 73.0000
> Inserts at Publisher:2912
> Updates at Publisher:16
> Deletes at publisher:27
> conflicts at publisher:0
> Inserts at subscriber:297
> Updates at subscriber:0
> Deletes at subscriber:0
> conflicts at subscriber:0
>

merge agent not started - Start Synchronizing disabled

i'm running a SQL Server 2000 SP42000.8.00.2039, developer.
i'm trying to setup a merge replication between the default istance and a named one of the same machine, using the same domain account for both publisher and subscriber.
when it comes to "start synchronizing" (right click on the subscriber merge agent), i found it disabled, just like it is running, but it is not (the icon shows a stop sign, even refreshing.)
The state is "disactivated". When i stop sync and start it again things don't change.
If i setup a "pull" subscription, i get a sequence of a message like "interface not supported" (a translation from italian "Interfaccia non supportata"): after 10 attempts, it stops.
i cannot find this error searching in internet, could you address me?
thanks in advance!How did you set up replication, using scripts or Wizards?|||i used wizards.
i noticed a difference: while in this SQL Server installation the replication won't start at all, it works seamlessly on the SQL Server installed in the domain server.
Maybe it's a matter of DNS.sql

merge agent failure after IP changed

I setup merge replication yesterday on Client A and was successful.
Today I changed the gateway and DNS info.; re-ran merge agent and got this
error.
Error messages:
The merge process could not connect to the Publisher 'XXUSSHU18UT:Process'.
Check to ensure that the server is running. (Source: MSSQL_REPL, Error
number: MSSQL_REPL-2147198719)
Get help: http://help/MSSQL_REPL-2147198719
The process could not connect to Publisher 'XXUSSHU18UT'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL20084)
Get help: http://help/MSSQL_REPL20084
Unable to complete login process due to delay in opening server connection
(Source: MSSQLServer, Error number: 0)
Get help: http://help/0
After I changed the IP info. (put back original Gateway IP) the merge agent
ran successful.
What/where do these changes get applied that would alter merge agent from
running?
BTW, I also removed the gateway completely on Cleint A and the merge agent
continued to run successfully again. However I do need the new gateway (the
one that is not working for merge).
thx..
This seems to be a name resolution problem. Can you reboot, or do a
ipconfig /flushdns
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
"bt7403" <bt7403@.discussions.microsoft.com> wrote in message
news:4586BD18-D056-4E79-96C9-8B4167C9528F@.microsoft.com...
>I setup merge replication yesterday on Client A and was successful.
> Today I changed the gateway and DNS info.; re-ran merge agent and got this
> error.
> Error messages:
> The merge process could not connect to the Publisher
> 'XXUSSHU18UT:Process'.
> Check to ensure that the server is running. (Source: MSSQL_REPL, Error
> number: MSSQL_REPL-2147198719)
> Get help: http://help/MSSQL_REPL-2147198719
> The process could not connect to Publisher 'XXUSSHU18UT'. (Source:
> MSSQL_REPL, Error number: MSSQL_REPL20084)
> Get help: http://help/MSSQL_REPL20084
> Unable to complete login process due to delay in opening server connection
> (Source: MSSQLServer, Error number: 0)
> Get help: http://help/0
> After I changed the IP info. (put back original Gateway IP) the merge
> agent
> ran successful.
> What/where do these changes get applied that would alter merge agent from
> running?
> BTW, I also removed the gateway completely on Cleint A and the merge agent
> continued to run successfully again. However I do need the new gateway
> (the
> one that is not working for merge).
>
> thx..
>

Merge agent failure after IP change

I setup merge replication yesterday on Client A and was successful.
Today I changed the gateway and DNS info.; re-ran merge agent and got this
error.
Error messages:
The merge process could not connect to the Publisher 'XXUSSHU18UT:Process'.
Check to ensure that the server is running. (Source: MSSQL_REPL, Error
number: MSSQL_REPL-2147198719)
Get help: http://help/MSSQL_REPL-2147198719
The process could not connect to Publisher 'XXUSSHU18UT'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL20084)
Get help: http://help/MSSQL_REPL20084
Unable to complete login process due to delay in opening server connection
(Source: MSSQLServer, Error number: 0)
Get help: http://help/0
After I changed the IP info. (put back original Gateway IP) the merge agent
ran successful.
What/where do these changes get applied that would alter merge agent from
running?
BTW, I also removed the gateway completely on Cleint A and the merge agent
continued to run successfully again. However I do need the new gateway (the
one that is not working for merge).
thx..
Are you perhaps using an alias on the subscriber? This would explain the IP
address mapping and its relationship to the replication setup.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Is this push or pull?
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
"bt7403" <bt7403@.discussions.microsoft.com> wrote in message
news:230FE02E-2D00-44EF-9D1D-A6C3A42C6175@.microsoft.com...
>I setup merge replication yesterday on Client A and was successful.
> Today I changed the gateway and DNS info.; re-ran merge agent and got this
> error.
> Error messages:
> The merge process could not connect to the Publisher
> 'XXUSSHU18UT:Process'.
> Check to ensure that the server is running. (Source: MSSQL_REPL, Error
> number: MSSQL_REPL-2147198719)
> Get help: http://help/MSSQL_REPL-2147198719
> The process could not connect to Publisher 'XXUSSHU18UT'. (Source:
> MSSQL_REPL, Error number: MSSQL_REPL20084)
> Get help: http://help/MSSQL_REPL20084
> Unable to complete login process due to delay in opening server connection
> (Source: MSSQLServer, Error number: 0)
> Get help: http://help/0
> After I changed the IP info. (put back original Gateway IP) the merge
> agent
> ran successful.
> What/where do these changes get applied that would alter merge agent from
> running?
> BTW, I also removed the gateway completely on Cleint A and the merge agent
> continued to run successfully again. However I do need the new gateway
> (the
> one that is not working for merge).
>
> thx..
>
|||I am running a PUSH subscription.
Additionally, after troubleshoot, I found the following:
I had a Gateway, primary, secondary DNS IP's setup before I installed SQL
and configured Replication.
After SQL replication configured and working, had to change Gateway and DNS,
then merge agent would not run. I changed Gateway and DNS back to original
and merge worked; I then removed original Gateway IP (only) and merge worked,
which indicates the DNS change was the problem.
I do not have any alias's setup.
How can I maintain IP changes w/o affecting merge agent?
thx..
"Hilary Cotter" wrote:

> Is this push or pull?
> --
> 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
>
> "bt7403" <bt7403@.discussions.microsoft.com> wrote in message
> news:230FE02E-2D00-44EF-9D1D-A6C3A42C6175@.microsoft.com...
>
>

Merge Agent error number 53 for replication

Hi, I am trying to setup replication between 2 SQL Servers across
non-trusted domains(2 different domains). I am able to successfully
registered both SQL servers in either domains. But I still cannot access the
snapshot folder in the Distributor/Publisher domain from the subscriber
domain.
* I've create the same SQL login: SQLAdmin and use this SQL authentication
on both the distributor and subscriber to interact with each other. They can
access each other fine, accept the subscriber cannot access the snapshot
folder on the distributor.
* I've given the Snapshot folder UNC path and Administrative share the
everyone permission.
********
I've read these Microsoft documents already:
Q321822 - Replicate between computers running SQL Server in Non-Trusted
Domains or Across the Internet.
Q240688 - Replication Subscribers Unable to Synchronize with Pull
Subscription.
Objective: I cannot create a pass-through account because the Distributor is
installed upon a Win2k Domain controller (with active directory), but I have
use SQL authentication on both SQL Server, but it still cannot access the
snapshot folder. All I need is for the subscriber to access the snapshot
folder. What do I need to do? Please list the steps, thanks...
****************************************
*****
The schema script
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' could not be propagated to the subscriber.
****************************
The schema script
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' due to OS error 53.
(Source: ECSWEB (Agent); Error number: 0)
----
--
The network path was not found.
(Source: (OS); Error number: 53)
----
--
*************************
The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040306225703\snapshot.pre' could not be propagated to the subscriber.
*************************
The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040306225703\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040306225703\snapshot.pre' due to OS error 53.
(Source: ECSWEB (Agent); Error number: 0)
----
--
The network path was not found.
(Source: (OS); Error number: 53)
----
--notice the unc path is completly wrong.
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403
11181629\
its the dollar sign which I think is messing you up.
can you run run a net use * \\Mercury\REPLDATA on your subscriber and see if
you can map this drive. Then try to navigate upwards to the snapshot.pre
file?
Also if you could run this on your publisher/distributor and report back
here with what you get it will be helpful
select working_directory from msdb.dbo.MSdistpublishers
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:#ONwfV3BEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hi, I am trying to setup replication between 2 SQL Servers across
> non-trusted domains(2 different domains). I am able to successfully
> registered both SQL servers in either domains. But I still cannot access
the
> snapshot folder in the Distributor/Publisher domain from the subscriber
> domain.
> * I've create the same SQL login: SQLAdmin and use this SQL authentication
> on both the distributor and subscriber to interact with each other. They
can
> access each other fine, accept the subscriber cannot access the snapshot
> folder on the distributor.
> * I've given the Snapshot folder UNC path and Administrative share the
> everyone permission.
> ********
> I've read these Microsoft documents already:
> Q321822 - Replicate between computers running SQL Server in Non-Trusted
> Domains or Across the Internet.
> Q240688 - Replication Subscribers Unable to Synchronize with Pull
> Subscription.
> Objective: I cannot create a pass-through account because the Distributor
is
> installed upon a Win2k Domain controller (with active directory), but I
have
> use SQL authentication on both SQL Server, but it still cannot access the
> snapshot folder. All I need is for the subscriber to access the snapshot
> folder. What do I need to do? Please list the steps, thanks...
>
> ****************************************
*****
> The schema script
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' could not be propagated to the subscriber.
> ****************************
> The schema script
>[/color]
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----[/color]
--
> --
> The process could not read file
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' due to OS error 53.
> (Source: ECSWEB (Agent); Error number: 0)
> ----[/color]
--
> --
> The network path was not found.
> (Source: (OS); Error number: 53)
> ----
--
> --
> *************************
> The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> Pub1\20040306225703\snapshot.pre' could not be propagated to the[/color]
subscriber.
> *************************
> The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> Pub1\20040306225703\snapshot.pre' could not be propagated to the[/color]
subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not read file '\\MERCURY\G$\Program Files\Microsoft SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> Pub1\20040306225703\snapshot.pre' due to OS error 53.
> (Source: ECSWEB (Agent); Error number: 0)
> ----[/color]
--
> --
> The network path was not found.
> (Source: (OS); Error number: 53)
> ----
--
> --
>
>|||Hilary,
I just ran the select working_directory on the Distributor and this
is the results:
working_directory
\\Mercury\REPLDATA
\\Mercury\REPLDATA
\\Mercury\REPLDATA
\\MERCURY\G$\Program Files\Microsoft SQL Server\MSSQL$MERCURY\ReplData
Yes I can net use * \\Mercury \REPLDATA and navigate to the snapshot.pre
file.
Regards
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uPeVrH#BEHA.2404@.TK2MSFTNGP11.phx.gbl...
> notice the unc path is completly wrong.
>
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403[col
or=darkred]
> 11181629\
> its the dollar sign which I think is messing you up.
> can you run run a net use * \\Mercury\REPLDATA on your subscriber and see[/color]
if
> you can map this drive. Then try to navigate upwards to the snapshot.pre
> file?
> Also if you could run this on your publisher/distributor and report back
> here with what you get it will be helpful
> select working_directory from msdb.dbo.MSdistpublishers
>
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> news:#ONwfV3BEHA.576@.TK2MSFTNGP11.phx.gbl...
> the
authentication
> can
Distributor
> is
> have
the
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> --
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> --
> ----
> --
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> subscriber.
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> subscriber.
> ----
> --
SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> ----
> --
> ----
> --
>[/color]|||Now I even got error no: 1326
The schema script
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' due to OS error 1326.
(Source: ECSWEB (Agent); Error number: 0)
----
--
Logon failure: unknown user name or bad password.
(Source: (OS); Error number: 1326)
----
--
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:#8btBY#BEHA.3784@.TK2MSFTNGP10.phx.gbl...
> Hilary,
> I just ran the select working_directory on the Distributor and
this
> is the results:
> working_directory
> \\Mercury\REPLDATA
> \\Mercury\REPLDATA
> \\Mercury\REPLDATA
> \\MERCURY\G$\Program Files\Microsoft SQL Server\MSSQL$MERCURY\ReplData
>
> Yes I can net use * \\Mercury \REPLDATA and navigate to the snapshot.pre
> file.
> Regards
>
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:uPeVrH#BEHA.2404@.TK2MSFTNGP11.phx.gbl...
>
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403[col
or=darkred]
see
> if
access
subscriber
> authentication
They
snapshot
Non-Trusted
> Distributor
I
> the
snapshot
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
number: -2147201001)
> ----
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> ----
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
number: -2147201001)
> ----
> SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> ----
> ----
>[/color]|||I take it you have moved to using SQL Server Standard security in your
enabled subscriber.
Is this account in the PAL for the publication. Right click on your
publication in the publication database, select publication properties, and
go to Publication Access List. The account you are using must be in the
server administrator role on the subscriber, and in the dbo role on the
publication database. It also must be present in the PAL.
Also verify that the password you are using is correct. To do this, go to
Tools-Replication-Configure Publishers, Distributors, Subscribers, click on
the Subscribers tab, and locate your Subscriber. Then click on the browse
button to the right of your Subscribers, and then in the Use SQL Server
Authentication enter the correct information.
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:OeNZV$$BEHA.1588@.tk2msftngp13.phx.gbl...
> Now I even got error no: 1326
>
> The schema script
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----[/color]
--
> --
> The process could not read file
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' due to OS error 1326.
> (Source: ECSWEB (Agent); Error number: 0)
> ----[/color]
--
> --
> Logon failure: unknown user name or bad password.
> (Source: (OS); Error number: 1326)
> ----
--
> --
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> news:#8btBY#BEHA.3784@.TK2MSFTNGP10.phx.gbl...
> this
snapshot.pre
>
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403[col
or=darkred]
> see
snapshot.pre
back
> access
> subscriber
> They
> snapshot
the
> Non-Trusted
but
> I
access
> snapshot
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> number: -2147201001)
> ----
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> ----
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> number: -2147201001)
> ----
Files\Microsoft
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> ----
> ----
>[/color]

Merge Agent error number 53 for replication

Hi, I am trying to setup replication between 2 SQL Servers across
non-trusted domains(2 different domains). I am able to successfully
registered both SQL servers in either domains. But I still cannot access the
snapshot folder in the Distributor/Publisher domain from the subscriber
domain.
* I've create the same SQL login: SQLAdmin and use this SQL authentication
on both the distributor and subscriber to interact with each other. They can
access each other fine, accept the subscriber cannot access the snapshot
folder on the distributor.
* I've given the Snapshot folder UNC path and Administrative share the
everyone permission.
********
I've read these Microsoft documents already:
Q321822 - Replicate between computers running SQL Server in Non-Trusted
Domains or Across the Internet.
Q240688 - Replication Subscribers Unable to Synchronize with Pull
Subscription.
Objective: I cannot create a pass-through account because the Distributor is
installed upon a Win2k Domain controller (with active directory), but I have
use SQL authentication on both SQL Server, but it still cannot access the
snapshot folder. All I need is for the subscriber to access the snapshot
folder. What do I need to do? Please list the steps, thanks...
****************************************
*****
The schema script
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' could not be propagated to the subscriber.
****************************
The schema script
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' due to OS error 53.
(Source: ECSWEB (Agent); Error number: 0)
----
--
The network path was not found.
(Source: (OS); Error number: 53)
----
--
*************************
The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040306225703\snapshot.pre' could not be propagated to the subscriber.
*************************
The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040306225703\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040306225703\snapshot.pre' due to OS error 53.
(Source: ECSWEB (Agent); Error number: 0)
----
--
The network path was not found.
(Source: (OS); Error number: 53)
----
--OS Error 53 == Network Name not found.
Check for Name resolution problems with either WINS or DNS.
Verify you can get to the server from the client using the "net view
\\servername" command.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||notice the unc path is completly wrong.
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403
11181629\
its the dollar sign which I think is messing you up.
can you run run a net use * \\Mercury\REPLDATA on your subscriber and see if
you can map this drive. Then try to navigate upwards to the snapshot.pre
file?
Also if you could run this on your publisher/distributor and report back
here with what you get it will be helpful
select working_directory from msdb.dbo.MSdistpublishers
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:#ONwfV3BEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hi, I am trying to setup replication between 2 SQL Servers across
> non-trusted domains(2 different domains). I am able to successfully
> registered both SQL servers in either domains. But I still cannot access
the
> snapshot folder in the Distributor/Publisher domain from the subscriber
> domain.
> * I've create the same SQL login: SQLAdmin and use this SQL authentication
> on both the distributor and subscriber to interact with each other. They
can
> access each other fine, accept the subscriber cannot access the snapshot
> folder on the distributor.
> * I've given the Snapshot folder UNC path and Administrative share the
> everyone permission.
> ********
> I've read these Microsoft documents already:
> Q321822 - Replicate between computers running SQL Server in Non-Trusted
> Domains or Across the Internet.
> Q240688 - Replication Subscribers Unable to Synchronize with Pull
> Subscription.
> Objective: I cannot create a pass-through account because the Distributor
is
> installed upon a Win2k Domain controller (with active directory), but I
have
> use SQL authentication on both SQL Server, but it still cannot access the
> snapshot folder. All I need is for the subscriber to access the snapshot
> folder. What do I need to do? Please list the steps, thanks...
>
> ****************************************
*****
> The schema script
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' could not be propagated to the subscriber.
> ****************************
> The schema script
>[/color]
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----[/color]
--
> --
> The process could not read file
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' due to OS error 53.
> (Source: ECSWEB (Agent); Error number: 0)
> ----[/color]
--
> --
> The network path was not found.
> (Source: (OS); Error number: 53)
> ----
--
> --
> *************************
> The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> Pub1\20040306225703\snapshot.pre' could not be propagated to the[/color]
subscriber.
> *************************
> The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> Pub1\20040306225703\snapshot.pre' could not be propagated to the[/color]
subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not read file '\\MERCURY\G$\Program Files\Microsoft SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> Pub1\20040306225703\snapshot.pre' due to OS error 53.
> (Source: ECSWEB (Agent); Error number: 0)
> ----[/color]
--
> --
> The network path was not found.
> (Source: (OS); Error number: 53)
> ----
--
> --
>
>|||Hilary,
I just ran the select working_directory on the Distributor and this
is the results:
working_directory
\\Mercury\REPLDATA
\\Mercury\REPLDATA
\\Mercury\REPLDATA
\\MERCURY\G$\Program Files\Microsoft SQL Server\MSSQL$MERCURY\ReplData
Yes I can net use * \\Mercury \REPLDATA and navigate to the snapshot.pre
file.
Regards
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uPeVrH#BEHA.2404@.TK2MSFTNGP11.phx.gbl...
> notice the unc path is completly wrong.
>
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403[col
or=darkred]
> 11181629\
> its the dollar sign which I think is messing you up.
> can you run run a net use * \\Mercury\REPLDATA on your subscriber and see[/color]
if
> you can map this drive. Then try to navigate upwards to the snapshot.pre
> file?
> Also if you could run this on your publisher/distributor and report back
> here with what you get it will be helpful
> select working_directory from msdb.dbo.MSdistpublishers
>
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> news:#ONwfV3BEHA.576@.TK2MSFTNGP11.phx.gbl...
> the
authentication
> can
Distributor
> is
> have
the
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> --
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> --
> ----
> --
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> subscriber.
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> subscriber.
> ----
> --
SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> ----
> --
> ----
> --
>[/color]|||Now I even got error no: 1326
The schema script
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040
311181629\snapshot.pre' due to OS error 1326.
(Source: ECSWEB (Agent); Error number: 0)
----
--
Logon failure: unknown user name or bad password.
(Source: (OS); Error number: 1326)
----
--
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:#8btBY#BEHA.3784@.TK2MSFTNGP10.phx.gbl...
> Hilary,
> I just ran the select working_directory on the Distributor and
this
> is the results:
> working_directory
> \\Mercury\REPLDATA
> \\Mercury\REPLDATA
> \\Mercury\REPLDATA
> \\MERCURY\G$\Program Files\Microsoft SQL Server\MSSQL$MERCURY\ReplData
>
> Yes I can net use * \\Mercury \REPLDATA and navigate to the snapshot.pre
> file.
> Regards
>
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:uPeVrH#BEHA.2404@.TK2MSFTNGP11.phx.gbl...
>
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403[col
or=darkred]
see
> if
access
subscriber
> authentication
They
snapshot
Non-Trusted
> Distributor
I
> the
snapshot
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
number: -2147201001)
> ----
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> ----
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
number: -2147201001)
> ----
> SQL
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> ----
> ----
>[/color]|||I take it you have moved to using SQL Server Standard security in your
enabled subscriber.
Is this account in the PAL for the publication. Right click on your
publication in the publication database, select publication properties, and
go to Publication Access List. The account you are using must be in the
server administrator role on the subscriber, and in the dbo role on the
publication database. It also must be present in the PAL.
Also verify that the password you are using is correct. To do this, go to
Tools-Replication-Configure Publishers, Distributors, Subscribers, click on
the Subscribers tab, and locate your Subscriber. Then click on the browse
button to the right of your Subscribers, and then in the Use SQL Server
Authentication enter the correct information.
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:OeNZV$$BEHA.1588@.tk2msftngp13.phx.gbl...
> Now I even got error no: 1326
>
> The schema script
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----[/color]
--
> --
> The process could not read file
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> 311181629\snapshot.pre' due to OS error 1326.
> (Source: ECSWEB (Agent); Error number: 0)
> ----[/color]
--
> --
> Logon failure: unknown user name or bad password.
> (Source: (OS); Error number: 1326)
> ----
--
> --
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> news:#8btBY#BEHA.3784@.TK2MSFTNGP10.phx.gbl...
> this
snapshot.pre
>
\\Mercury\REPLDATA\unc\MERCURY$MERCURY_N
orthwind_NorthwindMercuryPub1\200403[col
or=darkred]
> see
snapshot.pre
back
> access
> subscriber
> They
> snapshot
the
> Non-Trusted
but
> I
access
> snapshot
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> number: -2147201001)
> ----
>
'\\Mercury\REPLDATA\unc\MERCURY$MERCURY_
Northwind_NorthwindMercuryPub1\20040[col
or=darkred]
> ----
> ----
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
>[/color]
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> number: -2147201001)
> ----
Files\Microsoft
>
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury[col
or=darkred]
> ----
> ----
>[/color]|||All I need is for the subscriber to access the snapshot
folder. What do I need to do? Please list the steps, thanks...
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...sql

memory usage and configuration...

Hi,
I've a server to setup.
This server is not only dedicated to SQL Server, but SQL Server is the main
application on the machine. (Datawarehouse system)
I just want to know how to configure my windows swap file?
I know that SQL Server is optimized to not use the Windows Swap file.
I've 6 disks available:
4 * 64 Gb for my SQL Server databases (Raid 5)
On the 2 other disks I've to install Win 2003 + applications + swap file.
How to optimize this?
Where to setup the tempdb database?
Actually I plan to get 10Gb in 1 disk for the OS + application
and setup a stripped volume with the 2 disks for the swap file and the
tempdb file (2*40gb).
Do you think its a good config?
thanks for your feedback.
Jerome.How much memory is in your system in total, and what is
your drive configuration beyond the 6 disk RAID 5 set for
SQL Server? That may not be enough spindles, but I can't
say for sure. If you stick all of your SQL Server files
(system DBs, data/index, logs, tempdb) all on the same
stripe set, you are not buying yourself anything.
So if your goal as I saw is to put everything on the one
R5 stripe, I'd say wholeheartedly no, it is not an optimal
setup at all based on my experience.
However, you need to have done some system profiling to
tell you definitively.|||I've 4gb of RAM
I want to control the usage of my hard drive to keep a good performance.
it's why I want to separate the tempdb database in 1 disk or 2 stripped
disks.
And I'll keep 4 disks in raid 5 for my data. for security reasons.
Maybe I can put my indexes on a separate disk.
Config 1:
Disk0: OS + Applications (10Gb only)
Disk0,1: Stripped - 22Gb + 32 Gb - tempdb - user db indexes - Swap file
Disk3,4,5,6: Raid 5 for system DB and user DB
Config 2:
Disk0: OS + Swap + Applications (10Gb only)
Disk0: tempdb (22gb)
Disk1: indexes (32gb)
Disk3,4,5,6: Raid 5 for system DB and user DB
each disk is a 32gb disk
what do you think about this?
which config is better?
or what is your recommendation?
Also, what is the swap file size required?
"Allan Hirt" <anonymous@.discussions.microsoft.com> a écrit dans le message
de news:5ab501c474a8$a67500b0$a601280a@.phx.gbl...
> How much memory is in your system in total, and what is
> your drive configuration beyond the 6 disk RAID 5 set for
> SQL Server? That may not be enough spindles, but I can't
> say for sure. If you stick all of your SQL Server files
> (system DBs, data/index, logs, tempdb) all on the same
> stripe set, you are not buying yourself anything.
> So if your goal as I saw is to put everything on the one
> R5 stripe, I'd say wholeheartedly no, it is not an optimal
> setup at all based on my experience.
> However, you need to have done some system profiling to
> tell you definitively.

Memory settings/considerations when running multiple instances of SQL Server

I've got a server, Dual PIII 733's with 2gb of RAM that I setup with 3 named
instances of SQL Server. I'm not sure what I should do with the memory
settings, specifically the min and max and whether that has any bearing or
not.
I noticed when pulling up task manager that the memory for 1 instance will
grow to be 800mb or so while the other 2 will hover around 46-60 mb. I
tried setting them each to use exactly 500mb but that didn't appear to have
any impact. I know that the memory will grow as the databases get used but
the other 2 instances still stayed low even when I was restoring a 40gb
database. I also noticed that stopping the services from the first instance
would kill the sqlserver.exe process that had the high allocation of memory,
but the others still stayed in the 46-60 mb range.
How can I manage the memory used by each instance of SQL Server or what
should I set so that I don't have to worry about it? Any help with this is
greatly appreciated.
Thx,
KenThis is a multi-part message in MIME format.
--000107050009040201040201
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
My advice would be just to leave it how it is. By default, SQL 2000 out
of the box uses a dynamic memory management strategy (as it seems you
already know). With only 2G of physical RAM in the box you don't need
to play with /3GB switches or AWE memory or anything fancy like that.
SQL Server will cache data into its address space as it is accessed
(restoring a DB is not the same as accessing data in that DB, which is
done via standard T-SQL statements like SELECT, INSERT, UPDATE &
DELETE). It will try to maintain a minimum free physical RAM threshold
(by default 10MB but configurable) so when another app (like one of your
other sqlservr.exe instances for example) make a request for memory and
there is less than that threshold available, it will release some of its
memory allocation in order for the OS to satisfy the new memory request
of the other app AND maintain that free memory threshold.
If the SQL instances using less RAM need the memory then they will ask
for it and get it at the other instance's expense. Basically, the most
needy SQL instances will have the most memory (as it should be).
If you really want to set hard limits for your SQL instances you can set
high & low limits for the dynamic memory management to work with via
sp_configure ("max server memory" and "min server memory") or you can
set a fixed amount of memory for SQL Server to work with (so that it
does *not* swap pages out of RAM) via sp_configure ("set working set size").
But I'd just leave it exactly how it is if I were you.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Ken Patton wrote:
>I've got a server, Dual PIII 733's with 2gb of RAM that I setup with 3 named
>instances of SQL Server. I'm not sure what I should do with the memory
>settings, specifically the min and max and whether that has any bearing or
>not.
>I noticed when pulling up task manager that the memory for 1 instance will
>grow to be 800mb or so while the other 2 will hover around 46-60 mb. I
>tried setting them each to use exactly 500mb but that didn't appear to have
>any impact. I know that the memory will grow as the databases get used but
>the other 2 instances still stayed low even when I was restoring a 40gb
>database. I also noticed that stopping the services from the first instance
>would kill the sqlserver.exe process that had the high allocation of memory,
>but the others still stayed in the 46-60 mb range.
>How can I manage the memory used by each instance of SQL Server or what
>should I set so that I don't have to worry about it? Any help with this is
>greatly appreciated.
>Thx,
>Ken
>
>
--000107050009040201040201
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>My advice would be just to leave it how it is. By default, SQL
2000 out of the box uses a dynamic memory management strategy (as it
seems you already know). With only 2G of physical RAM in the box you
don't need to play with /3GB switches or AWE memory or anything fancy
like that.<br>
<br>
SQL Server will cache data into its address space as it is accessed
(restoring a DB is not the same as accessing data in that DB, which is
done via standard T-SQL statements like SELECT, INSERT, UPDATE &
DELETE). It will try to maintain a minimum free physical RAM threshold
(by default 10MB but configurable) so when another app (like one of
your other sqlservr.exe instances for example) make a request for
memory and there is less than that threshold available, it will release
some of its memory allocation in order for the OS to satisfy the new
memory request of the other app AND maintain that free memory threshold.<br>
<br>
If the SQL instances using less RAM need the memory then they will ask
for it and get it at the other instance's expense. Basically, the most
needy SQL instances will have the most memory (as it should be).<br>
<br>
If you really want to set hard limits for your SQL instances you can
set high & low limits for the dynamic memory management to work
with via sp_configure ("max server memory" and "min server memory") or
you can set a fixed amount of memory for SQL Server to work with (so
that it does <b>not</b> swap pages out of RAM) via sp_configure ("set
working set size").<br>
<br>
But I'd just leave it exactly how it is if I were you.<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Ken Patton wrote:
<blockquote cite="midd6j517$7rh$1@.news01.intel.com" type="cite">
<pre wrap="">I've got a server, Dual PIII 733's with 2gb of RAM that I setup with 3 named
instances of SQL Server. I'm not sure what I should do with the memory
settings, specifically the min and max and whether that has any bearing or
not.
I noticed when pulling up task manager that the memory for 1 instance will
grow to be 800mb or so while the other 2 will hover around 46-60 mb. I
tried setting them each to use exactly 500mb but that didn't appear to have
any impact. I know that the memory will grow as the databases get used but
the other 2 instances still stayed low even when I was restoring a 40gb
database. I also noticed that stopping the services from the first instance
would kill the sqlserver.exe process that had the high allocation of memory,
but the others still stayed in the 46-60 mb range.
How can I manage the memory used by each instance of SQL Server or what
should I set so that I don't have to worry about it? Any help with this is
greatly appreciated.
Thx,
Ken
</pre>
</blockquote>
</body>
</html>
--000107050009040201040201--