Archive for the ‘SQL 11’ Category

Windows 2008R2 MSTDC Clustering how hard can it be. Linked SQL Servers (2011-9-27)

Category: MSDTC, SQL, SQL 11, SQL 2008, SQL 2008 R2, SQL Denali, Windows 2008 R2 Cluster, Windows 2008 R2 MSDTC, Windows 2008 SQL 2008 Cluster, Windows 8 Cluster | No Comments

The DTC option is a simple feature just turn it on and it works eh yeh sometimes. but in advanced environments you need often some tweaks and how to’s The following errors are common on misconfiguration on the SQL Cluster / MSDTC source MSDTC encountered an error (HR=0×80000171)  Or if you are using linked SQL [...]

What can go Wrong during the SQL 11 upgrade ( Beta SQL 11 Denali ) (2011-3-21)

Category: Denali, Microsoft SQL 2008R2, Microsoft SQL Server 2008 SP2, SQL 11, SQL 2008, SQL 2008 R2 | 1 Comment

Now that there is a beta of SQL 11 ( denali ) I want to see if I can break my Cluster with SQL 2008 on it during the upgrade. Yes I can. <>>Extra These are testing machines ( snapshot of production ) and the screenshot are showing you what can go wrong. It was [...]