Sign Up for Training |
Jet Global Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Error "Item Has Already Been Added" Opening Server Properties on Analysis Services


The error occurs when the user attempts to open the server properties for SQL Server Analysis Services within SQL Server Management Studio



There is a known issue when using SQL Server 2012, 2008 R2, or 2008 with the following operating systems:

  • Windows 8
  • Windows 8.1
  • Windows Server 2012
  • Windows Server 2012R2
The error message is detailed in full at the following Microsoft KB article:


There are presently two known fixes to the above error:

  1. Connect to the SQL Server Analysis Services instance from another machine having SQL Server Management Studio that is not experiencing the above error, or
  2. Download and install the recommended cumulative update ("CU") for your version of SQL Server from the following Microsoft KB article: . Navigate to the "Resolution" section and select your version of SQL to be brought to the appropriate CU landing page
It is entirely possible that the CU might require a server restart. Please plan the implementation of the CU accordingly and in accordance with your organization's server maintenance policies.

Please see the related article on how to determine your version of SQL Server

Was this article helpful?
0 out of 0 found this helpful