- Posts: 344
- Liked: 43 times
- Joined: Dec 14, 2015 9:42 pm
I've got a SQL server that I want to backup and truncate the logs. My problem is that the Hyper-V Host has one authentication, the VM client has another authentication, and the SQL Server has another authentication again.
I've spent the last hour trying to figure out how to set up a Hyper-V backup that can cater for this as B&R seems to only allow for two of the three? The "Guest OS Credentials" is for the Hyper-V Host as a whole (Domain\DomainAdmin), and under "Credentials..." I can set the login into the individual VMs which are not domain joined (ComputerName\Admin), but that still leaves the SQL database (SQLAdmin\AdminPassword).
You're probably thinking "Why not just create a SQL Admin with Windows Authentication?" Unfortunately we don't control the SQL database and making changes to the SQL database requires lots of hoops to jump through. Let's just say "it's political".
I could always set up a "Windows computer" backup, but then I need to buy another licence when this should just work as it is since it sits on our Hyper-V Host.
- Product Manager
- Posts: 6122
- Liked: 712 times
- Joined: Feb 08, 2013 3:08 pm
- Full Name: Mike Resseler
- Location: Belgium
I'm afraid that is not possible. We use VSS to do the work, and the only way we can do this is by using the account specified on the guest processing tab for that VM (which also needs login rights) or use the NT AUTHORITY\SYSTEM which we use as a failover system. However, that still means you need to give that NT AUTHORITY\SYSTEM the corresponding rights which it hasn't by default.
I'm afraid it will be "going through the loops" to get it configured.
- Posts: 495
- Liked: 127 times
- Joined: Aug 20, 2015 9:30 pm
Users browsing this forum: Bing [Bot] and 6 guests