Solved

SQL Server upgrade from 2005 to 2008

Posted on 2011-03-10
5
636 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help Required 3 110
While in ##Table - Help 4 19
Amazon RDS migrate to SQL Server 3 26
Need help in debugging a UDF results 7 29
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 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