Solved

SQL Server upgrade from 2005 to 2008

Posted on 2011-03-10
5
631 Views
Last Modified: 2016-02-15
I am trying to install the SQL Server development version on my laptop that currently has SQL Server 2005 installed. When I run the upgrade wizard and attempt to install I am informed that Analysis Services is not running and so the whole thing is dead in the water until I can get Analysis Services to run. When I go tot he SQL Server 2005 configuration manager and attempt to start Analysis Services it says it timed out and to read the error log. I need to get this done. How do I get Analysis Services to run?  I have pasted the last entry of the log below:


Message: The service cannot be started: The DOM parser failed to load and parse the stream. URL:'' Reason: 'Incorrect document syntax.
' Source:''. File position: 0. Line: 1. The DOM parser failed to load and parse the file '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\master.vmp'. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210000)
Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001
0
Comment
Question by:tomkovic
  • 2
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 total points
ID: 35108134
If this is just a development environment on your laptop, maybe it's more interesting (and cleaner) to uninstall the old version and install 2008 from scratch?
0
 
LVL 16

Assisted Solution

by:vdr1620
vdr1620 earned 250 total points
ID: 35109977
True as Valentino Suggests, it might be better to install a new copy instead of upgrade.. The error might be because of a bad installation and you might need to Remove SSAS using Add/ Remove Programs and try to add it during the upgrade.. Give it a try, might help
0
 

Author Comment

by:tomkovic
ID: 35111917
Will I  lose any data by doing this?
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 35112038
You will definitely need to Backup your databases and any Other SSIS/SSRS packages and Reports and Then restore them after installing SQL  Server 2008.. Also, once you restore them in 2008 you will not be able to restore it back on SQL 2005 ..they are not backward compatible.. This will apply even if you upgrade your SQL server without fresh installation
0
 

Author Comment

by:tomkovic
ID: 35113893
Will I be able to deploy databases from my laptop running SQL 2008  onto remote servers using SQL 2005?

I have web servers to deploy to. One runs 2005 the other runs 2008. Is there a way to work with both?
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now