Re: Merge replication

From: Hilary Cotter (hilaryk_at_att.net)
Date: 03/25/04


Date: Wed, 24 Mar 2004 21:54:02 -0500

Windows Synchronization Manager does support using NT authentication. In
fact I recommend using NT Authentication, as SQL Authentication requires you
to enter the sql account and password each time WSM runs the distribution or
merge agent.

"Zeljko Matic" <zeljko.matic3@zg.tel.hr> wrote in message
news:OQjBPdcEEHA.700@TK2MSFTNGP09.phx.gbl...
> I'm using scheduled merge replication with SQL server agent job in mode
> "Inperosnate SQL server acount".
>
> I have problem with Windows synhronize manager, because it don't support
> this mode, and it always ask for supplaying SQL acount before replication.
I
> need to use Synhronize manager on disconected location to provide users
with
> ability of manualy starting immediate replication.
>
> Is there a new version of Synhronize manager or is there a way to tell
> Synhronize manager to use "Inpersonate SQL server acount"
>
> Thanks in advanced.
>
>



Relevant Pages

  • RE: * * * C# Application and Database Security Model * * *
    ... I've noticded that your main concern here is to provide security ... If you're going to do authentication and authorization against windows ... ASP.NET 2.0 also provide a well encapsulated Membership and role manager ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: TRASICTIONAL PUBBLICATION ERROR 37000
    ... SQL Profiler is a monitor tool for SQL Server. ... from Enterprise Manager: on the Tools menu, ... Microsoft Customer Support Services via telephone so that a dedicated ...
    (microsoft.public.sqlserver.replication)
  • RE: SQLCMD fails with login timeout expired.
    ... I understand tht you could connect to SQL Express properly by 2005 ... management tool but you cannot connect it via sqlcmd. ... In Configuration manager, please make sure TCPIP and named pipes ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.tools)
  • RE: Association missing in dbml generated classes
    ... How to implement a many-to-many relationship using Linq to Sql? ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Server 2k connect error - local
    ... SvrA Ent. ... Manager and Query Analyzer. ... I used Windows authentication, then SQL authentication - no result. ...
    (microsoft.public.sqlserver.connect)