I think the requirements are pretty clearly documented here: http://technet.microsoft.com/en-us/library/ms366346(SQL.90).aspx (also available in Books Online)
LocalSystem connects as Machine$ to remote machines on the network - not sure if you can use that, or you have to create a domain user account. Cheers Ken From: David W. McSpadden [mailto:dav...@imcu.com] Sent: Thursday, 18 February 2010 8:44 AM To: NT System Admin Issues Subject: Re: SQL 2005 Mirroring Sweet. The doc's I've been looking at keep talking about certs but none of them said what you just said. Thank you. From: Michael B. Smith<mailto:mich...@smithcons.com> Sent: Wednesday, February 17, 2010 4:28 PM To: NT System Admin Issues<mailto:ntsysadmin@lyris.sunbelt-software.com> Subject: RE: SQL 2005 Mirroring You have to run mirroring from an account that has network access privileges - which local system doesn't. Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: David W. McSpadden [mailto:dav...@imcu.com] Sent: Wednesday, February 17, 2010 3:08 PM To: NT System Admin Issues Subject: Re: SQL 2005 Mirroring Does having SQL running from local system instead of "sa" account sound obvious to you? From: Michael B. Smith<mailto:mich...@smithcons.com> Sent: Wednesday, February 17, 2010 2:38 PM To: NT System Admin Issues<mailto:ntsysadmin@lyris.sunbelt-software.com> Subject: RE: SQL 2005 Mirroring There are metric buttloads of potential issues with a 1418 error. I'd start on google and just work down the page. "sql mirror error 1418" Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
