How do I install a Full version of SQL Server 2005 SP3 on a Windows 2008 Server Standard

Posted on 2010-11-14
Last Modified: 2012-06-27
I have been wanting to put the full series of service packs on a SQL Server 2005 install. I have not updated it to SP2 or SP3. I have it on a Windows Server 2008 64 bit Standard install with a copy of SQL Server 2008 no service packs installed.

I am trying to get both SQL installs on there. It is possible I have already checked that out. However I have not been able to get the full copy of SQL Server 2005 on there and wanted to get that done. Here is what is on the Server now. see image.

The second image shows the error I have been getting and I have not been able to update this on this machine. Does anyone know how to get this installed.? Any support is greatly appreciated. Thank you.
Question by:ruavol2
  • 3
  • 2
  • 2
LVL 77

Accepted Solution

arnold earned 250 total points
ID: 34131934
I'm not sure what the issue you are encountering, you have to either define an instance name or use a second IP on/to which this default instance will beind.

I.e. you have the sql 2008 installed as the default instance and you want to install sql 2005 using the default instance as well?
Add a second IP to the system and install sql 2005 bound to the second IP.

Author Comment

ID: 34132108
No I want both full installs for both SQLs using named instances nothing default. The default instance has not been used.

I have not been able to uninstall SQL 2008 and I have not been able to get2005 installed fully. I thought I could at least get a full install of 2005 SP3 then try again on installing named instances of SQL 2008.

How do I add a second IP to this system....?
LVL 77

Assisted Solution

arnold earned 250 total points
ID: 34132159
to add multiple IPs on a system: Network adapter properties, tcp/ip options/propterties \advanced\add you would have to use static IP assignment.

You may have to make sure you are not trying to install the 2005 sqlclient since a newer one is already installed.

What is the error that you get when you attempt the install, one other thing to note is that you need to alter the location where you store the data files as well as the location of the program files.i.e.
sql 2008 is in c:\program files\microsoft sql server\...
Install the 2005 in c:\program files\microsoft 2005 sql server\
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 250 total points
ID: 34134589
>> I have not been able to uninstall SQL 2008 and I have not been able to get2005 installed fully. I thought I could at least get a full install of 2005 SP3 then try again on installing named instances of SQL 2008.

Since you have Windows Server 2008 with you, you would get Compatibility issues when you try to install SQL Server 2005. However it is a warning and you can proceed installing SQL Server 2005 and SQL Server 2005 would work fully only after you apply SP3 for SQL Server 2005.

In the meanwhile, you can also install SQL Server 2008 along with SP1 in Windows Server 2008.

From the snapshot posted above, it seems like you have

1. SQL Server 2005 Express instance named TIMEFORCE with SSMSE.
2. SQL Server 2008 R2 instance in your machine

Existence of SQL Server 2005 Express instance would impact your installation, since you need to remove Client tools of both SQL Server 2005 Express to proceed installing SQL Server 2005 Full version (Client tools).
Kindly let me know if I need to explain anything in more detail.

Author Comment

ID: 34168046
This is what failed when I tried to install SQL Server 2008 on my 11th attempt.
Any thoughts on what is happening. Is there any sure way to remove. I would think there would be an absolute way to do this without having to go outside the scope of Microsoft.

I am in the Administrator Group with Full Control. I am not the Administrator.
I am going to try this next. I am trying to get the actual Administrators login access. I am not convinced this is the case. But I am open to trying. Any thoughts on why this refuses to uninstall for me an administrator........?
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 250 total points
ID: 34169835
Use this Windows Installer Cleanup utility to remove all residues of SQL Server 2008 in your machine.

Or else you can manually uninstall SQL Server 2008 from your machine using the below link.

Author Closing Comment

ID: 34263217
I got it done and this information was definitely helpful thank you.

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question