Azure-初始化App Service应用程序创建错误！ [英] Azure - Initializing App Service app creation error!

问题描述

我正在关注在Azure中设置简单表的教程，但我得到初始化为'blahblahapp'的App Service应用程序时出错. 连接到SQL Server时出错(SQL错误代码40532)".我的连接字符串是:

数据源= tcp:blahblahapp.database.windows.net，1433;初始目录= blahblahapp_db;用户ID=[e-mail];密码= blahblahpassword.

我之前也遇到过类似的问题在遵循另一个教程时，我的SQL连接凭据是从连接字符串中复制的 但出现错误，无法使用用户名[e-mail]而不是给定的用户名进行连接，该用户名与我必须将myemail @ email.com @ database.azurewebsites.net输入的名称相同.我认为这可能是问题所在.

如何编辑给定的连接字符串天蓝色，所以它是 myemail @ email.com @ database .azurewebsites.net ?

解决方案

你好！

我相信你是正确的.出于好奇，您将数据库用户名配置为电子邮件地址-但未使用Active Directory身份验证-对吗?

我怀疑问题在于它正在查找第一个@，并认为该字符串已经是@DB名称.如果您仅使用不带@的用户名，则无需手动进行任何更改即可使用它.

I'm following a tutorial for setting up easy tables in Azure but I'm getting 'There was an error while initializing App Service app for 'blahblahapp'. 'Error connecting to SQL server (SQL error code 40532)'. my connection string is:

Data Source=tcp:blahblahapp.database.windows.net,1433;Initial Catalog=blahblahapp_db;User ID=[e-mail];Password=blahblahpassword. 

I've had a similar problem before while following another tutorial where my sql connection credentials were copied from the connection string but it came up with errors and would not connect using the username [e-mail] instead of the username given which was the same [e-mail] I had to put [e-mail]@database.azurewebsites.net so I'm thinking this could be the problem.

How do I edit the connection string given by azure so that it is [e-mail]@database.azurewebsites.net?

解决方案

Hello!

I believe you are correct. Out of curiosity, you configured your database username as an email address - but aren't using Active Directory authentication - correct?

I suspect the issue is that it's finding the first @ and believing that the string is already @DB name. If you use just a username without an @, it may work without having to change anything manually.

这篇关于Azure-初始化App Service应用程序创建错误！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！