Visual Studio and SQL Server on Windows 7 RC

Thu, 14 May 2009 21:48:51 Z

Visual Studio and SQL Server on Windows 7 RC

When attempting to install SQL Server 2008 RTM or SQL Server 2005 RTM/SP1/SP2 on Windows 7 RC, you will receive a warning dialog stating that SQL Server has known compatibility issues with this version of Windows. Since SQL Server is redistributed by Visual Studio, installations in which the user selects to install SQL Server along with Visual Studio will be affected. The issues that trigger the compatibility warning have been fixed in SQL Server 2008 SP1 and SQL Server 2005 SP3.

The recommended workaround is to install Visual Studio with SQL Server and then upgrade to SQL Server 2008 SP1 or SQL Server 2005 SP3 using Windows Update. You can also choose to install SQL Server 2008 SP1 before installing Visual Studio.

The steps below are shown for installing Visual Basic 2008 Express Edition with SP1 plus SQL Server 2008 on Windows 7 RC:

1. Download Microsoft Visual Basic 2008 Express Edition with SP1 from the Express download page.

2. During setup, make sure to select “Microsoft SQL Server 2008” from the “Optional Components” page.

3. As soon as SQL Server 2008 installation begins, you will receive a compatibility warning dialog.

4. Select Run Program to continue the installation.

5. You will then be presented with a second compatibility warning dialog when running “setup.exe”. Select Run Program again.

6. After installation has completed, launch Windows Update.

7. Select Check for updates in the left-hand pane.

8. Under the optional updates, you should see a checkbox for “Microsoft SQL Server 2008 Service Pack 1”.

9. If for some reason, you don’t see “Microsoft SQL Server 2008 Service Pack 1” listed as an optional update, please go here to download the service pack.

10. Check the box next to the entry and select OK.

11. Windows update will then install SQL Server 2008 SP1.

12. Once installation has completed, you may be prompted to reboot.

More Links/Information

Download SQL Server 2005 SP3

Download SQL Server 2008 SP1

If you’re installing SQL Server 2005 Express (any Express edition) or SQL Server 2008 Express (Runtime Only) you can just download the SQL Server Express package containing the latest service pack. This may seem counter-intuitive if you already have some Express package, but installing it and then downloading and applying service pack is going to take longer than downloading a package already containing the latest service pack and installing it. Plus, in case of SQL Server 2008 Express, the service pack package is actually bigger than the SQL Server Express package, since the service pack is shared with all SQL Server 2008 editions.

Download SQL Server 2008 Express SP1

Download SQL Server 2005 Express Edition SP3

Download SQL Server 2005 Express Advanced Edition SP3

Download SQL Server 2005 Express Toolkit Edition SP3

If need to install SQL Server 2008 Express edition other than Runtime Only on Windows 7 RC and need to avoid the warning dialogs, you can create SQL Server 2008 with Service Pack 1 package yourself. Please follow steps described by Peter Saddow here.

Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1

Remember to mark the best replies as answers!

Visual Studio and SQL Server on Windows 7 RC

Thu, 21 May 2009 18:27:12 Z

Thanks, I was afraid to try Windows 7 RC but I think this makes me brave enough to try it.   It just takes a few hours to do that whole installation thing and then backup my partition with CloneZilla .

What I am going to try is:

1. Install clean system of Windows 7 RC. Get all updates.
2.   Assuming .NET 3.5 is already installed on Windows 7:
          Install Visual Studio 2008 without SQL server option
3.   Reboot
4. If any SQL servers exists remove them .
5.   Remove any stray Program Files/SQL Server directories and reboot again.
6.    Install SQL 2008 Express
7.   run the aspnet_regsql.exe thingy
8.   Edit the machine.config file for Visual Studio so that it knows how to find the new SQL 2008.

<CONNECTIONSTRINGS>  
 <ADD name="LocalSqlServer" providerName="System.Data.SqlClient" connectionString=
"data source=LOCAL\SQLEXPRESS;Integrated Security=SSPI;database=aspnetdb" />  
</CONNECTIONSTRINGS>

9. Backup partition with CloneZilla

Visual Studio and SQL Server on Windows 7 RC

Tue, 26 May 2009 10:10:34 Z

Thank you for the guidance provided.

On Win7, a newer version of the .Net Framework is included as on my Visual Studio 2008 install dvd which doesn't have SP1 included.
Should I just install the full Visual Studio and let it do what it determines to install, and then apply SP1 on it afterwards?

Do you also have experience with installing Visual Studio 2005 on Win7? I read it will also prompt for compatability issues, is it an option to apply the Visual Studio 2005 SP1 update for Vista which is provided by MS?

Visual Studio and SQL Server on Windows 7 RC

Thu, 18 Jun 2009 19:56:58 Z

