How to Configure Read-Only Routing for an Availability Group

One of the main benefits of an AlwaysOn Availability Group is being able to read off of the secondary replicas. However, Read-Only Routing is not automatically configured when you first build your AlwaysOn Availability Group. To fully utilize an AlwaysOn Availability Group and take full advantage of having read-only connections connect to your secondary database, you will have to configure Read-Only Routing.

Continue reading How to Configure Read-Only Routing for an Availability Group

How to Slipstream SQL Server Install

If you cannot install SQL Server 2008 because of the known issue in the Setup program, you will have to use the slipstream method to successfully complete an installation of SQL Server. This method involves downloading the service pack package that you want for your architecture and combining that with the original SQL Server 2008 install media.

Continue reading How to Slipstream SQL Server Install

SQL Server: CMDEXEC Subsystem Failed to Load

During your life as a DBA, you will probably have to restore the master database and all the user databases on a new operating system to bring an already existing SQL Server instance online. One of my clients recently had an issue with hardware failure. Our only option was to install SQL Server on a new OS and use the backup files to restore all the databases from the old SQL Server instance. Once the new system was completely built and we restored msdb, we noticed that some of the SQL Server Agent jobs began to fail. Below is the error output from the job history. It states that the CMDEXEC subsystem failed to load.

Continue reading SQL Server: CMDEXEC Subsystem Failed to Load