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.
| Author |
Topic |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2008-01-29 : 17:39:52
|
| 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
452 Posts |
Posted - 2008-01-29 : 18:27:21
|
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. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-29 : 22:46:42
|
| You need check installation log file to find details. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-26 : 22:27:52
|
| 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 Mastergoselect @@versiongoIf it gives you 9.00.3042 it means SQL SP2 is installed in your system.ManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 22:54:43
|
| Which windows log file? |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-27 : 13:20:28
|
| Event viewer for an errorManojMCP, MCTS |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-27 : 13:26:00
|
| mdubey,Why are you answering the post which has already been answered? and dragging old posts ? |
|
|
|
|
|
|
failure on SP2 install