tomkovic
asked on
SQL Server upgrade from 2005 to 2008
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\m aster.vmp' . (Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\ms mdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210000)
Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\ms mdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001
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\m
Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\ms
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
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?
I have web servers to deploy to. One runs 2005 the other runs 2008. Is there a way to work with both?
ASKER