Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Witness server connection

Author  Topic  reems Starting Member 2 Posts Posted - 2009-02-26 : 11:32:26 Hi, I'm using SQL Server 2008 (enterprise edition), I configured two servers to be mirrored (Principal and Mirror server), the servers is connected and it works good. Now I'm trying to add the Witness server, and when I'm running the Mirror Wizard I get the next Error: Log in failed for user 'ServerName\Guest'. (Microsoft SQL Server, Error: 18456) Severity: 14 State: 1 I'm logged in with Administrator account, why Guest account trying to connect the witness instance ??? By the way, I can connect to Principal and Mirror servers from Witness server, I enabled TCP protocol (of services) and opened port 5022 (default) and also add the programs that mentioned in Configure mirror database session (MSDN) to windows firewall. Thank you.