merge replication problem

I am working on merge replication.I am using sql server 2005 standard edition.Will things workout for me if i use this standard edition(just to know).

2. i have been working on merge replication on the same server but different databases.the way i do it is as follows

a.I create a database.

b.Create a publication(is has successfully been created)

c.Create a subscription(successfully created it)

d.Now when i look at the replication monitor when i click on my merge replication

under all subscription tab

status shows:uninitialized subscription and

Connection :it shows unknown

when i double click that it takes me to synchrinization history which has nothing going on with in it.

What would be the reason for the problem.

Please

Can you try the replication monitor and the sync history after you add some articles to the publication then run the snapshot agent on the publisher, and then run the merge agent to initialize the subscriber.|||

Thanks for your attention

after adding some articles.when i run the snapshot agent from

Local publications->my publication->view snap shot agent status->click start

it tries to start but then comes with a message saying "The agent has never been run."

and under local subscritpions->my subscription->view synchronization->

when i click start it says "No agent status information is available".

when i look at view history tab

The job failed. Unable to determine if the owner (xyz\myname) of job 1234511-testdb_merge-merge-27G6Y91-merge_sub- 0 has server access (reason: Could not obtain information about Windows NT group/user 'xyz\myname', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

What would be the casue if security permission.How should i set them.

please let me know.

sql

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test

Module

Status

ErrorCode

Version

SQLCERP30.DLL

SUCCESS

0x0

3.0.5300.0

SQLCESA30.DLL

SUCCESS

0x0

3.0.5300.0

Reconciler Test

Reconciler

Status

ErrorCode

9.0 Database Reconciler

SUCCESS

0x0

8.0 Database Reconciler

FAILURE

0x80004005

SQL Server Module Versions

Module

Version

sqloledb.dll

2000.85.1117.0

9.0 replrec.dll

2005.90.3033.0

9.0 replprov.dll

2005.90.3033.0

9.0 msgprox.dll

2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication Issues between SQL Server 2005 (x64) and SQL Server Compact Edition

Hi ppl,

I have installed SQL Server 2005 x64 Enterprise edition with Service Pack 2 on a Windows Server 2003 x64 Standard Edition with Service Pack 2.

Now I have to configure Merge Replication that will work with SQL Server Compact Edition database on Windows Mobile devices.

Distributor and the Publisher are the same server.

IIS 6.0 is installed on the windows server. I have installed the SQL Server Compact Edition Server tools on the server. However the compact edition server tools are only available for 32bit servers and I have also found out from the article http://support.microsoft.com/default.aspx/kb/912430 that you cannot replicate data from SQL Server 2005 to SQL Server Compact Edition by using the 64-bit version of IIS.
So if this is true does that mean I can not use merge replication on 64 bit server? Does that mean I have to get another 32 bit server with 32 bit IIS on it to make this work or is there another work around. Am i missing something here?

Regards
NabeelI think this might solves the issue http://www.pluralsight.com/blogs/jimw/archive/2007/07/06/47932.aspx

Merge Replication database can not truncate log

In my SQL Server 2000 Standard Edition.
I am trying to truncate the log for the database but i am getting the below
message.
The log was not truncated because records at the beginning of the log are
pending replication. Ensure the Log Reader Agent is running or use
sp_repldone to mark transactions as distributed.
Ponnu
This message relates to transactional replication rather than merge. Please
run your log-reader agent which will mark the log as read then it can be
truncated.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
Nice to hear from you.
Sorry I have 1 snapshot replication and 6 merge replication on publication
on the database. I do not have any transaction replication.
Please let me know
regards
Ponnu
"Paul Ibison" wrote:

> This message relates to transactional replication rather than merge. Please
> run your log-reader agent which will mark the log as read then it can be
> truncated.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Presumably you once had a tranasactional replication setup and have removed
it without the log reader havong completed. In this case running sp_repldone
should suffice.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I never created Transactional replication on the this server.
It is looks lie very strange problem.
But Running the sp_repldone will cause any problem i mean need to
republished ?
EXEC sp_repldone @.xactid = NULL, @.xact_segno = NULL, @.numtrans = 0, @.time
= 0, @.reset = 1
Caution This procedure can be used in emergency situations to allow
truncation of the transaction log when transactions pending replication are
present. Using this procedure prevents Microsoft? SQL Server? 2000 from
replicating the database until the database is unpublished and republished.
Thanks
Ponnu
"Paul Ibison" wrote:

> Presumably you once had a tranasactional replication setup and have removed
> it without the log reader havong completed. In this case running sp_repldone
> should suffice.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||Ponnu,
AFAIK this warning message relates exclusively to transactional replication.
If you are at all concerned, then you could open up a support case.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul,
I have open the ticket with MS. i have checked with DBCC OpenTran, It looks
like some old transaction is there.
dbcc opentran
Transaction information for database 'ShipSure'.
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (178321:74147:1)
Regards
Ponnu
"Paul Ibison" wrote:

> Ponnu,
> AFAIK this warning message relates exclusively to transactional replication.
> If you are at all concerned, then you could open up a support case.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>

Merge Replication between SQL Mobile and SQL 2005 without IIS

Hi,
I am trying to do Merge Replication between SQL 2005 and
SQL Mobile Edition. I did set up Publication and
Distribution successfully using SQL Server Management
Studio but when I tried to create a subscription from SQL
Mobile Database then it asks for Web Server Authentication
where I needed to put URL for SQL Server Mobile Edition
Virtual Directory..
Is it possbile to subscribe from SQL Mobile Edition with
going thru Web Server Authentication?
Niben
I mean - Is it possbile to subscribe from SQL Mobile Edition without**
going thru Web Server Authentication?
"Niben" wrote:

> Hi,
> I am trying to do Merge Replication between SQL 2005 and
> SQL Mobile Edition. I did set up Publication and
> Distribution successfully using SQL Server Management
> Studio but when I tried to create a subscription from SQL
> Mobile Database then it asks for Web Server Authentication
> where I needed to put URL for SQL Server Mobile Edition
> Virtual Directory..
> Is it possbile to subscribe from SQL Mobile Edition with
> going thru Web Server Authentication?
> Niben