Permissions/FW issues with SQL Restore

VMware specific discussions

Permissions/FW issues with SQL Restore

Veeam Logoby pkelly_sts » Wed 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!!!]
pkelly_sts
Expert
 
Posts: 511
Liked: 55 times
Joined: Thu Jun 13, 2013 10:08 am
Full Name: Paul Kelly

Re: Permissions/FW issues with SQL Restore

Veeam Logoby foggy » Thu Aug 17, 2017 4:45 pm

Hi Paul, you could try to install the package manually on the target machine.
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Permissions/FW issues with SQL Restore

Veeam Logoby pkelly_sts » Fri Aug 18, 2017 8:19 am

Which package please?
[New Sig: PLEASE get GFS tape support for incrementals!!!]
pkelly_sts
Expert
 
Posts: 511
Liked: 55 times
Joined: Thu Jun 13, 2013 10:08 am
Full Name: Paul Kelly

Re: Permissions/FW issues with SQL Restore

Veeam Logoby foggy » Fri 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.
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Permissions/FW issues with SQL Restore

Veeam Logoby pkelly_sts » Fri 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!!!]
pkelly_sts
Expert
 
Posts: 511
Liked: 55 times
Joined: Thu Jun 13, 2013 10:08 am
Full Name: Paul Kelly

Re: Permissions/FW issues with SQL Restore

Veeam Logoby foggy » Fri Aug 18, 2017 12:12 pm

Right, there are some additional requirements for Explorers. Could play the role.
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 1 guest