topic Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied in Data Protection

Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

it_1 — Wed, 02 Sep 2015 23:12:51 GMT

Hello @all,

i'm a little bit confused about the following error message in my environment.

1) 2 VMs (svtidbv057, svtidbv058)

2) Both running W2k8 R2 with SnapDrive 6.2 & SMSQL 5.0

3) Running configuration with Snapshots and Verification are working fine

4) local snapdrive User for SnapDrive and Mngmt with local administrator privileges

5) SnapManager Service running in a Active Directory User with local administrator privileges

So ....

We want now to clone a database from VM57 to VM58 by using a recently taken backup.

The task starts and all seems to fine unless ....

##########################################################################

[23:41:15.231] Connecting to SQL Server [svtidbv058] for restore SQL Server version checking...
[23:41:15.245] Mounting SnapInfo Drive...
[23:41:15.247] Mounting Snapshot [sqlinfo__svtidbv057__recent] for LUN E of Computer SVTIDBV057
[23:41:15.249] SnapManager will use directory C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint to mount snapshot sqlinfo__svtidbv057__recent.
[23:41:15.251] Mount point directory [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint]
[23:41:15.257] Snapshot will be mounted on subdirectory [MPDisk001]
[23:41:15.275] [SnapDrive Error]: Access is denied.

(SnapDrive Error Code: 0x80070005)
[23:41:15.277] Unable to mount the snapinfo directory snapshot
[23:41:15.279]
[23:41:15.281] *** SNAPMANAGER MOUNT BY RESTORE (CLONE) JOB ENDED AT: [02-08-2011 23.41.57]

[23:41:15.282] Error Code: 0x80070005
Access is denied.

##########################################################################

BUT!...

If i try to connect the snapshot via Snapdrive (Connect Disk on remote host svtidbv058) the mounting process starts and ends successfully.

I can access the recently connected disk.

There are some events shown on the remote system svtidbv058 (where the clone should be go online)

1) SnapDrive

#############

Failed to connect the LUN in Snapshot copy (sqlinfo__svtidbv057__recent) as drive on the computer (SVTIDBV058).

LUN Name = Not available

Storage Path = Not available

Protocol Type = LUN

Storage System Name =

Error code : Access is denied.

#############

Contains no LUN Name!

But Storage is connected an can see all luns with snapshots. (manually connect is working!)

2) SnapManager for SQL

#################

SnapManager for SQL Server database restore to alternate location, using a writable LUN that is backed by a snapshot, failed.

Error Code: 0x80070005

Access is denied

#################

Seems to be an error in the SnapDrive Communication.

But what can i do now?

Thanks for your help

BR Stefan

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

curtish — Tue, 08 Feb 2011 23:47:29 GMT

Have you checked the service accounts for SnapDrive and SMSQL on both systems?

Shat are they and do they access rights?

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

it_1 — Wed, 09 Feb 2011 07:51:56 GMT

Yes, i have already checked the service accounts für SnapDrive and SnapManager.

Both accounts have local administrator privileges.

Both systems (svtidbv057, svtidbv058) work locally without problems.

Only cloning to remote host cause the error.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

CHIBISUKE — Thu, 09 Aug 2012 05:42:33 GMT

Hi,

I've recently had the same problem as well.

To help out other ppl running into this:

If you're using two service accounts, you need to grant each of them admin rights on both maschines.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

Patrik — Mon, 01 Dec 2014 08:30:31 GMT

Hi,

I have similar problem, but probably not with permissions...

Clone to remote server is ending with this message.

[SERVERNAME] Error Code: 0xc004087c
Unable to find the snapinfo file from the mounted LUN in snapshot that contains the most recent snapinfo directory info
rmation.

After my investigation I've found, that problem is with Restore, because SnapInfo Directory is mounted with snapshot with older time.

Something like 4 days old, always.

SnapInfo Drive Created succesffully with such a time stamp.

----------------------------------------------------------------------------------------------------------------------------------------------------------

[SERVERNAME] Creating Snapshot of LUN/share(s):
[SERVERNAME] LUN [X]
[SERVERNAME] Snapshot name: sqlinfo__SERVERNAME_11-28-2014_14.32.03 – Created by SnapManager successfully…

[SERVERNAME] Starting SDAPI snapshot...
[SERVERNAME] Preparing LUN 'X:\', for SDAPI operation...
[SERVERNAME] Snapshot drive/share(s) successfully completed.
----------------------------------------------------------------------------------------------------------------------------------------------------------

But during restore to remote server ... SnapManager is trying to mount snapshot which is 4 days old....

----------------------------------------------------------------------------------------------------------------------------------------------------------

[REMOTESERVER] Restore Full Backup Set: 11-28-2014_14.32.03
[REMOTESERVER] Multiple Database Sharing Single Virtual Disk:

----------------------------------------------------------------------------------------------------------------------------------------------------------

[REMOTESERVER] Mounting Snapshot [sqlinfo__SOURCESERVER_11-24-2014_04.12.35__daily] for [X] of Computer [SOURCESERVER] – Why it is trying to connect snapshot from 24.11.2014???
[REMOTESERVER] SnapManager will use directory [C:\SMSQLMnPt] to mount snapshot [sqlinfo__SOURCESERVER_11-24-2014_04.12.35__daily]
[REMOTESERVER] Mount point directory [C:\SMSQLMnPt]
[REMOTESERVER] Snapshot will be mounted on directory [C:\SMSQLMnPt\MPDisk001]

