Re: Replication problems

From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 09/09/04

  • Next message: pat: "Re: Replication problems" 
    Date: Thu, 9 Sep 2004 16:27:24 -0700

    The error that you are getting regarding using a system account is fine as
    you will not be doing sync between SQL Servers. It's not an issue for what
    you are doing. Many people want to do sync between two SQL Servers and for
    that you need to use a domain account and not the machine system account.
    That's why you are getting that error message.

    For your second problem (being able to create shares), you need to go into
    Windows Explorer, choose Tools| Folder Options and choose the View tab.
    >From there you need to check the option "Use Simple File Sharing". This
    should allow you to then share out folders. This happens on machines that
    are not part of a domain. From there you should be able to reference a
    machine share which you can then reference in the publication wizard.

    I don't know what 1038 error is, but I would drop all the publications and
    start over with the information provided above to see if it still happens.
    The problems you are experiencing right now have to do exclusively with
    creating the publication. You might also post the error 1038 to the SQL
    Server newsgroup that deals with merge replication as they would have more
    knowlege about that particular issue than I would.

    "pat" <pat@discussions.microsoft.com> wrote in message
    news:07A9C25C-D8F1-4A9F-A3CE-6FDB9116C275@microsoft.com...
    > Hi,
    >
    > First thank you very much for your information. The situation is as
    > follows:
    > My IIS and the SQL Server 2000 and the VS.NET 2003 Enterprise Edition are
    > on
    > the same machine (laptop ACER 662 LCi).
    >
    > I looked caryfully at your posted SQLMobileHol.doc - Creating a
    > publication.
    > But as said in the first step of the Create Publication Wizard i checked
    > the
    > first option and the notification appears:
    > SQL Server Agent on 'MachineName' currently uses the system account, which
    > causes replication between servers to fail. In the following dialog box,
    > specifiy another account for the Service startup account.
    > Why does this appear and how can i solve this problem?
    >
    > At the point with the SnapShot-folder there is something different in the
    > windows explorer to mine, in my explorer of windows xp pro i cannot choose
    > "Share this folder" or the Permissions button or choose FULL CONTROL. (I
    > have
    > the german version of windows xp pro). I was only able to give this folder
    > read, write access. Is this a problem and/or how i can solve that?
    > And then i have quoted in the Create Publication Wizard as path for the
    > SnapShot Folder:
    > \\MachineName\ReplData (for MachineName i quoted the name of my computer)
    > But when i click then okay the following error occurs:
    >
    > SQL Server Enterprise Manager could not retrieve information about the
    > Distributor or the database.
    > Error 1038: Cannot use empty object or column names. Use a single space if
    > necessary.
    >
    > Can you please help me how i can solve these problems because i think
    > these
    > are problems which do not concern the right way for create a publication,
    > because i execute all commands as they are quoted in your doc-file, or in
    > my
    > .NET CF Book or in an E-Book. - I hope i created the Virtual Directory in
    > a
    > right way, because in the Creation Wizard of the Virtual Directory at the
    > NTFS Permissions: Computer Running SQL Server i have not checked the One
    > or
    > more applications requiring SQL Server merge application. I hope this is
    > not
    > a problem for the Creation of the Publication?
    >
    > Hopefully you find further time to read my statements and can help me. I
    > think it does not concern the right execute of the commands for the
    > publication.
    >
    > Regards
    >
    > patrick
    >
    >

  • Next message: pat: "Re: Replication problems"