DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2889492 - Last Review: March 26, 2014 - Revision: 7.0

On This Page

Symptoms

Consider the following scenario:
  • You have Microsoft SQL Server Management Studio installed on a Windows 8.1-based client computer.
  • You connect the Object Explorer panel to an instance of Microsoft SQL Server Analysis Services (SSAS) in SQL Server Management Studio.
  • You try to select Properties for the instance of SSAS in order to view or change the properties of the instance.
In this scenario, the properties dialog box does not appear. Additionally, you receive the following error message:

===================================

Cannot show requested dialog.

===================================

Cannot show requested dialog. (SqlMgmt)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

===================================

The type initializer for 'Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel' threw an exception. (Microsoft.AnalysisServices.SsmsManagementDialogs)

------------------------------
Program Location:

at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel..ctor(CDataContainer dataContainer)
at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesDialog..ctor(CDataContainer dataContainer)

===================================

Item has already been added. Key in dictionary: '4096' Key being added: '4096' (mscorlib)

------------------------------
Program Location:

at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at System.Collections.Specialized.StringDictionary.Add(String key, String value)
at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesLanguagePanel..cctor()

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 11 for SQL Server 2012   (http://support.microsoft.com/kb/2908007/ )

Cumulative Update 7 for SQL Server 2012 SP1  (http://support.microsoft.com/kb/2894115/ )

Cumulative Update 14 for SQL Server 2008 SP3  (http://support.microsoft.com/kb/2893410/ )

Cumulative Update 10 for SQL Server 2008 R2 SP2  (http://support.microsoft.com/kb/2908087/ )

About cumulative updates for SQL Server

Collapse this imageExpand this image
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Collapse this imageExpand this image

Workaround

If you cannot apply the fix that is discussed in the "Resolution" section, use one of the following workarounds to make the planned changes by using SQL Server Management Studio.

Note These workarounds do not resolve the error in SQL Server Management Studio. They only provide alternate methods to make the planned changes.

Workaround 1: Use SQL Server Management Studio on a different computer

To work around this issue, use SQL Server Management Studio on a different computer that is running an earlier version of the operating system.

Workaround 2: Manually edit the property tags

To work around this issue, manually edit the property tags in the Msmdsrv.ini configuration file on the disk of the Analysis Services server. To do this, follow these steps:
  1. Start Notepad in an elevated administrator mode.
  2. In Notepad, click File, click Open, and then locate the folder that contains the Msmdsrv.ini file.

    Note This folder may be located in the default 64-bit program files or on a separate disk drive letter if the original setup choices were customized. For example, the Msmdsrv.ini file may be located in one of the following folders.
    Collapse this tableExpand this table
    Product Location
    Microsoft SQL Server Analysis Services 2008%ProgramFiles%\Microsoft SQL Server\MSAS10.<Instance name>\OLAP\Config
    Microsoft SQL Server Analysis Services 2008 R2%ProgramFiles%\Microsoft SQL Server\MSAS10_50.<Instance name>\OLAP\Config
    Microsoft SQL Server Analysis Services 2012%ProgramFiles%\Microsoft SQL Server\MSAS11.<Instance name>\OLAP\Config
    Note The placeholder <Instance name> represents the instance name. By default, <Instance name> is MSSQLSERVER.
  3. Select the Msmdsrv.ini file.
  4. Edit the value in the tag for the property that needs adjustment.

    Notes
    • We recommend that you make a safe backup copy of the Msmdsrv.ini file before you edit the file.
    • Incorrect or unexpected values or XML tag entries in the Msmdsrv.ini file can cause the Analysis Services service not to start in the future. Therefore, you have to use caution when you edit the Msmdsrv.ini file.
    • Not all properties can be modified by using the configuration file. For example, security or collation settings can be changed only by using SQL Server Management Studio. In those cases, you will have to either use Workaround 1 or apply the hotfix.
  5. Save the file.

    Notes
    • If you receive an "Access Denied" error message, make sure that you are running Notepad as administrator.
    • Some properties may take affect without a restart of the Analysis Services service after approximately 30 seconds. However, other properties do require the service to be stopped and restarted to take effect.
    • For more information, please see the following topic in SQL Server Books Online:

      Configure Server Properties in Analysis Services (http://technet.microsoft.com/en-us/library/ms174556.aspx)

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Applies to
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Service Pack 1
  • Microsoft SQL Server 2012 Standard
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced KB2889492
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support