Data Backup and Recovery

Creating iSCSI initiators on a vfiler used by sql server snapmanager

jbq
6,516 Views

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 🙂

1 ACCEPTED SOLUTION

jbq
5,579 Views

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.

View solution in original post

12 REPLIES 12

aborzenkov
6,467 Views

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.

scottgelb
6,467 Views

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

jbq
6,467 Views

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.

scottgelb
6,467 Views

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.

jbq
6,467 Views

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.

scottgelb
6,467 Views

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?

jbq
6,467 Views

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

scottgelb
5,530 Views

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

aborzenkov
6,467 Views

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

jbq
6,467 Views

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

aborzenkov
5,530 Views

It is not what I asked.

jbq
5,580 Views

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.

Public