德瑞克：SQL Server 學習筆記: SQL Server 2014 SP1，暫時先下架...日期：2015/04/16

2015-04-16

SQL Server 2014 SP1，暫時先下架...日期：2015/04/16

更新日期：2015/05/14

SQL Server 2014 SP1 重新開放下載

版本：12.0.4100.1
發佈日期：2015/5/14
http://sharedderrick.blogspot.tw/2015/05/sql-server-2014-sp1.html

日期：04/16/2015

確認公告：移除 SQL Server 2014 Service Pack 1 (SP1)，等待數周修復後，將重新上架。

公告網頁內，也包含：使用先前有問題的版本，導致升級失敗的解決方式。

Important Updates on 4/16:

Dear SQL Customers,

We have chosen to remove SQL Server 2014 Service Pack 1 (SP1) from the Microsoft Download Center due to a significant installation issue discovered shortly after release. We sincerely apologize for the inconvenience this has caused you.

We will fix the installation issue and release the Service Pack for production use in a few weeks. Although operationally equivalent, only the newly released SP1 will be serviced (security updates, cumulative updates, hotfixes). Therefore, it will be important that you replace the current version of SP1 (12.0.4050.0) with the upcoming one.

In the meantime, you can continue to test and use build 12.0.4050.0. If you are experiencing the issue below, please implement the steps described in the workaround section.

We will communicate further as we approach the release date and we appreciate your patience.

Rong Wu

SQL Engineer Team

日期：2015/04/16

暫時先下架...

Notice:
The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible workarounds and fixes. We have temporarily put the package download on hold and will provide an update with a solution.

SQL Server 2014 Service Pack 1 has released
http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx

請注意
受影響的 Microsoft SQL Server 2014年的累積更新 1 問題先前已造成我們從下載伺服器移除這個更新。我們必須立即解決這個問題，並更新一次可供下載。

Notice
An issue that affected Cumulative Update 1 for Microsoft SQL Server 2014 had previously caused us to remove the update from the download server. We have now resolved the issue, and the update is again available for download.

下載 SQL Server 2014 SP1
http://www.microsoft.com/zh-TW/download/details.aspx?id=46694

SQL Server 2014 SP1 download page
http://go.microsoft.com/fwlink/?LinkID=519065

2015-04-16 10:21:15.23 spid8s Schema build in SSISDB has been updated to 12.0.4050.0
2015-04-16 10:21:15.37 spid8s Error: 1088, Severity: 16, State: 12.
2015-04-16 10:21:15.37 spid8s Cannot find the object "internal.object_parameters" because it does not exist or you do not have permissions.
2015-04-16 10:21:15.37 spid8s Error: 912, Severity: 21, State: 2.
2015-04-16 10:21:15.37 spid8s Script level upgrade for database 'master' failed because upgrade step 'SSIS_hotfix_install.sql' encountered error 3602, state 251, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.

參考資料

SQL Server 2014年累積更新 1
https://support.microsoft.com/zh-tw/kb/2931693/zh-tw

SQL Server 2014 Service Pack 1 is now available
http://blogs.technet.com/b/dataplatforminsider/archive/2015/04/15/sql-server-2014-service-pack-1-is-now-available.aspx