SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 failure on SP2 install
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chedderslam
Posting Yak Master

USA
221 Posts

Posted - 01/29/2008 :  17:39:52  Show Profile  Visit chedderslam's Homepage  Reply with Quote
I have a fresh install of MS SQL 2005 Developer Edition on my local box. I have just tried to install SP2 and the status reads "failure" for the product "Database Services", instance "MSSQLSERVER".

What could cause this? Do I need to turn of the service before applying the service pack? I supplied it the proper credentials which tested ok during the beginning of install...

Should I just try to install the patch again? How can I verify that the patch has been successfully applied?

Thanks for any help.

dewacorp.alliances
Constraint Violating Yak Guru

Australia
452 Posts

Posted - 01/29/2008 :  18:27:21  Show Profile  Visit dewacorp.alliances's Homepage  Click to see dewacorp.alliances's MSN Messenger address  Reply with Quote
quote:
What could cause this? Do I need to turn of the service before applying the service pack? I supplied it the proper credentials which tested ok during the beginning of install...



When you install this initially, it will ask you to confirm which services that need to be stop.

quote:

Should I just try to install the patch again? How can I verify that the patch has been successfully applied?



Run SELECT @@VERSION. If it's 9.00.3042, it means SP2.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/29/2008 :  22:46:42  Show Profile  Reply with Quote
You need check installation log file to find details.
Go to Top of Page

mdubey
Posting Yak Master

USA
133 Posts

Posted - 05/26/2008 :  22:27:52  Show Profile  Reply with Quote
Check the SQL log file and see any error on SQL logs as well as windows log file.

In the meantime you may also need to check in SQL server as well.

Use Master
go
select @@version
go

If it gives you 9.00.3042 it means SQL SP2 is installed in your system.

Manoj
MCP, MCTS
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 05/26/2008 :  22:54:43  Show Profile  Reply with Quote
Which windows log file?
Go to Top of Page

mdubey
Posting Yak Master

USA
133 Posts

Posted - 05/27/2008 :  13:20:28  Show Profile  Reply with Quote
Event viewer for an error

Manoj
MCP, MCTS
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/27/2008 :  13:26:00  Show Profile  Reply with Quote
mdubey,

Why are you answering the post which has already been answered? and dragging old posts ?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000