Azure / Azure/azure-quickstart-templates

Template sql-alwayson-md-mult-subnets-zones not deploying completely

Open
#4,807 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
14.9k
Forks
16.2k
Avg merge
6d 21h
Merged PRs (30d)
6

Description

[sql-alwayson-md-mult-subnets-zones](https://github.com/Azure/azure-quickstart-templates/tree/master/sql-alwayson-md-mult-subnets-zones)

### Issue Details
Trying to deploy a SQL cluster in AV zones.
VMs deploy correctly.
VM1 and VM2 deploy correctly and configure correctly (DSC).
VM0 doesn't deploy correctly and fails on DSC step. The DSC step times out and logs show an issue with a assembly loading.

###Logs
File: C:\WindowsAzure\Logs\Plugins\Microsoft.Powershell.DSC\2.76.0.0\DscExtensionHandler.0.20180622-063515
(FYI: this error appears multiple times)
```
VERBOSE: [2018-06-22 06:48:35Z] [VERBOSE] [wbsql-sql-0]:
[[xSqlLogin]AddDomainAdminAccountToSysadminServerRole] Error occured:
Error occured: 'Cannot find type
[Microsoft.SqlServer.Management.Common.ServerConnection]: verify that the
assembly containing this type is loaded.', failed after '13' times, retry for
'13' times
VERBOSE: [2018-06-22 06:48:35Z] Settings handler status to 'transitioning'
(C:\Packages\Plugins\Microsoft.Powershell.DSC\2.76.0.0\Status\0.status)
```

@wesback

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the sql-alwayson-md-mult-subnets-zones template and the Microsoft.Powershell.DSC DscExtensionHandler log at C:\WindowsAzure\Logs\Plugins\Microsoft.Powershell.DSC\2.76.0.0. Reproduce the deployment and trace the xSqlLogin AddDomainAdminAccountToSysadminServerRole step on VM0, focusing on the missing ServerConnection assembly. Done means VM0 completes DSC and the SQL cluster deploys successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, powershell, sql
Domain
cloud, databases, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.