Re: Setup up merge replication - problem with my config of MSSQLServer?

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

From: Darren Shaffer (darrenshaffer_at_discussions.microsoft.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 09:47:03 -0700

Ian - the bad news: NTFS is required for Merge Replication for two reasons:

1. to secure the virtual directory
2. to share and secure the snapshot folder.

You can convert a FAT32 filesystem to NTFS easily using the built-in utility
that comes with
Windows XP.

Darren Shaffer
Principal Architect
Connected Innovation

"Ian Ferguson" <ian.ferguson@cis.strath.ac.uk> wrote in message
news:%23Zml5gGDFHA.664@TK2MSFTNGP10.phx.gbl...
> Yep, everything patched up to date (SP3). I've tried seting up new
> copies of the database, new publications, new snapshot. No joy - the same
> problem keeps re-appearing.
>
>
>
> I'd like to try and track what actually happens on the server when I
> execute the code, but I don't know what tools are available to monitor
> connections to distributors/ publishers etc. Can you steer me in the right
> direction? I feel like I'm asking dumb questions here, but MSSQL is a new
> environment for me. Now if it was ORACLE, I'd know where to start.... :-)
>
>
>
> Regards,
>
> Ian
>
>
>>
>>
>
>
> --
> ---------------------------------------------------------------
> Dr Ian Ferguson University of Strathclyde
> Lecturer Department of Computer and Information Science
> Livingstone Tower
> Room : 10-18 26, Richmond Street
> Email: ian.ferguson@cis.strath.ac.uk Glasgow
> Web : www.cis.strath.ac.uk/~if G1 1XH
> Tel : +44 (0)141 548 3328 UK
> Fax : +44 (0)141 552 5330
> ---------------------------------------------------------------

Relevant Pages

  • Re: Setup up merge replication - problem with my config of MSSQLServer?
    ... I'll change over to NTFS and get back to you! ... to secure the virtual directory ... to share and secure the snapshot folder. ...
    (microsoft.public.sqlserver.ce)
  • Re: Is it really true that NTFS is secure?
    ... though getting Snort to alert just on interesting events on a Windows server ... Other things to do to look for the source of the hacking and secure your ... on Prof full time now and I am battling security it seems every hour. ... though I'm not sure this has to do with NTFS. ...
    (microsoft.public.security)
  • Re: Setting up PC for dual-boot Linux and Windows XP
    ... That's not really a problem for a pagefile ... No filesystem is secure if you have ... An appropriate Linux kernel can read *ALL* of them, ... including NTFS, from a boot floppy or boot CD. ...
    (comp.os.linux.setup)
  • Re: secured site with public pages
    ... application within IIS? ... can be caused by a virtual directory not being configured as an application ... > Additionally, if you have multiple secure pages, this is the easier option ... >> Using web.config I have setup users with passwords. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Virtual Directory and RDA
    ... it's not the virtual directory as much as the snapshot folder that matters. ... If there is no unc mapping because the machines are in different domains ...
    (microsoft.public.sqlserver.ce)