Discussions specific to the VMware vSphere hypervisor
Post Reply
pkelly_sts
Expert
Posts: 562
Liked: 61 times
Joined: Jun 13, 2013 10:08 am
Full Name: Paul Kelly
Contact:

Permissions/FW issues with SQL Restore

Post by pkelly_sts » Aug 16, 2017 10:02 am

[Case# 2281855]

I'm trying to complete a SQL restore to a VM that sits in a DMZ but hitting an issue with Admin$ share that I'm trying to resolve.

Basically I'm attempting to restore a DB from one instance on a dev server, to another DB (overwriting) on a 2nd instance on the exact same server.

The user account I'm specifying during the restore (which happens to be the same account we use for Veeam backups) is in local admins, UAC is disabled, it has sysadmin perms on the SQL server instance, but the error I'm getting is:

The network path was not found
(ERROR_BAD_NETPATH)
--tr:Error code: 0x00000035
--tr:Failed to create persisient connection to ADNIN$ shared folder on host [dest-ip-address]
--tr:Failed to install service [VeeamDeploySvc] was not installed on the host [dest-ip-address].

and this implies a filesystem/firewall permissions issue but my firewall guy can't see anything failing in the logs.

To verify this I can access \\dest-server\Admin$ from the B&R server just fine (so FW rules must be good?)

Any suggestions where to look next?
[New Sig: PLEASE get GFS tape support for incrementals!!!]

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Permissions/FW issues with SQL Restore

Post by foggy » Aug 17, 2017 4:45 pm

Hi Paul, you could try to install the package manually on the target machine.

pkelly_sts
Expert
Posts: 562
Liked: 61 times
Joined: Jun 13, 2013 10:08 am
Full Name: Paul Kelly
Contact:

Re: Permissions/FW issues with SQL Restore

Post by pkelly_sts » Aug 18, 2017 8:19 am

Which package please?
[New Sig: PLEASE get GFS tape support for incrementals!!!]

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Permissions/FW issues with SQL Restore

Post by foggy » Aug 18, 2017 11:51 am

You can find VeeamDeploymentDLL.dll and VeeamDeploymentSvc.exe files in C:\Program Files\Veeam\Backup and Replication\Backup\Packages on your backup server, copy them to C:\Windows\Veeam on the VM and run "VeeamDeploymentSvc.exe -install". Then check that the Veeam Installer Service is up and running and listening on port 6160.

pkelly_sts
Expert
Posts: 562
Liked: 61 times
Joined: Jun 13, 2013 10:08 am
Full Name: Paul Kelly
Contact:

Re: Permissions/FW issues with SQL Restore

Post by pkelly_sts » Aug 18, 2017 12:11 pm

Ah, gotcha. As it happens I had a response back from support just before lunch and it turns out that although i'd covered the docs on VBR firewall ports, I hadn't appreciated that there was another doc for the Veeam Explorers so will be sifting through that one working out what we're missing.
[New Sig: PLEASE get GFS tape support for incrementals!!!]

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Permissions/FW issues with SQL Restore

Post by foggy » Aug 18, 2017 12:12 pm

Right, there are some additional requirements for Explorers. Could play the role.

Post Reply

Who is online

Users browsing this forum: jcapone, JLundgren, seb002 and 26 guests