Control MSSQL via SAPMMC (CoCreateInstance failed: 80040154)

[tobias_ptz]

Hi,

we wanna use the extension Snap-ins for MS SQL Servers in SAPMMC.

http://help.sap.com/saphelp_nw70/helpdata/en/63/0f5bcabc3611d2890d0000e8200722/content.htm

The Snap-in is currently included to our SAPMMC, but if we run some DB-Task (right klick > DatabasehostSID > All Tasks > Start SQL Server) we're getting the following error:

CoCreateInstance failed: 80040154

Class not registered

The only information i found is this thread:

but this solution is not working for me!

We have on Database side:

- Windows Server 2008 Standard (SP2 / 64bit)

- SQL Server 2008 Enterprise (10.0.2531.0 / 64bit) (4 Databases)

on SAP AS side:

- Windows Server 2008 Standard (SP2 / 64bit)

- SAP ERP 6.0 / 6.04 (ECC)

- SQL Server 2008 Native Client (64bit) (sqlncli10.dll - 10.0.2531.0)

- Microsoft Management Console 3.0 (Version 6.0 Build 6002 SP 2)

So, all components are 64bit, why does the SAPMMC not works?

Any idea or solution?

Thanks and Regards.

Tobias

Edited by: Tobias Pätz on Sep 9, 2010 2:26 PM

[former_member189546]

Hello,

Need to have SQL Server Management Studio installed on either system.

regards,

John Feely

[tobias_ptz]

Hello,

well, i've installed the MS SQL Server 2008 incl. SP3 on the Applicationserver.

Now the DB and the AS have the SQL Server Management Studio in the same version.

But, i still get the same error message then before. And yes, i've done more then one restarts.

Over the Server Management Studio i can connect to the database, shutdown and startup the database.

Is there any extra service i have to register?

Regards,

Tobias

[Former Member]

I think you will have to use each tool separately. MMC for SAP Instance manipulation, and SQL Management Studio for the database. Microsoft moved away from MMC because it was too limited for the direction MS wanted this DBA tool to go.

[tobias_ptz]

Yes maybe, but why is SAP keep on saying you can use this feature to control the MSSQL DB in NW70?

And these tasks are not very heavy to handle it with the MMC:

Start SQL Server

Stop SQL Server

Generate SQL Scripts

Backup database

Restore database

Shrink database

http://help.sap.com/saphelp_nw70/helpdata/en/63/0f5bcabc3611d2890d0000e8200722/content.htm

[Former Member]

Unfortunately, I think that documentation is old.

Here is a quote from it:

"Its context menu lets you directly access the Enterprise Manager and perform a number of tasks..."

SQL Server hasn't used Enterprise Manager since SQL Server 2000, which utilized MMC.

SAP should update that doc...

[tobias_ptz]

That means the Server Management Studio is unequal the Enterprise Manager?

And there is no way to install this Enterprise Manager and use them on SAP AS side?

Thank you.

[Former Member]

I'm sorry I couldn't help...

[former_member189546]

Hello,

Starting with SAP 710 the MMC simply starts the SQL Server 2005

Management Studio.

The SAP MMC simply calls modules of the Enterprise

Manager. Since this software is not installed, it fails.

Need to use SQL Server Management Studio instead of the SAP

MMC for starting/stopping and administration of SQL Server.

regards,

John Feely

[tobias_ptz]

Hi,

does it mean, if we use a Distributed Installation, the included SQL functions in the MMC will not work?

If the AS and the DB are on the same host, this szenario will work?

Thanks and Regards,

Tobias

[Former Member]

Are you using this for remote administration of teh DB, or is this on the DB server?

I could not find an official answer from SAP's documentation, but I would think that functionality inside SAPMMC for a SQL 2008 Server would be limited. SQL Server no longer uses MMC (it hasn't used it since SQL Server 2005, when it moved to SQL Management Studio). SAPMMC is still, for the most part, the same product that was released with Windows Server 2000.

Perhaps someone else on here will have better information, though.

Hope this helps.

[tobias_ptz]

Hi Joey,

thanks for your answer.

We want to use it for a remote control of the DB (Distributed Installation).

Yes, i also found nothing about the SAPMMC and the SQL integration.

Strange, why is SAP keep integrating this options in the MMC?

Hope someone else have an idea?

Kind Regards!