Trouble installing Microsoft SQL Server 2008 R2 standard on Windows 7 64-bit
-
I am having trouble installing Microsoft SQL Server 2008 R2 standard on Windows 7 64-bit machine. I have Microsoft Visual Studio 2008 SP1 installed on my machine. I have successfully completed the steps until I reached the Installation Rules step where it says previous releases of Microsoft Visual Studio 2008 where I have installed Microsoft Visual Studio 2008 SP1 successfully.
I have Visual C++ 9.0 express edition also installed on my machine. The file path I have on my registry is below.
HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server\90
is there a method to bypass this step or find a way for the SQL Server 2008 R2 setup to accept that I have Visual Studio 2008 SP1 on my machine?
One question really not related to this post, how do I attach images using a file path which I have an image of my situation saved on my desktop?
-
You cannot attach using a file path. When you post, there is an "Attachments" option below the text box. Attach your image in there
-
Ok, I think I figured this out originally looked at the image button next to the page alignment buttons. Now I think I figured this out. The image below is a screenshot by what I mean with the installation rules not accepting that I have Visual Studio 2008 SP1 installed.
-
It’s known behaviour of SQL Server (Installer). To avoid this, I install SQL Server first then Visual Studio (if required). Few of my colleagues try to install it other way but didn’t succeed. Now it’s a best practice (documented) in our Development Environment.
-
I am trying to do a side-by-side installation which I currently have SQL Server 2005 on my computer with databases and I am trying to install SQL Server 2008 R2 which I need to copy the databases from SQL Server 2005 to SQL Server 2008 R2. My web hosting provider uses SQL Server 2008 which I can't transfer information from SQL Server 2005. I need some way of getting past the installation rules step in the installer which I have VS 2008 SP1 successfully installed.
-
tiger6425 (1/14/2012)
Ok, I think I figured this out originally looked at the image button next to the page alignment buttons. Now I think I figured this out. The image below is a screenshot by what I mean with the installation rules not accepting that I have Visual Studio 2008 SP1 installed.edit: the problem appears to be the C++ Express: see http://www.brianpeek.com/post/2008/08/13/sql-server-2008-visual-studio-sp1-and-visual-studio-express.aspx
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
You can also skip the rule using setup from the command line, like:
Setup /ACTION=install /SkipRules=VSShellInstalledRule...but that's not a documented or supported option, so for peace of mind I would try the C++ Express update first.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
Were you able to install SQL?
-
I installed the upgraded service pack for Microsoft visual C++ 2008 SP1 and still getting the same installer problem. The command prompt line that you sent me, how would you find where the proper directory is for the SQL install files?
This post:
uses a similar command line except instead of starting off with Setup they start with setup.exe
In my command prompt, my current directory is:
C:/Users/My Name
The three image files that show:
Installation Rules
Windows Explorer shows my installation media root directory
SQL Server installation center, installation media root directory
The three image files attached gives screenshots below
How would I be able to figure out the proper directory to put in the command line
Setup /ACTION=install /SkipRules=VSShellInstalledRule ?
-
I figured out how to use command prompt to bypass the installation rules that of the installer. I found where the install files are in Windows Explorer and click the down arrow next to the directory path I copied the narrow down path in the attached image.
Then I changed the directory command prompt which I use the line below:
cd C:\Temp\SQL Server 2008 R2 Standard (x86, x64, ia64) - DVD (English)
Which switch the directory to that path, thenI used the line from SQL Kiwi's post to bypass the installation rules step of the installer which worked like a charm.
Setup /ACTION=install /SkipRules=VSShellInstalledRule
You have to start the installer by entering the line above with but correct directory path changed to get the installer to work from command prompt.
I thank you so much for the help with this issue, because this was a tricky issue to figure out and I don't think I could've gotten over this without your help.
-
tiger6425 (1/27/2012)
I figured out how to use command prompt to bypass the installation rules that of the installer. I found where the install files are in Windows Explorer and click the down arrow next to the directory path I copied the narrow down path in the attached image.Then I changed the directory command prompt which I use the line below:
cd C:\Temp\SQL Server 2008 R2 Standard (x86, x64, ia64) - DVD (English)
Which switch the directory to that path, thenI used the line from SQL Kiwi's post to bypass the installation rules step of the installer which worked like a charm.
Setup /ACTION=install /SkipRules=VSShellInstalledRule
You have to start the installer by entering the line above with but correct directory path changed to get the installer to work from command prompt.
I thank you so much for the help with this issue, because this was a tricky issue to figure out and I don't think I could've gotten over this without your help.
Thank you for sharing. I'm sure this can be useful for other people.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply