question

KranthiDBA-1529 avatar image
0 Votes"
KranthiDBA-1529 asked Cathyji-msft commented

Seucrity update installation fails to update SQL Server data tools

While installing 4583465 Security update for SQL Server 2012 SP4 GDR it fails to update SQL SERVER Data tools. Below are the sample logs from SQL_bids_CPU64_1.log. I have run FINDSQLINSTALLS.vbs script, but couldn't find any missing MSI or MSP errors within the output file. Please advise what needs to be done to resolve the issue. Thanks in Advance!

Windows Installer installed an update. Product Name: SQL Server 2012 BI Development Studio. Product Version: 11.4.7001.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Update Name: Hotfix 7507 for SQL Server Business Intelligence Development Studio 2008 (64-bit) (KB4583465). Installation success or error status: 1603.

MSI (s) (84:F4) [00:18:51:507]: Note: 1: 1729
MSI (s) (84:F4) [00:18:51:507]: Product: SQL Server 2012 BI Development Studio -- Configuration failed.

MSI (s) (84:F4) [00:18:51:522]: Windows Installer reconfigured the product. Product Name: SQL Server 2012 BI Development Studio. Product Version: 11.4.7001.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 1603.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KranthiDBA-1529,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @KranthiDBA-1529,

While installing 4583465 Security update for SQL Server 2012 SP4 GDR it fails to update SQL SERVER Data tools. Product Name: SQL Server 2012 BI Development Studio.

This 4583465 Security update is the update package for SQL Server 2012 SP4 GDR, not include SQL SERVER Data tools(SQL Server 2012 BI Development Studio).

If you want to upgrade SQL server BI Development Studio, you need to download previous SSDT package, then select right SSDT-BI project templates. But the newest version SSDT has get all of the project templates together in one SSDT. Refer to MS document Previous releases of SQL Server Data Tools (SSDT and SSDT-BI) to get more.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.