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 in Enterprise 2005 to Express 2005

I implemented a merge replication publication on a SQL Server 2005
Enterprise instance on a test server. On my laptop I have VS.NET 2005
installed with SQL Server 2005 Express.
It's my understanding that I can subscribe to a publication with
Express. I also have SQL Server Workgroup installed on my laptop so I'm
able to use Management Studio to control the Express instance.
The first issue I encountered was that you cannot subscribe to a
publication if you are not on the same network as the publishing
instance (it requires the actual server name). And in lieu of this I
tried to implement Web synchronization, but had problems with SSL
(which is my problem since I'm not entirely familiar with how to
implement SSL certs so they don't show the security warning on the
client without purchasing a certificate).
So then I decided to go ahead and create an account on my laptop and
add it to the domain of the test publishing server. I was then able to
subscribe to the published replication.
So then I look at my Express instance and the synchronization never
runs. In the documentation it says that you're supposed to be able to
right-click on the subscription and "View Synchronization" and force it
to run. This is not available in the Express instance, but it is
available in the Workgroup instance.
So I'm looking at cleaning up my web synchronization issues to make
that work, but I see two issues here.
1) Why do I have to specify the "real name" of the publishing database?
Why can't I access it like any other sql server via an IP address? This
seems like a highly restrictive implementation of replication to me.
2) Why do I have to implement SSL for replication? I understand the
need for security, but that should be left to me to implement. I
shouldn't be forced to use SSL as my security layer.
3) Why doesn't Express have "View Synchronization"?
Any help here is greatly appreciated.
David CornelsonRetry #1
Anyone?

Merge replication error -2147201019

I'm setting up a merge replication. Sql server 2000 Desktop engine is installed at subscriber site. Sql server 2000 enterprise is installed at the publisher site.

I setup the publisher fine. No errors.

I setup a subscriber to the publisher, and get this error:

"the subscription to publication 'xxxx' is invalid"

The error details are:

Last command: {call sp_MSgetreplicainfo(?,?,?,?,?,?)}
Category: Agent
Source: Merge Replication Provider
Number: -2147201019

This error shows up only after all tables have been copied to the subscriber. The last valid function before the error is:

Applied script 'CustBank_5.trg'

The above has nothing to do with the error. The scripts all apply, for every table selected. I've tested with publication of all tables, down to just a single table. The error always shows up after the last script is applied.

I've set this same thing up on computers in my office, and it works fine. Just can't get it working for the customer.

Any ideas?

Thanks!I'm also getting the following message listed as the "Full" error text:

"The remote server is not defined as a subscription server"

Doing my Google searches now:)|||I found the solution. Thanks GOOGLE and Brian!

http://www.cryer.co.uk/brian/sqlserver/sqlsvrtroubleshooting.htm

The above troubleshooting site, eventually pointed me to the following link, that resolved the problem.

http://www.cryer.co.uk/brian/sqlserver/ssem_cncd.htm

Gracias.

Merge Replication Agents

Hi everybody,
I have a system of 2 PC, with installed Win XP and SQL 2000. I
configured one PC as Publisher and Distrbutor, and the other as a
Subscriber with a "push" subscription. The snapshot and the merge
agents are running on the Publisher/Distributor. This PC is always ON
for 24 hours everyday, while the subscriber PC at the evening is
turned off and restarted at the morning.
Looking the Replication monitor at the morning, I see red cross on
both agents (snapshot and merge) and the synchronization doesnt' seem
working; if I restart the agents a message tells that the agent is
already running and the red flags disappear.
Anyone can help me to undertand better the situation, or give me some
suggestion?
Thanks a lot.
Marco
What error messages exist for the agents when there is a red cross - can you
please post it up. I'd expect that the merge agent would be killed if it is
synchronising during the process of rebooting the subscriber, but if there is
a schedule or it is set to run continously then it should restart ok. The
snapshot agent shouldn't be running at all after initialization. So, perhaps
the initialization never worked, and the merge agent failed because the
snapshot agent hadn't run? Anyway, please post up some more info and things
whould get clearer.
Paul Ibison
|||On 19 Giu, 17:57, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> What error messages exist for the agents when there is a red cross - can you
> please post it up. I'd expect that the merge agent would be killed if it is
> synchronising during the process of rebooting the subscriber, but if there is
> a schedule or it is set to run continously then it should restart ok. The
> snapshot agent shouldn't be running at all after initialization. So, perhaps
> the initialization never worked, and the merge agent failed because the
> snapshot agent hadn't run? Anyway, please post up some more info and things
> whould get clearer.
> Paul Ibison
Hi Paul,
I don't know exactly what kind of error there is, because I dont' have
the PC with me; this problem has been explained me by another
technician that is testing the system. But I know that the merge agent
is setted to run continously, and that the synchronization was working
when I setted the replication process; only I tested it with the 2 PC
both running and I didn't test the condition with 1 PC running and the
other PC turned off.
|||OK - there's not much I can do without the error message. Try to get it off
your colleague and post it up and I'll take a look.
Cheers,
Paul Ibison

