Replication SQL Server 2005 <-> SQL Server 2005 Express

Discussion in 'microsoft.public.sqlserver.replication' started by Roby Eisenbraun Martins, Jan 20, 2006.

  1. Hi,

    I'm Roby Eisenbraun Martins. I'm a C++, VB, C# developer.
    I'm developing a new application that requires work off-line from the
    database.
    I'm trying to work with SQL server 2005 replication, copying the data to
    a SQL Express database ( .mdf ), work off-line and then merge back into the
    publisher database.
    But It is not working.
    Where can I find more articles about it?

    Thank you,
    Roby Eisenbraun Martins
     
    Roby Eisenbraun Martins, Jan 20, 2006
    #1
    1. Advertisements

  2. What error message are you getting? There is no SQL Server Agent with SQL
    Server Express. You have to run your sync through windows synchronization
    manager or at scheduler (Task Scheduler).
     
    Hilary Cotter, Jan 21, 2006
    #2
    1. Advertisements

  3. Hi Hilary,

    Thank you for your help.
    I can create the publication but when I try to create a subscriber for
    that publication from a SQL Express database It doesn't work. It returns with
    an error message "Cannot find Server".
    I tried creating the subscriber using the SQL Management studio but I
    cann't select the SQLEXPRESS server as a subscriber.
    How can I make a .mdf file as a subscriber for my publication?

    Thank you,
    Roby Eisenbraun Martins
     
    Roby Eisenbraun Martins, Jan 23, 2006
    #3
  4. Roby Eisenbraun Martins

    Tom Guest

    Here are a couple more items to check while trying to get your connectivity
    to the remote SQL Express installation working...

    By default SQL Server 2005 Express SKU will install with network protocols
    disabled. If you want to use a tool external to your SQL Express
    installation box to connect to it, then you need to enable the network
    protocols. In the "SQL Server 2005" program folder from the start menu, you
    should be able to find a "Configuration Tools" folder. In this folder launch
    the "SQL Server Surface Area Configuration" tool. After connecting to the
    SQL Express instance in the tool, look under "Database Services" and
    configure the "Remote Connections option.

    Another item to note is that by default in SQL Server 2005 Express SKU, the
    default instance is SQLEXPRESS, not MSSQLSERVER. When you try to connect
    remotely, you need to use the server name and instance name, i.e.
    <ComputerName>\SQLEXPRESS

    Tom
    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Tom, Feb 13, 2006
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.