Re: Snapshot Agent account rights

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

I select Login Properties for a domain account and select User Mapping.

However, if
I check the "Map" checkbox and enter "dbo" for the User column and then
click "OK" I receive the error :

"Create failed for User 'dbo' (Microsoft.SqlServer.Smo)
Additional information:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
User, group, or role 'dbo' already exists in the current database.
(Microsoft SQL Server, Error: 15023)

So apparently SSMS attempts to create the specified user in the specified
databases (when I wanted a mapping) but the user already exists.


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OYWs$l59GHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
It needs rights to 1) access to SQL Server, ideally dbo in the
distribution and publication database. 2) write access to the folder which
is your snapshot share.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:utBcRg59GHA.1128@xxxxxxxxxxxxxxxxxxxxxxx
Using SQL Server Agent as the Snapshot Agent account is not a recommended
best security practice. If a domain account is used, what rights and
permissions should it be granted ?





.

Relevant Pages

  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... I do the select user_nameand get dbo ... Do you mean EM lists VDW as the owner of the database? ... I presume then that you are logged in as tfs. ... So my guess is that the login tfs is in the sysadmin role on the server, ...
    (microsoft.public.sqlserver.programming)
  • Re: Groups for dbo
    ... Thanks for the instructions on changing the database owner...I suspect ... While dbo is SUPPOSED to be a special user that's not used for routine ... It's probably safer to change the database owner in any event, ... >> I'm still fairly new to SQL Server, and I'm trying to figure something ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
    (microsoft.public.sqlserver.security)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)