merge Replication across Internet

I'm want to setup merge replication ( sql 2000 ) where one sql server would
be installed with a hosting provider & other would be in our office. I'm
able to setup a test setup in my office between 2 servers which are in same
NT domain.
I have queries about how to setting up merge replication over internet. I
request all sql replication expertes to please answer my query.
1. While setting up merge replication is it a must to have point to point
connect i.e do we need to have a leased line connectivity between hosting
provider where we would be hosting sql server & our office ?
2. The server hosted in hosting provider should be made to log in to our NT
office domain or can i keep this server in standalone mode & achieve merge
replication ?
2.My office has internet connectivity via some isp. If leased line
connectivity to hosting provider is not possible then how can i setup merge
replication on internet ? At my server hosted in hosting provider do i need
to setup vpn ( l2tp ) connectivity to my server in office ? Please note that
in my test setup in office both servers were in same NT domain & connected in
a LAN.Idea of vpn connectivity is to extend my office network over internet
to the server hosted in hosting provider. is my direction of thinking right ?
Please share your experiences if some one in this forumn has implmented a
similar setup.
tanks.....
1) You need some form of connectivity - whether it is across the internet or
through a dedicated lease line doesn't matter. You might want to use a VPN
for security requirements.
2) You don't need to create a trust relationship between your domain and the
hosting company server/domain. You would use SQL authentication and FTP for
this. Consult this kb for more information.
http://support.microsoft.com/default...b;en-us;321822
2) As long as you can connect to both servers using Enterprise Manager you
will be ok. Note that you will probably want to register both servers using
the NetBIOS names (what is returned via select @.@.servername and which should
match xp_cmdshell 'hostname'). Use Client Network Utility to build an alias
which will match the Fully Qualified DomainName of the SQL Server i.e.
(SQLServer1.ResourceDomain.Microsoft.com).
Using a VPN is not essential. Microsoft does recommend it for security
reasons. If you are concerned about security (i.e. are a bank or have
sensitive data) use a VPN, if you are not concerned you don't have to use a
VPN. Using a VPN slows down communication, because of this many companies
choose not to use it.
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
"PELEAANIL" <PELEAANIL@.discussions.microsoft.com> wrote in message
news:470A0759-D7D8-4275-BDB1-58F4B4BCC3B2@.microsoft.com...
> I'm want to setup merge replication ( sql 2000 ) where one sql server
would
> be installed with a hosting provider & other would be in our office. I'm
> able to setup a test setup in my office between 2 servers which are in
same
> NT domain.
> I have queries about how to setting up merge replication over internet. I
> request all sql replication expertes to please answer my query.
> 1. While setting up merge replication is it a must to have point to point
> connect i.e do we need to have a leased line connectivity between hosting

> provider where we would be hosting sql server & our office ?
> 2. The server hosted in hosting provider should be made to log in to our
NT
> office domain or can i keep this server in standalone mode & achieve
merge
> replication ?
> 2.My office has internet connectivity via some isp. If leased line
> connectivity to hosting provider is not possible then how can i setup
merge
> replication on internet ? At my server hosted in hosting provider do i
need
> to setup vpn ( l2tp ) connectivity to my server in office ? Please note
that
> in my test setup in office both servers were in same NT domain & connected
in
> a LAN.Idea of vpn connectivity is to extend my office network over
internet
> to the server hosted in hosting provider. is my direction of thinking
right ?
> Please share your experiences if some one in this forumn has implmented a
> similar setup.
> tanks.....
>
|||Many thanks for reply.I suppose my office network has firewall & suppose
hosting provider also has firewall, then for merge replication which ports
would be involved?Based on your inputs will talk to my network team in office
regarding the same.
"Hilary Cotter" wrote:

