Today when I tried to install the Adventure works database from AdventureWorks2008R2_SR1.exe file which is available in codeplex , I got the following error.
Error:
“A fatal error occurred during installation. Details:
Failed object initialization (ISupportInitialize.EndInit).An exception occured in SMO while trying to manage a service. Error at object ‘DatabaseSelection’ in markup file ‘DatabaseInstaller;component/databaseselection.xaml’ Line 78 Position 3.”
I tried checking with installation pre-requisites and found that following configurations/installations should be needed.
1 Installing Full-Text Search.
2 Enabling the SQL Full-text Filter Daemon Launcher Service.
3 Enabling FILESTREAM,
I found that SQL Full-text Filter Daemon Launcher Service is disabled. To enable this we need to work on the SQL Server configuration Manager. But when I tried to open the Configuration manager I faced one error which is shown below.
The solution was provided by the Microsoft in this link
The solution is simple,
1 Go to cmd
2 Change the directory of your instance \Microsoft SQL Server\100\shared
3 Type mofcomp “program files\Microsoft\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”
After completing the above step I was able to access the Configuration Manager. Then I changed the configuration of SQL Full-text Filter Daemon Launcher Service. The steps done are
- Select the SQL Server Services in the Left side, so we can see lot of configurations in the right side.
- Right click on the SQL Full-text Filter Daemon Launcher Service (Your Instance) and select properties and a new tab will be open up. Select the service option and change the start mode to Automatic.
Look at the below picture.
Jimmie Osborn
12 years agoIs there any way to import a database backup from 2005 into 2008 express edition. What I’ve had to resort to is doing a script the database, then import all the data through DTS. Whenever I tried to import straight from a backup file it says something about not being to import into a new version of sql server or I’ll get the below error.
Varun R
12 years agoYou can take a backup of 2005 database and restore it in 2008. Note express edition has limited features, if you are using hign end features like partitioning etc,u cant restore to express edition.But you can restore it to enterpreise or developer edition.
Kiran
12 years agoHi,
I have installed SQL Server 2008 R2 and SQL Server 2012. I am try to install AdventureWorks2008R2_SR1.exe, getting same problem as above mentioned.
I done procedure same as you specified above, but now also getting same error.
Please can you any suggestion.