topic Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager in Data Protection

Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq — Thu, 05 Jun 2025 06:27:37 GMT

We just upgraded to ontap 8 on our FAS3240, and are now using vfilers.

I ran in a problem today when I created a new sql server, and wanted to use some volumes on the fas3240.

I created the volumes in the oncommand system mananger.

In putty, I changed the vfiler context to the vfiler where the volumes are placed, and created an igroup to the iscsi initiator name on the sql server.

Now I would like to establish a connection with snapdrive using iSCSI management on the sql server, but the vfiler interface with the iSCSI on the fas3240 are not showing up , only the default interface on the fas3240.

I would like to establish a connection to the vfiler with the iSCSI protocol.

What configuration am I missing ? Do I have to add the igroup to some port ?

When I try to create a disk I'm notified that there is no iSCSI connection to the specified system, so I can see the qtree I've created.

Help would be very much appreciated 🙂

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

aborzenkov — Wed, 09 May 2012 12:34:43 GMT

You have to connect to vfiler you created, not to vfiler0 (physical system). From SnapDrive point of view each vfiler is separate filer which has to be added separately to SnapDrive.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

scottgelb — Wed, 09 May 2012 12:35:18 GMT

Inside the vFiler is options httpd.admin.enabled on?

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq — Wed, 09 May 2012 12:48:27 GMT

I've added the igroup in the correct vfiler context. I can see the other igroups created for the other sql servers using storage on the vfiler.

The httpd must be enabled because the other sql servers are up and running with access to the fas3240 volumes.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

scottgelb — Wed, 09 May 2012 12:52:18 GMT

Can snapdrive create a new small trst drive in the vFiler? It will create an igroup And Lun. If other servers can see Luns in the vFiler it must be network or something on this one specific host.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq — Wed, 09 May 2012 12:57:38 GMT

No when I create a disk with snapdrive I'm notified by the wizard that I have to create an new iSCSI connection to the storage system. So I can't create a disk.

I can ping the vfiler iSCSI interface, but it is not showing up when I try to create a new iSCSI connection.

There is no access list on the vfiler, but it looks like i'm missing the membership of a group or something like that.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

scottgelb — Wed, 09 May 2012 13:02:27 GMT

Can you create the new session when it gives the message? Or go to the iscsi app separately and connect to port 3260 to the vFiler ip?

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

aborzenkov — Wed, 09 May 2012 13:07:25 GMT

Please show full output of “sdcli igroup list -f vfiler-IP” where vfiler-IP - IP address of vfiler you created.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq — Thu, 10 May 2012 08:08:06 GMT

No the wizard insist that I have to create a session, to create a disk. And I can't create a disk manually.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq — Thu, 10 May 2012 08:12:31 GMT

vf_ISCSI105@fasdc02> igroup show

sv-sqls-007 (iSCSI) (ostype: windows):

iqn.1991-05.com.microsoft:sv-sqls-007.systematicgroup.local (logged in on: ig_10gportA-105)

viaRPC.iqn.1991-05.com.microsoft:sv-sqls-001.systematicgroup.local (iSCSI) (ostype: windows):

iqn.1991-05.com.microsoft:sv-sqls-001.systematicgroup.local (logged in on: ig_10gportA-105)

viaRPC.iqn.1991-05.com.microsoft:sv-sqls-002.systematicgroup.local (iSCSI) (ostype: windows):

iqn.1991-05.com.microsoft:sv-sqls-002.systematicgroup.local (logged in on: ig_10gportA-105)

viaRPC.iqn.1991-05.com.microsoft:sv-sqls-003.systematicgroup.local (iSCSI) (ostype: windows):

iqn.1991-05.com.microsoft:sv-sqls-003.systematicgroup.local (logged in on: ig_10gportA-105)

viaRPC.iqn.1991-05.com.microsoft:sv-sqls-004.systematicgroup.local (iSCSI) (ostype: windows):

iqn.1991-05.com.microsoft:sv-sqls-004.systematicgroup.local (logged in on: ig_10gportA-105)

vf_ISCSI105@fasdc02>

It is the igroup sv-sqls-007 I got a problem connecting to from the sql server

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

aborzenkov — Thu, 10 May 2012 08:25:44 GMT

It is not what I asked.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

scottgelb — Thu, 10 May 2012 08:41:20 GMT

Can you create a session from the iscsi initiator? Compare to other servers that are working.

Re: Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq — Thu, 10 May 2012 10:02:51 GMT

I found out what the problem was, I hadn't assigned the volume to the vfiler "vfiler add vf_ISCSI105 /vol/vol_H_vfISCSI105_SQLS_sys_05"

Thankyou for your help.