StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTrouble setting up witness in SQL Server mirroring scheme w/ error
text
Body
copied!<p>I've got a trio of Windows servers (data1, data2 and datawitness) that aren't part of any domain and don't use AD. I'm trying to set up mirroring based on the instructions at <a href="http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx" rel="nofollow noreferrer">http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx</a>. I've had success right up until the final set of instructions where I tell data1 to use datawitness as the witness server. That step fails with the following message:</p> <blockquote> <p>alter database MyDatabase set witness = 'TCP://datawitness.somedomain.com:7024'</p> <p>The ALTER DATABASE command could not be sent to the remote server instance 'TCP://datawitness.somedomain.com:7024'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.</p> </blockquote> <p>I've tested both port 7024 as well as 1433 using telnet and both servers can indeed connect with each other. I'm also able to add a connection to the witness server from SQL Server Manager on the primary server. I've used the Configuration Manager on both servers to enabled Named Pipes and verify that IP traffic is enabled and using port 1433 by default.</p> <p>What else could it be? Do I need any additional ports open for this to work? (The firewall rules are very restrictive, but I know traffic on the previously mentioned ports is explicitly allowed)</p> <p>Caveats that are worth mentioning here:</p> <ul> <li><p>Each server is in a different network segment</p></li> <li><p>The servers don't use AD and aren't part of a domain</p></li> <li><p>There is no DNS server configured for these servers, so I'm using the HOSTS file to map domain names to IP addresses (verified using telnet, ping, etc).</p></li> <li><p>The firewall rules are very restrictive and I don't have direct access to tweak them, though I can call in a change if needed</p></li> <li><p>Data1 and Data2 are using SQL Server 2008, Datawitness is using SQL Express 2005. All of them use the default instance (i.e. none of them are named instances)</p></li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload