You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

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

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: 09/17/2011 08:28:00 - Revision: 2.0

  • 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
  • kbexpertiseadvanced kbtshoot kbsurveynew kbprb KB982360
Feedback