EXEC sys.sp_configure N'remote access', N'1'

GO

RECONFIGURE WITH OVERRIDE

GO

There is also an instance property that can be set using the code above. I think it is not enabled by default in...

If you are using the report wizard this only allows you to upload to existing directories. You can upload directly to the Report Server Site or to a local...

Full Recovery or Not

Proper transaction log backups for full recovery model databases.

Set Maxdop setting per http://support.microsoft.com/kb/2806535

Set Cost Threshold for Paralellism

Set OS power options to high performance

Enable optimize for...

The SQL Server DMV's are available in 2008r2 so you will be fine to use those. The issue is capturing the data and storing some history. We use...

I believe the the recommended practice has always been to use the same version of profiler as the server you are going to trace. Also I know there is...

I ran into something like this as well a while back. The SAN vendor, Netapp did not support .mdf or .ldf files on the root of a mounted drive....

You need to give it a new name or destroy the cluster and recreate it with a new name. The cluster name is registered as a virtual computer name,...

You need to re-run the setup from the developer, enterprise, or standard media and choose the standalone option and add the feature.

When you install the SQL server cluster it will add a service/application in the cluster configuration. I really think you need to double check that the server name exists...

In a clustered setup you can't use machinename\instancename. You must have a new Server name for the cluster. Did you check both DNS and AD? The Server...

----putting node1 and node 2 physically in two different locations help even if network goes down?

It totally depends on where the network failure is located. Between the locations, total...

Does the network name or server name exist in Active Directory or DNS currently? You should not be using the host names of the servers at all. In...

Did you see if the name existed in DNS when you were done? If you are installing it in a cluster does it still exist in the cluster configuration?

Someone can chime in if I am wrong on something here.

1. Listeners reside on all nodes in the AG simultaneously.

2. Enterprise Edition is required for Availability Groups

3. If you...

What about the io, cpu, and memory usage on each VM. Will the passive instance use less of these resources? Does it make sense to spread the workload...