adventureworks failed object initialization

(8 posts) (4 voices)

Started 1 year ago by remni_rash
Latest reply from remni_rash

Activate e-mail notification in your profile settings to get updates. [Help ?]

Tags:

remni_rash
Member

Hi all,
recently i tried to install AdventureWorks2008R2_RTM on top of my SQL Server 2008 R2 instance, but i got the below error massage.

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.

Any suggestions.
Thanks in advance.

Posted 1 year ago #

davidkp
Member

Hi remni,
there are certain pre-requisites you need to check out before installing Adventureworks R2 sample database.
• Full-Text Search (install it while installing SQL Server 2008 R2).
• SQL Full-text Filter Daemon Launcher service must be running (Check out services.msc for this).
• FILESTREAM must be enabled (enable it in sp_configure if it is not) .

Good luck!

Posted 1 year ago #
remni_rash
Member

Hi david,
i m sure that i installed "Full-Text Search" while installing SQL Server 2008 R2.
and as you said i checked "SQL Full-text Filter Daemon Launcher service " is running on my system.

can you pls tell me how to enable filestream. I am not able to figure out.
Thanks in Advance

Posted 1 year ago #
davidkp
Member
Open management studio (SSMS), and in the query window, run the below code:
```
EXEC sp_configure filestream_access_level, 1
RECONFIGURE
```
Thats all , you are good to go :)
Posted 1 year ago #
vikash4all
Member

Hi all,
i too had the same problem once, But i resolved it the same way whatever david suggested. For more details, follow the link:
http://msftdbprodsamples.codeplex.com/wikipage?title=Database Prerequisites&referringTitle=Installing SQL Server 2008R2 Databases

-Vikash

Posted 1 year ago #
remni_rash
Member
Thank you all for your replies.
@david,
I tried all the steps that you suggested. But it seems is not sufficient to install Adventureworks DB on my system.
This time i tried to check for the service "SQL Full-text Filter Daemon Launcher service " on SQL Server Configuration Manager, but i got the below error:
```
"MMC could not create the snap in, the snap in might not have been installed
correctly.  Name:  SQL Server Configuration Manager."  Then it gives me a CLSID.
```
Any help pls!
Posted 1 year ago #
sqltech56
Member

Hi all,
If this problem is related to SQL Server 2008 R2 version, then i would suggest you all to go for REPAIR mode of SQL Server installation.

I guess after doing so much of installation and un-installation, some of the files in sql server got corrupted.
Better go for repair mode.
Start setup from SQL Server R2 software dump.
Select "Maintenance" and then click on "Repair" and proceed with further instructions.

I gurantee this will resolve both "Adventureworkds DB installation problem" and "SQL Server configuration manager missing" problem.

Posted 1 year ago #
remni_rash
Member

Hi sqltech56,
Thank you so much. I repaired my sql server instance by using REPAIR option from SQL Server installation wizard.
It really worked. After that i can see my SQL server configuration manager and even i can install adventure works sample db without any problems.

Thanks.

Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.