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 |
|
pamarths
Starting Member
5 Posts |
 Posted - 2009-06-06 : 08:53:23
|
| I trying to upgrade my SQL 2005 SP2 system to SP3 and Databases services is failing to upgrade with below error in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log file.Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Could not open distribution database distribution because it is offline or being recovered. Replication settings and system objects could not be upgraded. Be sure this database is available and run sp_vupgrade_replication again.. To continue, correct the problem, and then run SQL Server Setup again.Any help is appreciated.Thanks, |
|
|
pamarths
Starting Member
5 Posts |
Posted - 2009-06-06 : 09:05:45
|
| But when I checked the version after failed installation it is showing that build number of SP3.select @@versionMicrosoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-06-08 : 10:46:25
|
| Do you have any offline but not detached databases? |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-11 : 07:01:38
|
quote:
Originally posted by pamarths
I trying to upgrade my SQL 2005 SP2 system to SP3 and Databases services is failing to upgrade with below error in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log file.Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Could not open distribution database distribution because it is offline or being recovered. Replication settings and system objects could not be upgraded. Be sure this database is available and run sp_vupgrade_replication again.. To continue, correct the problem, and then run SQL Server Setup again.Any help is appreciated.Thanks,
Well....the error says that the instance has been upgraded but the distribution database is left, because it is offline or in a recovery process, and once available run the said stored proc to upgrade the replication settings..Regards,Ahmad Osama |
|
|
|
pamarths
Starting Member
5 Posts |
Posted - 2009-06-11 : 07:24:43
|
| I managed to make the distribution database up and ran SP3 setup again. It worked.Thanks,Sitaram |
|
|
|
|
|
|
SQL 2005 SP3 installation issues.