SQL资源提供程序部署失败 [英] SQL Resource provider deployment failed
问题描述
您好，
目前我正在部署SQL使用以下链接在Azure Stack POC中提供资源：
https://azure.microsoft.com/en-us/documentation/articles/azure-stack-sql-rp-deploy-long/
我是在客户端VM上运行"Upload-Microsoft.Sql-RP.ps1"脚本时面临以下问题，作为SQL Server资源提供程序部署的一部分。
PS D：\ SQLRP> D：\ SQLRP \ Prerequisites; \\ BlobStorage \ Upload-Microsoft.Sql-RP.ps1
cmdlet Upload-Microsoft.Sql-RP.ps1 at命令管道位置1
供应值以下参数：
（输入！？获取帮助。）
<跨度风格= "颜色：＃1F497D;背景：黄色"> AadTenantDirectoryName：anazurestack.onmicrosoft.com
<跨度风格="颜色：＃1F497D;背景：黄色"> VERBOSE：使用订阅：'默认提供商订阅'
VERBOSE ：上传文件......
来源：'D：\ SQLRP \ Prerequisites\BlobStorage \Container'
目的地：的 'https：//deploymentstore.blob.azurestack.local/microsoft-sql'
<跨度风格= "颜色：＃1F497D;背景：黄色">警告：将在以后的版本中修改此cmdlet中Tag参数的可用性。这将影响Azure资源的创建，更新和
支持标记。有关更改的更多详细信息，请访问
https://github.com/Azure/azure-powershell / issues / 72
6＃issuecomment-213545494
New-AzureRmResourceGroup：Operation返回无效的状态代码'BadRequest'
在D：\ SQLRP \ Prerequisites\BlobStorage\Upload-Microsoft.Sql-RP.ps1：58 char：22
+ ... urceGroup = New-AzureRmResourceGroup -Name $ resourceGroupName -Locati ...
<跨度风格= "颜色：＃1F497D;背景：黄色"> +&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~
+ CategoryInfo ：CloseError：（:) [New-AzureRmResourceGroup]，CloudException
+ FullyQualifiedErrorId：Microsoft.Azure.Commands.ResourceManager.Cmdlets.Implementation.NewAzureResourceGroupCmdlet
<跨度风格="颜色：＃ 1F497D;背景：黄色"> VERBOSE：资源组：
警告：用法此cmdlet中的Tags参数将在以后的版本中进行修改。这将影响Azure资源的创建，更新和消息
nding标记。有关更改的更多详细信息，请访问
https://github.com/Azure/azure -powershell / issues / 726＃i
ssuecomment-213545494
New-AzureRmStorageAccount：在api版本'2016的命名空间'Microsoft.Storage'中找不到资源类型01-01'。
在D：\ SQLRP \ Prerequisites; \\ BlobStorage \ Upload -Microsoft.Sql-RP.ps1：62 char：23
+ ... geAccount = New -AzureRmStorageAccount -ResourceGroupName $ resourceGro ...
<跨度风格= "颜色：＃1F497D;背景：黄色"> +&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~
+ CategoryInfo ：CloseError：（:) [New-AzureRmStorageAccount]，CloudException
+ FullyQualifiedErrorId：Microsoft.Azure.Commands.Management.Storage.NewAzureStorageAccountCommand
<跨度风格="颜色：＃1F497D;背景：黄色"> VERBOSE：存储帐户：
Get-AzureRmStorageAccountKey：资源组找不到'DeploymentLibrary'。
在D：\ SQLRP \ Prerequisites; \\ BlobStorage \ Upload-Microsoft.Sql-RP.ps1：65 char：27
+ ... countKeys = GET-AzureRmStorageAccountKey -ResourceGroupName $资源...
的 +&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~
+ CategoryInfo ：CloseError：（:) [Get-AzureRmStorageAccountKey]，CloudException
+ FullyQualifiedErrorId：Microsoft.Azure.Commands.Management.Storage.GetAzureStorageAccountKeyCommand
<跨度风格="颜色：＃1F497D;背景：黄色"> VERBOSE：存储帐户密钥：
VERBOSE：上传已完成。 （已用：00：00：00.4543756）
<跨度风格= "颜色：＃1F497D;背景：黄色">新-AzureStorageContext：不能参数验证参数"StorageAccountKey "。参数为null或空。提供
参数，该参数不为null或为空，然后再次尝试该命令。
在D：\ SQLRP \Prerequisites \BlobStorage \ Upload-Microsoft.Sql -RP.ps1：68字符：106
<跨度风格= "颜色：＃1F497D;背景：黄色"> + ... torageAccountName -StorageAccountKey $ storageAccountKeys.Key1 -Protoc ...
&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo ：InvalidData：（:) [新-AzureStorageContext]，ParentContainsErrorRecordException
<跨度风格= "颜色：＃1F497D;背景：黄色">&NBSP;&NBSP;&NBSP; + FullyQualifiedErrorId：ParameterArgumentValidationError，Microsoft.WindowsAzure.Commands.Storage.Common.Cmdlet.NewAzureStorage
<跨度风格="颜色：＃1F497D;背景：黄色"> 上下文
问候，Deepak
感谢您在此发帖！
请问您是否验证已安装Azure PowerShell版本是特定的到Azure Stack并链接了安装说明，
所有这些都只是按不同步骤列出：
来自：&bbsp;
https://azure.microsoft.com/en-us/documentation/articles/azure-stack-sqlrp-deploy/
确保你满足所有
在部署之前设置步骤 ：
- .NET 3.5框架已在基本Windows Server映像中设置（如果您下载了Azure堆栈2016年2月23日之后的位，您可以跳过此步骤）
- Azure-Stack兼容的PowerShell版本
- 在ClientVM上正确配置IE安全设置（ 关闭IE增强安全性并启用Cookie b ）
错误通常是因为客户端虚拟机上安装了Azure PowerShell的不兼容版本
。
问候，
与Pradeep
Hi,
Currently I am deploying SQL resource provide in Azure Stack POC using following link: https://azure.microsoft.com/en-us/documentation/articles/azure-stack-sql-rp-deploy-long/
I am facing below issue while running "Upload-Microsoft.Sql-RP.ps1" script on client VM as part of SQL Server resource provider deployment.
PS D:\SQLRP> D:\SQLRP\Prerequisites\BlobStorage\Upload-Microsoft.Sql-RP.ps1
cmdlet Upload-Microsoft.Sql-RP.ps1 at command pipeline position 1
Supply values for the following parameters:
(Type !? for Help.)
AadTenantDirectoryName: anazurestack.onmicrosoft.com
VERBOSE: Using subscription: 'Default Provider Subscription'
VERBOSE: Uploading files...
Source: 'D:\SQLRP\Prerequisites\BlobStorage\Container'
Destination: 'https://deploymentstore.blob.azurestack.local/microsoft-sql'
WARNING: The usability of Tag parameter in this cmdlet will be modified in a future release. This will impact creating, updating and a
ppending tags for Azure resources. For more details about the change, please visit https://github.com/Azure/azure-powershell/issues/72
6#issuecomment-213545494
New-AzureRmResourceGroup : Operation returned an invalid status code 'BadRequest'
At D:\SQLRP\Prerequisites\BlobStorage\Upload-Microsoft.Sql-RP.ps1:58 char:22
+ ... urceGroup = New-AzureRmResourceGroup -Name $resourceGroupName -Locati ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : CloseError: (:) [New-AzureRmResourceGroup], CloudException
+ FullyQualifiedErrorId : Microsoft.Azure.Commands.ResourceManager.Cmdlets.Implementation.NewAzureResourceGroupCmdlet
VERBOSE: Resource Group:
WARNING: The usage of Tags parameter in this cmdlet will be modified in a future release. This will impact creating, updating and appe
nding tags for Azure resources. For more details about the change, please visit https://github.com/Azure/azure-powershell/issues/726#i
ssuecomment-213545494
New-AzureRmStorageAccount : The resource type could not be found in the namespace 'Microsoft.Storage' for api version '2016-01-01'.
At D:\SQLRP\Prerequisites\BlobStorage\Upload-Microsoft.Sql-RP.ps1:62 char:23
+ ... geAccount = New-AzureRmStorageAccount -ResourceGroupName $resourceGro ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : CloseError: (:) [New-AzureRmStorageAccount], CloudException
+ FullyQualifiedErrorId : Microsoft.Azure.Commands.Management.Storage.NewAzureStorageAccountCommand
VERBOSE: Storage account:
Get-AzureRmStorageAccountKey : Resource group 'DeploymentLibrary' could not be found.
At D:\SQLRP\Prerequisites\BlobStorage\Upload-Microsoft.Sql-RP.ps1:65 char:27
+ ... countKeys = Get-AzureRmStorageAccountKey -ResourceGroupName $resource ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : CloseError: (:) [Get-AzureRmStorageAccountKey], CloudException
+ FullyQualifiedErrorId : Microsoft.Azure.Commands.Management.Storage.GetAzureStorageAccountKeyCommand
VERBOSE: Storage account keys:
VERBOSE: Upload completed. (Elapsed: 00:00:00.4543756)
New-AzureStorageContext : Cannot validate argument on parameter 'StorageAccountKey'. The argument is null or empty. Provide an
argument that is not null or empty, and then try the command again.
At D:\SQLRP\Prerequisites\BlobStorage\Upload-Microsoft.Sql-RP.ps1:68 char:106
+ ... torageAccountName -StorageAccountKey $storageAccountKeys.Key1 -Protoc ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [New-AzureStorageContext], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.WindowsAzure.Commands.Storage.Common.Cmdlet.NewAzureStorage
Context
Regards, Deepak
Thank you for posting here!
Could you please verify that installed the Azure PowerShell release that is specific to Azure Stack and linked off of the install instructions, all of them have it listed just in different steps:
From: https://azure.microsoft.com/en-us/documentation/articles/azure-stack-sqlrp-deploy/
Make sure you fulfill all set up steps before you deploy:
- .NET 3.5 framework already set up in the base Windows Server image (if you downloaded the Azure Stack bits after 2/23/2016, you can skip this step)
- Azure-Stack-Compatible PowerShell release
- IE security settings configured properly on the ClientVM (Turn off IE enhanced security and enable cookies)
The error is typically because an incompatible version of the Azure PowerShell is installed on the client VM.
Regards,
Pradeep
这篇关于SQL资源提供程序部署失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
