No more Business Intelligence Development Studio in SQL 2014

When you look at the installed programs with SQL Server 2014 CTP1 you see the following:

SQL 2014 installation

There is no BIDS or Visual Studio installed with CTP1 of SQL Server 2014.  After some additional research, and discovering that I didn’t miss something on the installation.  There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2014, instead it can be downloaded from the Microsoft download center.

SQL Server Data Tools for Business Intelligence (SSDT BI), previously known as Business Intelligence Development Studio (BIDS), is used to create Analysis Services models, Reporting Services reports, and Integration Services packages. In this pre-release version of SQL Server 2014, SQL Server Setup no longer installs SSDT BI. The Visual Studio 2012 version of SSDT BI is now available as a web download from the Microsoft Download center.

This is also a good time to mention… Please take a look at the Database Health Reports project.

Error code 0×85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer

Today I ran the install of SQL Server 2012 RC2 on another computer this time a Windows 7 computer not on a domain.  Here is the trouble that I ran into.

 

SQL Server Setup has encountered the following error:
There was a failure to validate setting CTLRUSERS in validaton function ValidateUsers.
Error code 0×85640004.

 

Then immediately after, I get this message:

 

 

So I tried the install again and turned off Integration Services, Distributed Replay Controller and the Distributed Replay Client in an attempt to get around this problem.

I didn’t spend the time to debug this and determine if it was Integration Services, Distributed Replay Controller or the Distributed Replay Client, but based on the bug write up at Microsoft titled Adding current user to Distributed Replay crashes setup, it looks like it is related to the distributed replay components.

 

2 Workarounds

My workaround if you want to just install and try out SQL Server 2012 Denali, then don’t install Distributed Replay unless you are on a domain.

There is another suggested workaround from Microsoft which is to install distributed replay with no user assigned, then add the user after the install.