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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 79

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 79

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\
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

615 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