Re: SQLEXPRESS Replication?

Thanks again. I am currently updating both ends to SP2 after upgrading both ends to SQL2005WE. The error is about needing to run sp_link_publication to set the credentials of the Server-Server link. However I remember seeing a KB article or maybe in Technet library that if this message happens to check the build numbers. Unfortunately I didn't save the link but it said the wizard is supposed to configure everything. The way the Technet SQL BOL is arranged it is difficult to know just how to setup the required permissions to do replication which is the major stumbling block.

In a little while I'll have both ends fully updates and WE on both then I'll be trying again. I have a sample database so I can do multiple tries without worrying about blowing things up. If I fail again I'll gather more stuff and logs to post back.

I have searched in vain for a simple to understand step-by-step procedure to do this but haven't found much. From scanning this group it seems like this is a difficult thing to get right so it's worth the experience of getting it wrong multiple times. I'm having loads of fun but the customer is surely getting impatient. I'm a week behind on this project.

Thanks for your help.

Edwin

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message news:3adf45b2-21ef-4730-85db-1b51b594d8e3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Change distribution server
    ... This is more of a maintenance question regarding replication. ... With all the SQL Agent jobs and replication pieces, ... Remember my scenario has the remote distributor on SQL2000 if that matters. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: replicated commands not executed on the subscriber side?
    ... My current environment is the most complex sql server environments in my 10+ ... Unlike the replication procedure when changes made at Subscriber, ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2000 and MSDE/Express/Compact edition..
    ... What is does is downloads .Net Framework and SQL Server Express if they are not installed and then configures SQL Server as a subscriber. ... string DotNetFramework2Location = ... LogMe("Creation of Replication Account failed."); ...
    (microsoft.public.sqlserver.replication)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central o
    ... Looking for a SQL Server replication book? ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)
  • Re: Subscriber Transaction Logs Too Large
    ... Its not so critical to shrink the db files or transaction logs in SQL 2005. ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)