When I Installed VS 2008 professional edition on my win7 RC I am in a big trouble. Earlier when I use to install the trial version on XP or Vista than when I start to modify/Repair setup for VS2008 than I had a update option where I can fill in my VS2008 Pro edition Key which I bought online. This simply updates my VS2008 trial to VS2008 Pro Edition Full. Now When I try Modify/Repair setup I don't have such option. It don't show up update window and I can't fill in the key. I can't afford to download the full version due to my bandwidth issues. And even I tried installing VS2008 SP1 but still the same issue persists. Please Help me to get out of this trouble. This would definitely help a lot...

Visual Studio and SQL Server on Windows 7 RC

Tue, 30 Jun 2009 15:09:36 Z

I didnt have any trouble installing Visual studio 2008 on my Windows 7 box BUT installing the VS SP1 was definitely required. Also, I would recommend that you do steps #7 and #8 (from above) AFTER you installed the SP1. I didn't have any problems with unstalling the SQL Compact Edition either. Right now the ONLY SQL Server on my machine is the 2008 Express edition.

Visual Studio and SQL Server on Windows 7 RC

Sat, 04 Jul 2009 09:20:22 Z

I have exactly the same problem.. any progress?

Visual Studio and SQL Server on Windows 7 RC

Sun, 09 Aug 2009 22:46:48 Z

I've recently installed Windows 7 RTM (x64), Visual Studio 2008 and SQL Server 2008 (x64) on a new computer. I ran into some problems but fortunately the community has done some great work developing solutions.

After installing the OS and getting it to full Windows update compliance both SQL Server 2008 and Visual Studio 2008 failed to install. SQL Server 2008 failed to install because the setup check returns that a system restart is required because of a registry value that needs clearing prior to installing SQL Server. Once cleared the SQL Server 2008 install and SP1 update went smoothly and functions perfectly.

Here is how to do that:

Go to Start/All Programs/Accessories/Command Prompt and open as Administrator then type"regedit.exe" hit enter

Navigate to the following registry location in the left panel:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager

Open (double click) the PendingFileRenameOperations (aa type file listed on the right) and clear all values from the file. close the registry editor and do not restart your computer

Install SQL Server 2008 and reboot

Repeat the regedit process for the update to SQL Server 2008 SP1

Install the "en_sql_server_2008_sp1_x64.exe"

Installing Visual Studio 2008 on Windows 7 RTM (x64)

An issue with the Customer Experience Improvement Program (CEIP) client in Windows 7 RTM is causing Explorer and some MSI-based installers to stop working properly.

To solve this problem, follow these steps:

1.Click the Start button , click All Programs, and then click Accessories.

2.Right-click Command Prompt, and then click Run as administrator. In the User Account Control window, verify that Program name is Windows Command Processor, and then click Yes.

3.In the Administrator: Command Prompt window, type or paste the following text at the prompt:

reg delete HKLM\SOFTWARE\Microsoft\SQMClient\Windows\DisabledSessions /va /f

4.Press Enter to install the solution.

5.If The operation completed successfully displays, close the Administrator: Command Prompt window to complete this procedure. If "ERROR: Access is denied" displays, repeat this procedure from the top, making sure you clicked Run as administrator in step two.

Visual Studio and SQL Server on Windows 7 RC

Thu, 13 Aug 2009 18:22:00 Z

I've recently installed Windows 7 RTM (x64), Visual Studio 2008 and SQL Server 2008 (x64) on a new computer. I ran into some problems but fortunately the community has done some great work developing solutions.

After installing the OS and getting it to full Windows update compliance both SQL Server 2008 and Visual Studio 2008 failed to install. SQL Server 2008 failed to install because the setup check returns that a system restart is required because of a registry value that needs clearing prior to installing SQL Server. Once cleared the SQL Server 2008 install and SP1 update went smoothly and functions perfectly.

Here is how to do that:

Go to Start/All Programs/Accessories/Command Prompt and open as Administrator then type"regedit.exe" hit enter

Navigate to the following registry location in the left panel:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager

Open (double click) the PendingFileRenameOperations (aa type file listed on the right) and clear all values from the file. close the registry editor and do not restart your computer

Install SQL Server 2008 and reboot

Repeat the regedit process for the update to SQL Server 2008 SP1

Install the "en_sql_server_2008_sp1_x64.exe"

Installing Visual Studio 2008 on Windows 7 RTM (x64)

An issue with the Customer Experience Improvement Program (CEIP) client in Windows 7 RTM is causing Explorer and some MSI-based installers to stop working properly.

To solve this problem, follow these steps:

1.Click the Start button , click All Programs, and then click Accessories.

2.Right-click Command Prompt, and then click Run as administrator. In the User Account Control window, verify that Program name is Windows Command Processor, and then click Yes.

