SQLEXPRESS Replication?

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" wrote in message

> 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" wrote in message
>
>>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
>
>
 >> Stay informed about: 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" 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" wrote in message
>
>
>
>
>
> > 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" wrote in message
> >
> >>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 -
 >> Stay informed about: 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" wrote in message

> 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" 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" wrote in message
>>
>>
>>
>>
>>
>> > 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" wrote in message
>> >
>> >>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 -
>
 >> Stay informed about: SQLEXPRESS Replication? 

How did you end up finishing this project?
I've got 2 SQL 2008 WE servers across a VPN link too.

The majority of the time changes will be made on server1 but I still need to be able to allow the reverse.

> On Thursday, January 31, 2008 7:10 PM Edwin Smith wrote:

> 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


>> On Thursday, January 31, 2008 9:35 PM Hilary Cotter wrote:

>> 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" wrote in message
>>


>>> On Friday, February 01, 2008 6:01 PM Edwin Smith 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" wrote in message
>>>


>>>> On Monday, February 04, 2008 11:31 PM Edwin Smith wrote:

>>>> 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" wrote in message
>>>>


>>>>> On Tuesday, February 05, 2008 12:28 AM Hilary Cotter wrote:

>>>>> 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=A0pm, "Edwin Smith" wrote:
>>>>>
>>>>> t
>>>>>
>>>>> ng
>>>>>
>>>>> do
>>>>> I
>>>>>
>>>>> .
>>>>> at
>>>>> s
>>>>> he
 >> Stay informed about: SQLEXPRESS Replication?