SQL Server 2008 Management Studio functions incorrectly after you install SQL Server 2008 R2 Analysis Services

Article translations Article translations
Article ID: 982360 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You install Microsoft SQL Server 2008 Service Pack 1 (SP1) Analysis Services (SSAS 2008 SP1) and Microsoft SQL Server 2008 SP1 Management Studio (SSMS 2008 SP1) on a computer. Then, you install Microsoft SQL Server 2008 R2 Analysis Services (SSAS 2008 R2) on the same computer. In this situation, you encounter the following issues.

Issue 1

You open Connect Object Explorer in SSMS 2008 SP1. Then, you try to connect to a database engine server or to an SSAS server. However, you receive the following error message:
Method not found: 'Int32 Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomain.GetLogicalVersion()'. (ObjectExplorer)
Note When this issue occurs, you cannot use SSMS 2008 SP1 to connect to any versions of database engine or of SSAS. For example, you cannot use SSMS 2008 SP1 to connect to SQL Server 2005, to SQL Server 2008, or to SQL Server 2008 R2.

Issue 2

When you try to repair the Shared Tools installation, the Setup program crashes. Then, you receive the following error message:
The following error has occurred:

Internal call to CreateSKUCookie failed unexpectedly. Reinstalling SQL Support may resolve this issue.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xFD9B1CBB%25400x027BAD06%25401320%25404
Additionally, after the Setup program crashes, the status of the SQL Server Browser service is set to Disabled. In this situation, you cannot connect to a SQL Server named instance.

WORKAROUND

To work around these issues, install SQL Server 2008 R2 Management Studio.

STATUS

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

Properties

Article ID: 982360 - Last Review: September 17, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
kbexpertiseadvanced kbtshoot kbsurveynew kbprb KB982360

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com