Re: Merge Replilcation issue
From: mgarner1980 (mgarner_at_kbsi.com)
Date: 07/21/04
- Next message: Mani: "Re: Merge Replilcation issue"
- Previous message: Mani: "Re: Merge Replilcation issue"
- In reply to: Mani: "Re: Merge Replilcation issue"
- Next in thread: Mani: "Re: Merge Replilcation issue"
- Reply: Mani: "Re: Merge Replilcation issue"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 17:45:37 -0500
As far as the IIS user account open up your "configure connectivity support
in IIs" from your start\programs (or do this through your internet services
manager) and see what account is being used for anonymous access.
When you set up your merge replication you had to setup a publication share
(right?). What I was saying is that that anonymous access account must have
permissionsfor the the publication share.
That is what the "Connectivity support for IIS manager" is setting when you
go to ntfs permissions and get to the checkbox "one or more applications
requiting sqlserver merge replication" it's there that you enter the
publication share and the manager sets the permissions.
In my case my "IIS server" and my "SQLSERVER" machines were desktop machines
(not servers), and in their cases the IUSER_xxxx account is a local account.
Therefore if I used a separate IIS box from my SQLSERVER box, I couldn't get
access to the share even when permissions were set. I had to change the
anonymous account to one that was a domain account, and set the permissions
for it on the share.
If you're using nt authentication on your database your publisher pwd and
login are what gets you hooked up (assuming the login and pwd you setup are
in the PAL as you mentioned). The internet pwd and user are for IIS login
(if it's set to ntfs). (I also had to use \\domainname\username for the
login to get it to work.
I also had to add : Integrated Security=SSPI
to get nt authentication ot work for the sqlserver.
I just want to note that these are all things I wnet through ........I don't
claim to be an expert on any of this!
"Mani" <mani_AT_evikasystemsdotcom> wrote in message
news:%23BKso%232bEHA.1048@tk2msftngp13.phx.gbl...
> Thank you,
>
> I do call the addsubscription() on the replication object, which goes thru
> fine, This is what I do :: I check for a db file existing in the pda, else
I
> call the replicationobject.AddSubscription (AddOption.CreateDatabase) to
> create the db.
>
> =>how do i set up the IIS user account to the publication share? do you
mean
> to add them to the publication access list?
> =>how does the nt authenticatin take place...do i have to pass the
ntuserid
> /pwd in the internetlogin/internetpassword?
>
> I will be trying this shortly on the Real thing!
>
>
>
>
> "mgarner1980" <mgarner@kbsi.com> wrote in message
> news:exsRl32bEHA.1132@TK2MSFTNGP10.phx.gbl...
> > I also responded on the compact framework group, but this is the correct
> > place to discuss this
> >
> >
> > not too sure about the error you're getting, but I found I had to set
the
> > publishersecuritymode to NT If I was using nt authentication.
> >
> > you'll also need to call addsubscription if the subscription doesn't
> already
> > exist.
> >
> > in addition your IIS anonymous login user account must have priviledges
> for
> > the publication share.
> >
> > I'm only listing these things cuz these were all hurdles I had to jump
in
> > order to get it working correct.
> >
> > BUT!!!!!!!!! I must add that that was on my device. I've never tried it
on
> > the emulator. I've found the emulator is cool for small stuff, but not
> that
> > great for real apps. (just my opinion).
> >
> > "Mani" <mani_AT_evikasystemsdotcom> wrote in message
> > news:eBHdnp2bEHA.2880@TK2MSFTNGP12.phx.gbl...
> > > Hi all,
> > >
> > > I am trying to perform a "Merge Replication" from the PPC simulator
with
> > > VS.net 2003. Has anyone experienced this before or have any
resolution?
> > > the SQL Server publiation is setup on another machine which also
serves
> > as
> > > the SQL Server CE Agent (configured with anonymous access only with
NTFS
> > > permissions)
> > >
> > > Funny thing here is there is no message!! is the SQL CE team here?
> > >
> > > HResult -2147024891
> > > Message ""
> > > NativeError 0
> > > Source "Microsoft SQL Server 2000 Windows CE Edition"
> > >
> > >
> > > oRpl = new SqlCeReplication();
> > > oRpl.Publisher = "<<publisher>>";
> > > oRpl.PublisherLogin = "dbuser";
> > > oRpl.PublisherPassword = "dbpassword";
> > > oRpl.InternetUrl = "http://192.168.2.84/pda/sscesa20.dll";
> > > oRpl.InternetLogin = "AnotherMachine\\IUSR_AnothermachineName";
> > > oRpl.InternetPassword = "";
> > > oRpl.Subscriber = "CESubscriberTest";
> > > oRpl.Publication = "Northwind";
> > > oRpl.PublisherDatabase = "Northwind";
> > > oRpl.SubscriberConnectionString =
> > > "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=" +
> > > this.myDataSource;
> > >
> > > /// fyi, this.myDataSource = "\\program
> > > files\\CF\\Inventory\\TestDB1.sdf";
> > >
> > > oRpl.Synchronize(); [CODE FAILS HERE and throws exception]
> > >
> > > Thank you,
> > >
> > >
> >
> >
>
>
- Next message: Mani: "Re: Merge Replilcation issue"
- Previous message: Mani: "Re: Merge Replilcation issue"
- In reply to: Mani: "Re: Merge Replilcation issue"
- Next in thread: Mani: "Re: Merge Replilcation issue"
- Reply: Mani: "Re: Merge Replilcation issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
