Two shortcuts function incorrectly after you upgrade from SQL Server 2008 to SQL Server 2008 R2 CTPs or from SQL Server 2008 R2 CTPs to SQL Server 2008 R2 RTM

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

On This Page

SYMPTOMS

You experience the following issues in Microsoft SQL Server 2008 R2.

Issue 1

You upgrade Microsoft SQL Server 2008 to Microsoft SQL Server 2008 R2 CTP2 or to Microsoft SQL Server 2008 R2 CTP3. However, the following two shortcuts that are left behind do not work.

Shortcut 1
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2\Configuration Tools\SQL Server Error and Usage Reporting.lnk
Shortcut 2
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2\Performance Tools\Database Engine Tuning Advisor.lnk

Issue 2

You upgrade Microsoft SQL Server 2008 R2 CTP2 or Microsoft SQL Server 2008 R2 CTP3 to Microsoft SQL Server 2008 R2 RTM. However, the shortcuts that are described in the "Issue 1" section are removed.

CAUSE

These issues occur because a new component GUID must be generated for the component that creates the shortcut when the path of a shortcut is changed. In this situation, all shortcuts to Microsoft SQL Server 2008 R2 are changed in SQL Server 2008 R2 CTP2. However, the new component GUIDs are not generated.

WORKAROUND

To work around these issues, create the two shortcuts again. For example, use the following script to create shortcut 1:
Set WshShell = Wscript.CreateObject("Wscript.Shell")

Set oShellLink = WshShell.CreateShortcut("C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2\Configuration Tools\SQL Server Error and Usage Reporting.lnk")

oShellLink.TargetPath = """C:\Program Files\Microsoft SQL Server\100\Shared\SqlWtsn.exe"""

oShellLink.Save

Set oShellLink = Nothing

Notes
  • In this example, the following is the path for shortcut 1:
    C:\Program Files\Microsoft SQL Server\100\Shared\SqlWtsn.exe
  • You can use the following as a path for shortcut 2:
    C:\Program Files\Microsoft SQL Server\100\Tools\Binn\DTASHELL.EXE

STATUS

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

Properties

Article ID: 980495 - 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 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
kbfix kbexpertiseadvanced kbsurveynew KB980495

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