> 1) You need some form of connectivity - whether it is across the internet or
> through a dedicated lease line doesn't matter. You might want to use a VPN
> for security requirements.
> 2) You don't need to create a trust relationship between your domain and the
> hosting company server/domain. You would use SQL authentication and FTP for
> this. Consult this kb for more information.
> http://support.microsoft.com/default...b;en-us;321822
> 2) As long as you can connect to both servers using Enterprise Manager you
> will be ok. Note that you will probably want to register both servers using
> the NetBIOS names (what is returned via select @.@.servername and which should
> match xp_cmdshell 'hostname'). Use Client Network Utility to build an alias
> which will match the Fully Qualified DomainName of the SQL Server i.e.
> (SQLServer1.ResourceDomain.Microsoft.com).
> Using a VPN is not essential. Microsoft does recommend it for security
> reasons. If you are concerned about security (i.e. are a bank or have
> sensitive data) use a VPN, if you are not concerned you don't have to use a
> VPN. Using a VPN slows down communication, because of this many companies
> choose not to use it.
> --
> 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
> "PELEAANIL" <PELEAANIL@.discussions.microsoft.com> wrote in message
> news:470A0759-D7D8-4275-BDB1-58F4B4BCC3B2@.microsoft.com...
> would
> same
> NT
> merge
> merge
> need
> that
> in
> internet
> right ?
>
>
|||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
"PELEAANIL" <PELEAANIL@.discussions.microsoft.com> wrote in message
news:1A422957-611D-45FC-8D3E-A734340ECC27@.microsoft.com...
> Many thanks for reply.I suppose my office network has firewall & suppose
> hosting provider also has firewall, then for merge replication which ports
> would be involved?Based on your inputs will talk to my network team in
office[vbcol=seagreen]
> regarding the same.
> "Hilary Cotter" wrote:
internet or[vbcol=seagreen]
VPN[vbcol=seagreen]
the[vbcol=seagreen]
for[vbcol=seagreen]
you[vbcol=seagreen]
using[vbcol=seagreen]
should[vbcol=seagreen]
alias[vbcol=seagreen]
use a[vbcol=seagreen]
companies[vbcol=seagreen]
I'm[vbcol=seagreen]
internet. I[vbcol=seagreen]
point[vbcol=seagreen]
hosting[vbcol=seagreen]
our[vbcol=seagreen]
note[vbcol=seagreen]
connected[vbcol=seagreen]
implmented a[vbcol=seagreen]
|||ports 1433 and 21 (for ftp).
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
"PELEAANIL" <PELEAANIL@.discussions.microsoft.com> wrote in message
news:1A422957-611D-45FC-8D3E-A734340ECC27@.microsoft.com...
> Many thanks for reply.I suppose my office network has firewall & suppose
> hosting provider also has firewall, then for merge replication which ports
> would be involved?Based on your inputs will talk to my network team in
office[vbcol=seagreen]
> regarding the same.
> "Hilary Cotter" wrote:
internet or[vbcol=seagreen]
VPN[vbcol=seagreen]
the[vbcol=seagreen]
for[vbcol=seagreen]
you[vbcol=seagreen]
using[vbcol=seagreen]
should[vbcol=seagreen]
alias[vbcol=seagreen]
use a[vbcol=seagreen]
companies[vbcol=seagreen]
I'm[vbcol=seagreen]
internet. I[vbcol=seagreen]
point[vbcol=seagreen]
hosting[vbcol=seagreen]
our[vbcol=seagreen]
note[vbcol=seagreen]
connected[vbcol=seagreen]
implmented a[vbcol=seagreen]

Merge replication 32-bit IIS - 64-bit SQL Server 2005 -Windows Mobile 5 device

We have setup a 32-bit IIS server on a 32-bit machine. Installed necessary SQL Server components (32-bit replication components). We have installed SQL Server 2005 64-bit SP1 with latest hotfixes on a 64-bit machine.

On the Mobile device we installed SQL Server 2005 Mobile.

When we start mergereplication the problem we have is error 28009 (An instance of the SQL Server Reconciler cannot be created) on the mobile device. I read allot about it, but still have a questetion.

Should this work?

I found the doc: SQL Server 2005 Upgrade Technical Resource Guide:

Note: If your upgrade involves SQL Server CE subscribers, you must perform additional actions on the IIS server. You will need to install SQL Server 2005 client connectivity components along with SQL Server Mobile Edition components on the IIS server. You will also have to replace sqlcesa30.dlll, sqlcerp30.dll, and all the replication components on the IIS server.

From this I conclude it should work or is the doc in error?

If it does not, what can we do?

32-bit SQL Server 2005 on the 64-bit machine should work. (Can a 64-bit SQL Server 2005 run alongside 32-bit SQL Server 2005?).

Beste regards,
Hans Mank

The SQL Server CE components are also needed on the IIS server. Please install those and try again.