In terms of the licensing to get a better understanding I suggest that you look at the following:

http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

However, it is always best to speak with your Microsoft representative...

See the following article for access control lists in Windows Server and ensure that the service account has the correct permissions according to this.

You will find the relevant information under...

If it is for testing only, you can also get the SQL Server 2008 R2 evaluation edition from the following site:

http://www.microsoft.com/en-us/download/details.aspx?id=8158

Try launching SSMS with Run as Administrator.

If this resolves the issue, you can follow the steps outlined in http://support.microsoft.com/kb/2000474

This is because SSMS is a 32-bit application.

Apologies, got a typo in 🙂

EXEC [dbo].[sp_sysutility_mi_remove]

Hi,

You need to execute the following on the server:

EXEC msdb.sys.sysutility_mi_remove;

If you do plan to use the same server again as a UCP, then you need to follow the steps described...

Hi,

You can go to the following site to download BOL for SQL 2012:

http://www.microsoft.com/download/en/details.aspx?id=347

This is an offline installation copy which you can keep. Keep in mind however that as...

- Tried executing the script so that script out all the logins

- But it doesnt work.

- Can anyone help me in getting around this problem. Is there anyway to...

Have you changed the service account of the SSIS services on any of the nodes? This can have an effect, especially if you are using domain authentication instead of the...

The article doesn't state that it is not recommended on a cluster, the article states that it is not recommended to configure SSIS as cluster resource.

To install SSIS on a...

Have you tried to restart to SSIS services on both nodes? Also remember, the modification needs to happen on both nodes in some cases that I've seen.

In SQL Server 2008 the best option for auditing will be Server and Database Audit Specifications in my opinion as it provides some level of flexibility.

You can read more about...

Hi,

The SQL Virtual Name, OS Virtual Name and the node names should be given full control of the OU container where the SQL Server Cluster will be located in AD.

Hi,

Traces is not very clear on this matter, the best suggestion that I can think of, and find is to do the following:

SELECT

e.name,

...