Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Sp3 and Window 2008

Author  Topic 

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:13:09
Hello:

I installed standard 2005 sqlserver at window 2008 server, and then apply sp3. I somehow made a mistake. How to install sp3, and then uninstall sqlserver 2005 at window 2008 server.

Your help is highly appreciated.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 18:14:21
You'll need to describe what mistake you made as I can't read your mind or see your computer.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:21:19
Dear Tara:

Thanks for the quick response. After apply sp3. The version of sqlserver should be 9.0.4035 but it showed 9.0.1037 something. I tried to uninstall sqlserver, then install sqlserver. It did not work. Should I install sp3 first, then uninstall sqlserver?

Thank you very much again!
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:22:56
Dear Tara:

Sorry for the typo. Should I uninstall sp3 first, then install sqlserver, then install sp3?

Thank you very much!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 18:23:34
Uninstalling SQL Server is not the solution. You probably are going to need to open a case with Microsoft PSS to fix this. You could try installing SP4 instead in case that resolves the issue. I'm currently working through SQL 2005 SP4 issues with MS PSS myself.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:31:13
Dear Tara:

I installed sql server 2005 then sp3 at window 2008 before. It worked. It is kind of urgent now. I need to finish it very soon. Can I try 0ne more time. How to uninstall sp3 on window 2008, then install sqlserver?

Thank you very much!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 18:33:44
Do not uninstall it. Download SP3 to the database server and install locally.

If this is urgent, then call Microsoft PSS for help.

It is pointless to install SP3 as it contains a critical security bug. Install SP4 and then the security hotfix for it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:36:33
Dear Tara:

Thanks but I already install sp3 at this sever window 2008 and I already uninstall sql server 2005. So, I just install sql serfer 2005 again?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 18:39:23
Yes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:50:35
Dear Tara:

From uninstall a programm, I did not see any sql server progam there, but once I click install sqlserver, it always showed:

Sql server component update will install the following components required for sql server setup:

microsoft native client
microsoft sql server 2005 setup support files.

I should get mssqlserver,but it did not.

Where I missed?

Thank you very much!


Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 18:51:21
Install those first.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 18:55:52
Dear Tara:

Thanks. I installed those first but it looks like sqlserver did not installed. From services, I did not see any sql server. I open managment studio, but could not connect this sql server.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 18:57:59
Tell me exactly how you are installing SQL Server. From a CD? Locally? What exactly are you clicking on?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-02-29 : 19:02:34
Dear Tara:

I got files from our network and copy to local c drive. I clicked setup file, then installed. The first time installation was fine. I can see sqlserver installed and got connected. Then I tried to uninstall it, install it again. I got this issues.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-29 : 19:19:26
I can't help. It is going to be too hard to go back and forth since I can't see your computer. Please call Microsoft PSS for assistance.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -