SQL Server upgrade from 2005 to 2008
Posted on 2011-03-10
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