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:[email protected]] 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:[email protected]> Sent: Wednesday, February 17, 2010 2:38 PM To: NT System Admin Issues<mailto:[email protected]> 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 From: David W. McSpadden [mailto:[email protected]] Sent: Wednesday, February 17, 2010 2:33 PM To: NT System Admin Issues Subject: Re: SQL 2005 Mirroring Just using general names for the forum. domain\appsa account = sa account to me. Sorry for being vague. From: Michael B. Smith<mailto:[email protected]> Sent: Wednesday, February 17, 2010 2:09 PM To: NT System Admin Issues<mailto:[email protected]> Subject: RE: SQL 2005 Mirroring The SA account? You should be in a domain using windows auth, ne? Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: David W. McSpadden [mailto:[email protected]] Sent: Wednesday, February 17, 2010 1:15 PM To: NT System Admin Issues Subject: Re: SQL 2005 Mirroring Having trouble communicating between the witness, publisher, and subscriber... I can connect to thru Management Console to the SA account on all three but when I start up Mirroring I get a 1418 error?? From: Michael B. Smith<mailto:[email protected]> Sent: Wednesday, February 17, 2010 12:04 PM To: NT System Admin Issues<mailto:[email protected]> Subject: RE: SQL 2005 Mirroring Yes. It rocks REALLY hard. Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: David W. McSpadden [mailto:[email protected]] Sent: Wednesday, February 17, 2010 11:52 AM To: NT System Admin Issues Cc: NT System Admin Issues Subject: SQL 2005 Mirroring Anyone have this set up and working? ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
