Suppress application compatibility warning for silent install of Microsoft SQL Server 2005

On performing an installation of Microsoft SQL Server 2005, I was prompted with the application compatibility warning for both Microsoft SQL Server 2005 and Visual Studio 2005, which required user input in order to proceed.

In order to suppress the application compatibility warning for both the above applications I was required to modify the registry for the Program Compatibility Assistant and add the GUID for each application.

I obtained the GUID for each application by downloading and installing the Microsoft Application Compatibility Toolkit (http://www.microsoft.com/download/en/details.aspx?id=7352).

To determine the GUID from the Microsoft Application Compatibility Toolkit you will need to perform the following steps:

1) Collapse the System Databases node.

2) Collapse the Applications node:

3) Browse the list of applications until you find the name of your application to which you require to suppress the application compatibility warning (in this case Microsoft SQL Server 2005 and Visual Studio 2005).

4) Browse to the name of the file (in the case of Microsoft SQL Server 2005 this is setup.exe and for Visual Studio 2005 this is devenv.exe)

5) Right click the file and select Disable Entry this will create the registry key required to suppress the application compatibility warning in the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags

In this example I obtained the following GUID to enable the silent install of Microsoft SQL Server 2005 whilst suppressing the application compatibility warning as illustrated in the screenshot below:

Microsoft SQL Server 2005 (setup.exe) – {3d06c673-5e8a-41c0-b47f-3c3ca0a22e67}

Vistual Studio 2005 (devenv..exe) – {5f66dbae-cad3-468a-83d0-77ace8abc1f6}

 

 

 

 

 

 

 

Advertisements

2 thoughts on “Suppress application compatibility warning for silent install of Microsoft SQL Server 2005

  1. Wonderful. I read in some other blogs about this registry update. But the value you gave differs from what others gave. They mentioned 0x00000004 instead of that last 77. Can you explain?. More over i have 64 bit Win 7 machine and what are all the locations where i need to update? please explain.

    Like

    1. From my understanding the value data (hexadecimal) ’77’ disables the application compatibility notification and ‘0’ enables this.

      The registry entries have been created automatically using the Microsoft Application Compatibility Toolkit and have been created/imported on a Windows 2008 R2 (64-bit) operating system.

      Below is the only registry entries you would need to include:

      [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags]

      “{3d06c673-5e8a-41c0-b47f-3c3ca0a22e67}”=dword:00000077
      “{5f66dbae-cad3-468a-83d0-77ace8abc1f6}”=dword:00000077

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s