What is the service should be enable\start for witness server configuration in db mirroring

Question

What is the service should be enable\start for witness server configuration in db mirroring

charipg

SSCrazy Eights

Points: 9888
More actions
April 29, 2013 at 5:34 am

#273374

What is the service should be enable\start for witness server configuration in db mirroring?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

e4d4 SSCertifiable Points: 5777 More actions · Answer 1

http://technet.microsoft.com/en-us/library/ms175191.aspx

You need a running instance of SQL Server, so at least a SQL Server service and a SQL Server Browser if witness is on named instance and you connect to them by specify an instance name not the port.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

e4d4 (4/29/2013)
http://technet.microsoft.com/en-us/library/ms175191.aspx
You need a running instance of SQL Server, so at least a SQL Server service and a SQL Server Browser if witness is on named instance and you connect to them by specify an instance name not the port.

The witness server, iirc, can even be SQL Server Express.