3.In the Administrator: Command Prompt window, type or paste the following text at the prompt:

reg delete HKLM\SOFTWARE\Microsoft\SQMClient\Windows\DisabledSessions /va /f

4.Press Enter to install the solution.

5.If The operation completed successfully displays, close the Administrator: Command Prompt window to complete this procedure. If "ERROR: Access is denied" displays, repeat this procedure from the top, making sure you clicked Run as administrator in step two.

Best Solution Ever!!!!

Visual Studio and SQL Server on Windows 7 RC

Thu, 27 Aug 2009 06:11:20 Z

I've recently installed Windows 7 RTM (x64), Visual Studio 2008 and SQL Server 2008 (x64) on a new computer. I ran into some problems but fortunately the community has done some great work developing solutions.

After installing the OS and getting it to full Windows update compliance both SQL Server 2008 and Visual Studio 2008 failed to install. SQL Server 2008 failed to install because the setup check returns that a system restart is required because of a registry value that needs clearing prior to installing SQL Server. Once cleared the SQL Server 2008 install and SP1 update went smoothly and functions perfectly.

In Windows 7 RTM x86 everything works out of the box, no registry tweaks needed

Visual Studio and SQL Server on Windows 7 RC

Sun, 30 Aug 2009 21:40:22 Z

Alternative is to use a command line to run the setup.

http://msdn.microsoft.com/en-us/library/ms144259.aspx

Visual Studio and SQL Server on Windows 7 RC

Tue, 06 Oct 2009 08:54:37 Z

Visual Studio and SQL Server on Windows 7 RC

When attempting to install SQL Server 2008 RTM or SQL Server 2005 RTM/SP1/SP2 on Windows 7 RC, you will receive a warning dialog stating that SQL Server has known compatibility issues with this version of Windows. Since SQL Server is redistributed by Visual Studio, installations in which the user selects to install SQL Server along with Visual Studio will be affected. The issues that trigger the compatibility warning have been fixed in SQL Server 2008 SP1 and SQL Server 2005 SP3.

The recommended workaround is to install Visual Studio with SQL Server and then upgrade to SQL Server 2008 SP1 or SQL Server 2005 SP3 using Windows Update. You can also choose to install SQL Server 2008 SP1 before installing Visual Studio.

The steps below are shown for installing Visual Basic 2008 Express Edition with SP1 plus SQL Server 2008 on Windows 7 RC:

1.       Download Microsoft Visual Basic 2008 Express Edition with SP1 from the Express download page.

2.       During setup, make sure to select “Microsoft SQL Server 2008” from the “Optional Components” page.

3.       As soon as SQL Server 2008 installation begins, you will receive a compatibility warning dialog.

4.       Select Run Program to continue the installation.

5.       You will then be presented with a second compatibility warning dialog when running “setup.exe”. Select Run Program again.

6.       After installation has completed, launch Windows Update.

7.       Select Check for updates in the left-hand pane.

8.       Under the optional updates, you should see a checkbox for “Microsoft SQL Server 2008 Service Pack 1”.

9.       If for some reason, you don’t see “Microsoft SQL Server 2008 Service Pack 1” listed as an optional update, please go here to download the service pack.

10.   Check the box next to the entry and select OK.

11.   Windows update will then install SQL Server 2008 SP1.

12.   Once installation has completed, you may be prompted to reboot.

More Links/Information

Download SQL Server 2005 SP3

Download SQL Server 2008 SP1

If you’re installing SQL Server 2005 Express (any Express edition) or SQL Server 2008 Express (Runtime Only) you can just download the SQL Server Express package containing the latest service pack. This may seem counter-intuitive if you already have some Express package, but installing it and then downloading and applying service pack is going to take longer than downloading a package already containing the latest service pack and installing it. Plus, in case of SQL Server 2008 Express, the service pack package is actually bigger than the SQL Server Express package, since the service pack is shared with all SQL Server 2008 editions.

Download SQL Server 2008 Express SP1

Download SQL Server 2005 Express Edition SP3

Download SQL Server 2005 Express Advanced Edition SP3

Download SQL Server 2005 Express Toolkit Edition SP3

If need to install SQL Server 2008 Express edition other than Runtime Only on Windows 7 RC and need to avoid the warning dialogs, you can create SQL Server 2008 with Service Pack 1 package yourself. Please follow steps described by Peter Saddow here.

Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1

Remember to mark the best replies as answers!

Rahul Gupta |EMAIL REMOVED|

Visual Studio and SQL Server on Windows 7 RC

Fri, 06 Nov 2009 03:18:58 Z

I am just trying to install Visual Studio 2008 on a Windows 7 Ultimate x64 machine and tried the above and it didn't work for me. Does this work for installing Visual Studio 2008??