SQL Server Data Tools - Business Intelligence for Visual Studio 2012 - HasSecurityBackupAndDebugPrivilegesCheck impact?

Question

Hi,

Just installed "SQL Server Data Tools – Business Intelligence for Visual Studio 2012" from here:

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

To overcome a setup support rule check issue, I had to install the tool with the following switches:

setup.exe /ACTION=Install /FEATURES=SSDTBI_VS2012 /SKIPRULES=HasSecurityBackupAndDebugPrivilegesCheck

The installation seems to be successful, SSDT seems to be functional. (I don't expect that SSDT would deal with auditing or security logs.)

Again, this is NOT a SQL Server 2012 installation. It just comes as a SQL Server 2012 setup package.

Can anyone explain the impact of using this switch value? Or tell what features will be unavailable / not fully functional due to skipping this check?

Thanks in advance,

Zoli

Answer 1

Hello,

That rule is just to avoid errors during SQL Server installation only as explained on the following article:

http://support.microsoft.com/kb/2000257

Skipping this rule won’t have any effect on the functionality of SQL Server Data Tools.    

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Thanks, Alberto!

Zoli

(P.S. I don't understand why this rule check have been left in the setup package, as it's just a client tool.)

Answer 3

Hello,

You are correct. As you demonstrated, is not needed for SSDT.

Thank you for visiting MSDN forums!

Have a good weekend!

Regards,
Alberto Morillo
SQLCoffee.com