SQL Srvr acct removal from Local Admin Group - repl implications ? -- sql server replication

jyard
1/12/2007 3:11:00 PM

In a Sql Srvr 2k system a domain account is used to start both sql server and
sql server agent. This domain account is currently defined in the local
machine Local Administrators Group. I need to delete this account from the
Local Administrator's Group. ( See support.microsoft.com/kb/283811 ).

When I remove this local admin account definition, are there any replication
issues ? Any Sql Server Agent implications ? I have done this to a test
system succcessfully , but this system is simple, w/o the replication and
other functiuonality of the production system.

Thx,

John Yard
UCLA

Hilary Cotter
1/12/2007 11:27:00 PM

SQL Server Agent account must be able to map a drive to the admin share. To
get around this create a non-admin share for your default snapshot location.

That is all I am aware of.

--
Hilary Cotter

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

[quoted text, click to view]

sql server replication : SQL Srvr acct removal from Local Admin Group - repl implications ?