[REMOTESERVER] Starting SDAPI mount snapshot...
[REMOTESERVER] Preparing LUN 'X:\', for SDAPI operation...
[REMOTESERVER] Mounting snapshot: sqlinfo__SOURCESERVER_11-24-2014_04.12.35__daily
[REMOTESERVER] Snapshot mount completed successfully.
[REMOTESERVER] C:\SMSQLMnPt\MPDisk001\
[REMOTESERVER] This Snapshot is mounted as LUN/share [C:\SMSQLMnPt\MPDisk001\].
[REMOTESERVER] Mount Snapshot succeeded.

[REMOTESERVER]
[REMOTESERVER] Unable to find the snapinfo file in the mounted drive/share:
[REMOTESERVER] C:\SMSQLMnPt\MPDisk001\SMSQL_SnapInfo\VDISK__D&E\FG__\11-28-2014_14.32.03\SnapInfo__11-28-2014_14.32.03.sml
[REMOTESERVER] Retrying...

Ofcourse it is unable to fund such a folder, when there is no such a folder in 4 days old snapshot ... 😞

----------------------------------------------------------------------------------------------------------------------------------------------------------

Anyone has any idea? Thx.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

AndyD — Mon, 01 Dec 2014 20:51:44 GMT

@Br Stefan - Please change the SnapDrive user account to a domain user account that has admin rights on both servers. I would also suggest an upgrade of both SDW and SMSQL, as those versions are quite old and out of support.

@patrick - What versions of SDW and SMSQL are you running? We are aware of an issue with SMSQL 7.0/7.1 that exhibits the exact behavior you are seeing. There is a patch release currently available that addresses this issue, so if you are running the SMSQL 7.x code line, please contact NetApp Support for assistance in obtaining the patch.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

Patrik — Tue, 02 Dec 2014 07:44:49 GMT

@ANDYD: SnapManager for SQL Server Version : 7.1.0.2024_140603_0415 and SnapDrive : 7.0.3

Windows 2008 R2 + SQL 2012

Security settings are same on both servers.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

AndyD — Tue, 02 Dec 2014 13:59:42 GMT

@Patrik - Yes, you are most likely a known bug in SMSQL (See bug report here: http://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=847188). Please contact NetApp Support for assistance in obtaining the SMSQL 7.1 patch release in order to resolve your issue.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

Patrik — Wed, 03 Dec 2014 09:57:08 GMT

Thx for your help, already contacted NetApp Support, waiting for reply.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

Patrik — Thu, 04 Dec 2014 12:40:22 GMT

My problem solved by updating SnapManager to version 7.1P1 🙂 Thx.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

AndyD — Thu, 04 Dec 2014 16:12:51 GMT

Oustanding! I am glad to hear you are up and running.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

elarin010 — Mon, 08 Dec 2014 15:22:01 GMT

I just deployed a new SQL 2014 and ran into this similar issue last week trying to perform a clone. SMSQL 7.1 always wants to mount the oldest snapshot no matter what backup set date/time I choose. Going to ask my storage manager to get P1 for me to see if it solves my issue too.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

elarin010 — Mon, 08 Dec 2014 20:22:43 GMT

Installing 7.1P1 didn't fix the issue of SMSQL incorrectly mounting the proper snapshot to restore from. Boo.....

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

lederman — Thu, 17 Dec 2015 23:18:13 GMT

Andy,

Are you saying you can't use SMSQL to clone to a remote host without having both servers in the domain? I'm working in a lab and have run into the same issue as @Br . I am running up to date versions of the NetApp software (SDW 7.1.2, SMSQL 7.2 on Server 2008R2 SP1 with SQLServer2008R2SP2).

I'm going to add them to a domain to see if that makes a difference.

Luke

@AndyD wrote:
@Br Stefan - Please change the SnapDrive user account to a domain user account that has admin rights on both servers. I would also suggest an upgrade of both SDW and SMSQL, as those versions are quite old and out of support.

@patrick - What versions of SDW and SMSQL are you running? We are aware of an issue with SMSQL 7.0/7.1 that exhibits the exact behavior you are seeing. There is a patch release currently available that addresses this issue, so if you are running the SMSQL 7.x code line, please contact NetApp Support for assistance in obtaining the patch.

Re: Problems with SMSQL Cloning to remote Host --> 0x80070005 Access is denied

lederman — Fri, 18 Dec 2015 01:04:02 GMT

@lederman wrote:
Andy,

Are you saying you can't use SMSQL to clone to a remote host without having both servers in the domain? I'm working in a lab and have run into the same issue as @Br . I am running up to date versions of the NetApp software (SDW 7.1.2, SMSQL 7.2 on Server 2008R2 SP1 with SQLServer2008R2SP2).

I'm going to add them to a domain to see if that makes a difference.

Luke
@AndyD wrote:
@Br Stefan - Please change the SnapDrive user account to a domain user account that has admin rights on both servers. I would also suggest an upgrade of both SDW and SMSQL, as those versions are quite old and out of support.

@patrick - What versions of SDW and SMSQL are you running? We are aware of an issue with SMSQL 7.0/7.1 that exhibits the exact behavior you are seeing. There is a patch release currently available that addresses this issue, so if you are running the SMSQL 7.x code line, please contact NetApp Support for assistance in obtaining the patch.
I can, in fact, confirm that using domain accounts solved my issue.

Thanks for the info!

Luke