RE: Error setting up SQL Replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Fredd,
Welcome to Microsoft TechNet Managed Newsgroup.

The error messages you encountered were permission related. To let me
better understand your scenario and perform further diagnosis, please help
answer the following questions:
1. Was your distribution database created on a local SQL Server or a remote
SQL Server when you setup up your merge replication?
2. Were you in a domain environment or Workgroup environment?
3. Did your SQL Server service account has encough permission to read/write
the folder C:\Replication?
You can go to Services panel, double click your SQL Server service, switch
to the Log On tab to check your current SQL Server service account. If you
are using a remote distributor, please ensure that your distributor SQL
Server service account is a domain user account and has Read/Write
permissions on that folder. If you have Windows Firewall enabled on your
distributor, please first disable it for isolation.

Also please help collect the following information:
1. SQL Server Error Logs on your publisher and distributor
By default it is in the folder %ProgramFiles%\Microsoft SQL
Server\MSSQL(.n)\MSSQL\LOG.

2. Windows Event Logs on your publisher and distributor
Please gather Windows Event Logs on the problematic node: Start ->
Administrative Tools -> Event Viewer -> Export application/system event
logs and send them to me.

My email is changliw_at_microsoft_dot_com. If the total size of the files
is over 2MB, please first send me an email response and then I will send an
email to you to let you know how to upload large files to me.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Who is using MSMQ?
    ... To add on to the other responses, the MSMQ warning messages you get from the ... SQL Server Service Manager are the same ones you get from the Windows MMC ...
    (microsoft.public.sqlserver.security)
  • SQLDMO replication installation troubleshooting tips?
    ... While attempting to enable replication on a customer's SQL Server cluster we ... SQLDMO is used to create the database that is to be replicated and the ... The cluster was recently updated to SQL Server 2000 SP4. ... The distributor database is set as being used for replication (state ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2K SSL Connection Problem
    ... Why did not you check the SQL Server service itself? ... So ensure your SQL Server service runs and the best practice for SQL Server service is using a domain account in domain environments. ... supporting Microsoft Groove Server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installation - What Account is needed?
    ... Because, when you change your SQL Server' s service account's password from your Active Directory, it won't be updated automatically at the SQL Server server and when your SQL Server service restarts, it'd compain about the wrong password. ... it does not mean your SQL Server services have to be running under the account which you installed the mentioned SQL Server instance. ... I understand you are asking about the required account to install a SQL ...
    (microsoft.public.sqlserver.setup)