SQL server 2008 Release candidate
SQL server 2008 “Release Candidate 0” is released from Microsoft and very soon final version of SQL server 2008 will be released.
If you want to test it you should install it and test it so when final version will be released they will be ready for SQL server 2008.You can download the SQL server 2008 from following Location.
http://sqlserver.dlservice.microsoft.com/dl/download/7/A/2/7A2F6647-7110-479F-BAA2-CCFD5DA6F436/SQLFULL_ENU_x86.exe
For more information and technical detail please visit http://www.microsoft.com/sqlserver/2008/en/us/default.aspx.
For installing SQL server 2008 following software are pre-requisites for installing SQL server 2005. I have downloaded them and copied on local network here are location
MDAC(Microsoft data access controller)
Windows installer 4.5 required .
Dot.net framework 3.5 required.
SQL server 2008
Supported Operating Systems: Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista; Windows XP Service Pack 2
Hardware: For 32 bit version you need Pentium 3 with 1GB RAM recommended Pentium 4 with 2 GB RAM
For above all required component you can download them from bellow location.
http://sqlserver.dlservice.microsoft.com/dl/download/7/A/2/7A2F6647-7110-479F-BAA2-CCFD5DA6F436/SQLFULL_ENU_x86.exe (SQL server 2005)
http://www.microsoft.com/downloads/details.aspx?FamilyID=5a58b56f-60b6-4412-95b9-54d056d6f9f4&displaylang=en (Windows Installer)
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en&Hash=kwylJ4PWN4zbRbsq2GwGzkfTOBGOzhGXQwjfEWMwXPUak70xel1u%2bG0fRoS9ITkW%2fXVI5pM647ysHjoaKOAjug%3d%3d (MDAC 2.8)
http://download.microsoft.com/download/c/d/8/cd8aad12-bb3b-4f70-a3a1-e00b516011b0/dotnetfx35.exe (Dotnet framework 3.5 full installation it would not ask for downloading component form internet)
Before you use Microsoft Visual Studio with SQL Server 2008 RC0, install the following updates:
For Visual Studio 2005, install Visual Studio 2005 Support for SQL Server 2008 RC0.
For Visual Studio 2008, install Visual Studio 2008 Service Pack 1 Beta.
For Visual Studio 2008 with SQL Server 2008 RC0 Express, download and install Microsoft Visual Studio 2008 Express Edition with SP1 Beta .
You can install support for both Visual Studio 2005 and Visual Studio 2008.
I Hope this information was useful and beneficial for you
Dot.net Framework 3.5 offline installation
Someone in my office asked me to install dot net framework 3.5 and I said ok I will do that. I downloaded the “dot net framework 3.5” from Microsoft and started installation it was 6mb file so I thought it’s ok it won’t give any problem but when I started installation it said it need to download the rest of the setup and it will download some 60MB data. If its once in a while I could have allowed it but It was not a onetime setup so I looked for its offline solution and simply I got that.
This offline setup contains 32 bit and 64 bit both the version of dot net framework 3.5
You simply need to download this setup from here.
http://download.microsoft.com/download/6/0/f/60fc5854-3cb8-4892-b6db-bd4f42510f28/dotnetfx35.exe
alternatively you can download it from rapidshare that I uploaded
http://rapidshare.com/files/302663024/dotnetfx35.part1.rar
http://rapidshare.com/files/302665809/dotnetfx35.part2.rar
http://rapidshare.com/files/302670178/dotnetfx35.part3.rar
After download just run this setup it will extract the setup and then it will start the installation after few steps it will say it need to download the setup that is of some 60MB around don’t get panic . It’s not going to download that and simply click on next. It will pick required files from the extracted setup and in few second it will say its downloaded and you can disconnect from the internet.
Things to remember
1) You will need to close MS office applications so save them and then run it.
2) Dot.net framework complete package is of around 200 MB so make sure you really want to download this 200MB file.
3) Backing up your data is always a good idea.
