ok what about a secondary firewall, as previously suggested attempt a telnet to the port from the principal server

do you have windows firewall enabled on the secondary server?

Duran (9/24/2014)

---

Hey Guru's,

Lets say you have DB's log shipping from A to B in stand-by-mode so the DB are readable inbetween the apply log jobs. Is it possible to then...

certainly using SQL Server auth, using Windows auth will require assistance from a domain administrator

keep an eye out for the remaining 8 levels of the stairway 😉

Jerry Hung (9/24/2014)

---

Sadly, no Windows 2012 for OS at work yet @@ so I...

Thank you, it's a 9 level stairway, there are 8 more levels to...

Hi

Thanks for the comments please don't forget to rate the article if you found it useful

Regards Perry

a clustered dtc is no longer mandatory for sql server 2008, it was for 2005.

There certainly used to be an issue in sql 2005 where a clustered instance of sql...

no need to stop a SQL server database, they are transactionally consistent even with users connected

what size and speed are the disks

It's all in my article at this link[/url]

You're welcome, dont forget to mark an answer as correct if it helped, it may also help others 😉

As gail pointed out its in black and white if you want to read it, doesnt need a call to MS!

dave 67553 (9/23/2014)

---

Can I use the developer instance of SQL Server EE as the replica partner for production AlwaysOn AGs if no access was ever made to production data unless...

OK, just pull out the sections relating to