Go Premium for a chance to win a PS4. Enter to Win


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

Posted on 2010-11-14
Medium Priority
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 80

Accepted Solution

arnold earned 1000 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 80

Assisted Solution

arnold earned 1000 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\
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 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 1000 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
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…

963 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