on 09-09-2010 1:25 PM
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
Hello,
Need to have SQL Server Management Studio installed on either system.
regards,
John Feely
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.