Re: SQLEXPRESS Replication?

I need to know the exact error messages to diagnose this problem
further.

If you can enable logging that will help with the diagnosis and
troubleshooting.

You can replication from SQL Server 2005 Workgroup edition and above
to a SQL Server Express subscriber using transactional replication. If
you are using a pull subscription you will have to code the pull using
tsql, ActiveX controls, or RMO. You can schedule the pulls using task
scheduler, or manually pull them with code, or Windows Synchronization
Manager.


On Feb 1, 6:01 pm, "Edwin Smith" <smithgold...@xxxxxxx> wrote:
Hi:

Thanks for the hint. I set up Merge replication but it fails and the links
in the error message go nowhere. It seems to be failing on the snapshot yet
it did get at least one snapshot. During the night.

Here's what I did:

I created a user called repl_user.

I made the repl_user a db_owner on the database at the publication and at
the subscriber. This is a domain system so the repl_user is common on both
servers.

I gave repl_user access to the publication.

I shared the snapshot folder and gave repl_user full permissions on the
share and security tabs.

I tested the Publication to make sure it created the snapshot. I set the
merge intervals for 1 hour to minimize latency.

I then subscribed the target DB but when I check the status it says it is
not a subscriber???

IN the monitor it says the subscriber is synchronizing but maybe it's timing
out. This runs for about 45 minutes. Then it gets another error.

CAn I use transactional publication with SQL 2005 Express as a subscriber?
The documentation says I can but isn't really specific if SQL Express can do
this.

Again I'm using a VPN link through a SonicWall TZ180 which is rather slow. I
was trying to use replication to give the remote site users faster read
access but still allow updates from the subscriber. When I tried this with
Virtual Server to test I got a different error saying I need to run
sp_link_publication on the subscriber to set a password for the sa account..
I thought the sa account PW could be set with SQL management Studio.

So far the error messages have been very unhelpful. Is there a good
reference that shows how to do this step by step. The Tutorials are somewhat
dated as is the book you linked to which is for SQL2K.

Thanks

Edwin

"Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote in message

news:O4KBwsHZIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx



Use merge replication for this.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Edwin Smith" <smithgold...@xxxxxxx> wrote in message
news:%234jTqbGZIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx
I have 2 servers in different cities connected with a VPN link. One is
running SQL 2005 Workgroup edition. The other is running SQL 2005 Express
edition.

Can I do replication such that transactions at either server can be
replicated to the other?

I am able to get it to work from the Server with Workgroup edition to the
server with Express but not the other way.

Do I need to have Workgroup Edition at both ends?

Thanks

Edwin- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Merge replication in 2005... Version conflict?
    ... unless your subscriber really is SQL 2000 RTM. ... drop the existing subscription database and recreate it. ... Looking for a SQL Server replication book? ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Questions about RDA & Replication
    ... When performing RDA relations are not preserved in the corresponding sql ce ... when performing replication relation for a table T are preserved ... > in the table on the SQL Server side. ... One approach is to allocate a distinct range for each subscriber and a range ...
    (microsoft.public.sqlserver.ce)
  • SQL2008 to SQL2005 SnapShot replication snapshot FTP - CAB file er
    ... We have an issue with a SQL Server 2008 to SQL Server 2005 snapshot ... The subscriber is a SQL 2005 server, ... We are experiencing an issue where the CAB file is transferred successfully ...
    (microsoft.public.sqlserver.replication)
  • Re: help with pull subscription
    ... to add the register the subscriber under the distributors properties. ... > Paul Ibison (SQL Server MVP) ...
    (microsoft.public.sqlserver.replication)
  • Re: THE SELECT STATEMENT
    ... > statement through error messages from our server". ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Prev by Date: ...
    (comp.databases.ms-sqlserver)