Re: Using a specific user as PublisherLogin

This is based upon whether your replication SecurityType is set to
NTAuthentication or DBAuthentication, and whether the "SQL server user" is a
Windows User on the machine or has DB privileges on the SQL server.
NTAuthentication settings are the easiest to setup for users who have
Windows User access on the machine where SQL2k is running, as they do not
need a login or password.

"Nikolai Evseev" <NikolaiEvseev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5CCC6975-452E-43AD-8A43-AAF6613EF222@xxxxxxxxxxxxxxxx
> Dear all,
>
> This is a question in relation to the configuration of a replication. I
> specify a regular SQL server user in the PublisherLogin property. What
> permisstions should this user have to be able to do 'Synchronize'? Should
> it
> be a dbo?
>
> Thanks in advance,
> Nikolay


.

Relevant Pages

  • AUTHENTICATION TO APPLY SP3
    ... a problem with SP3? ... > SQL Server 2000 RTM Standard Edition ... >windows user. ... >These accounts and passwords are good because I can get ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2008 set up
    ... Probably you did not install your SQL Server 2008 Instance under this Windows User Account and probably you did not add this user to the "SQL Server System Administrators" list during SQL Server 2008 Setup. ...
    (microsoft.public.sqlserver.setup)
  • Re: ASP.NET Forms Authentication Via A SQL Server Database With Windows User types?
    ... we have decided to go with SQL Server security vs Windows (using ... Standard SQL Users, not the Windows Users) - it just seems to be the ideal ... The Windows user type in SQL Server uses the security context of the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Copy User permission
    ... We are migrating Windows user to amnother domain, ... server windows users have sid, and name hard coded to the ... SQL Server ... login id to a new login id? ...
    (microsoft.public.sqlserver.security)
  • Re: Get Login
    ... In "Windows Authentication mode" the system_user returns the ... Sql Server can't know the Windows User name if the Authentication is "SQL ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)