Data Backup and Recovery

SnapManager for SQL server error

chetan_k32
5,033 Views

Hi All,

Recently we have installed the snapmanager for sql on one of our windows 2003 ent sp2 server with sql 2005 sp4 standered edition.

we have installed snapdrive 6.3.1 r1 and snapamanger version 5.1

snapdrive is configured on the server,for configuring snapmanager when we open the snapmanager console to add/spcify  the sql server we get following error message.

heading of the windows is "SnapManager for SQL Server"

error message :-

An error occurred while enumerating server
instances.details:Unable to cast COM object of type 'System_ComObject' to
interface type 'SmSqlDMOProvider.NameList'.This operation failed because the
QueryInterface call on the COM component for the interface with IID ‘{10022406-E260-11CF-AE68-00AA004A34DS}’failed
due to the following error:No such interface supported(Exception from
HRESULT:0x80004002(E_NOINERFACE)).

also find the attached screen shot for more clearfication.

Request all to send any break fixs for this issue.

thanks & regards

Chetan

7 REPLIES 7

spence
5,033 Views

Is this a MSCS or WSFC cluster?  If so, have you verified that all nodes have the same version of SnapDrive software?  See https://kb.netapp.com/support/index?page=content&id=2015570&actp=LIST_RECENT&viewlocale=en_US&searchid=1334757382980.

Also I strongly recommend you upgrade SMSQL to 5.1P2. http://support.netapp.com/NOW/download/software/snapmanager_sql2k/5.1P2/

chetan_k32
5,033 Views

No, host is not in cluster.

spence
5,033 Views

Can you launch SnapDrive, click disks and post that pic?

Also did you get the above error when launching SMSQL for the first time?

chetan_k32
5,033 Views

hi, i am able to lauch the snapdrive successfully,but when i launch smsql first time i got this error when i am trying to spcify sql server in smsql.

heading of the windows is "SnapManager for SQL Server"

error message :-

An error occurred while enumerating server
instances.details:Unable to cast COM object of type 'System_ComObject' to
interface type 'SmSqlDMOProvider.NameList'.This operation failed because the
QueryInterface call on the COM component for the interface with IID ‘{10022406-E260-11CF-AE68-00AA004A34DS}’failed
due to the following error:No such interface supported(Exception from
HRESULT:0x80004002(E_NOINERFACE)).

spence
5,033 Views

Does the account that the SnapManager for SQL service is using have a SQL login that is mapped to the sysadmin role?

chetan_k32
5,033 Views

all necessary prerequistes have been take care,the account has a local admin and sysadmin role in sql server.

spence
5,033 Views

You state that you have met all prerequisits and have not posted any coresponding Windows events from event viewer.  The error strings and codes in what you have shared do not return any results in searches.  You might want to call NetApp support at this point.

Public