October 18, 2009 at 6:14 pm
I would like to install the 64-bit developer edition of SQL Server 2005, on Windows 7. I'd also like to install Visual Studio 2008. Does the order in which I install them make a difference, or not?
Rod
October 19, 2009 at 2:51 am
I have not done this on Windows 7, but on Windows 2003 the sequence 1) SQL 2005, 2) Visual Studio 2008 worked. Mostly.
On a newly built OS, you should not have any trouble doing these installs. At my place we found that on boxes that had a history of lots of software installed and uninstalled, the upgrade to .Net 3.5 SP1 on top of .Net 2.0 for VS 2008 failed and could not be fixed, requiring a rebuild of the box.
It may be worth installing .Net 3.5 SP1 before you install SQL 2005. The .Net install will also install .Net 2.0 and SQL 2005 works happily with this install sequence.
After you have installed SQL 2005, you should also install SQL 2005 SP3 and VS 2005 SP1 before you install VS 2008. SQL 2005 SP3 is required for any use of SQL on Windows 2008 and above, and VS 2005 SP1 is required if you want to use the SQL 2005 tools on Windows 2008 or above.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 19, 2009 at 11:04 am
Would it be a good idea to go to the developer edition of SQL 2008 instead? (I would think it likely that SQL 2008 could read/process any .mdf and .ldf file from SQL 2005.) And if so, does it matter which gets install first or not?
Kindest Regards, Rod Connect with me on LinkedIn.
October 20, 2009 at 4:20 am
Persinally I would always use SQL 2008 unless there was a specific need to use SQL 2005. SQL 2008 can read and update databases created by SQL 2005.
I do not know if there is a specific order for installing SQL 2008 and VS 2008. I know I have installed SQL 2008 after VS 2008 and everything seems to work.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 20, 2009 at 9:05 pm
Does SQL Server 2008 come with its own version of SQL Server Reporting Services?
Rod
October 20, 2009 at 9:23 pm
Yes, it has SSRS.
The thing you want to be careful of with going 2008 is that some things you might work on, or try, will not work on 2005. Most everything on 2005 should be fine on 2008, but once you move databases to 2008, they cannot be moved back to a 2005 server.
October 21, 2009 at 9:09 am
Steve Jones - Editor (10/20/2009)
Yes, it has SSRS.The thing you want to be careful of with going 2008 is that some things you might work on, or try, will not work on 2005. Most everything on 2005 should be fine on 2008, but once you move databases to 2008, they cannot be moved back to a 2005 server.
That is very good to know, thank you, Steve!
Kindest Regards, Rod Connect with me on LinkedIn.
April 24, 2010 at 10:27 am
I was able to install SQL Server 2005 Standard on my machine by using the cmd prompt.
runas /user:administrator "msiexec /i C:\MyPath\SQL_2005_Std_x64\DISC1\Setup\SqlRun_SQL.msi"
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply