如何为Azure数据库建立正确的连接字符串? [英] How to set a proper connection string for Azure database?
问题描述
我有一个蔚蓝的网站和数据库。我localY坐标运行ASP.NET MVC 4 / EF 5应用程序,并试图把一些数据到Azure数据库之前部署的应用。但我有一个TargetInvocationException:{的ASP.NET简单的会员数据库无法初始化欲了解更多信息,请参阅的 http://go.microsoft.com/fwlink/?LinkId=256588 }
关键字不支持:服务器
这是在连接字符串,我从我的蔚蓝仪表盘获得:
<添加名称=myconstring的connectionString =服务器= TCP:myserver.database.windows.net 1433;数据库= MyDatabase的;用户ID = cdptest @ myserver的;密码= * *****; Trusted_Connection = FALSE;加密= TRUE;连接超时= 30;的providerName =System.Data.EntityClient/>
我尝试这样做我得到不支持关键字:数据源
<添加名称=myconstring的connectionString =数据源= myserver.database.windows.net; Initilal目录= MyDatabase的;用户ID = cdptest @ myserver的;密码= ** ***; Trusted_Connection = FALSE;加密= TRUE;连接超时= 30;的providerName =System.Data.EntityClient/>
对我来说,以下工作:
<添加名称=coupdpoAPEkowswAEntities的connectionString =服务器= TCP:myserver.database.windows.net,1433;数据库= MyDatabase的;用户ID = cdptest @ myserver的;密码= *****; Trusted_Connection = FALSE;加密= TRUE;连接超时= 30;的providerName =System.Data.EntityClient/>
使用服务器而不是数据源,并指定协议和端口号,和使用数据库,而不是初始目录
I have an azure website and database. I'm running an ASP.NET MVC 4 / EF 5 app localy and trying to put some data to the azure database before to deploy the app. But I have a TargetInvocationException : {"The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588"} Keyword not supported : server
This is the connection string that I get from my azure dashboard :
<add name="myconstring" connectionString=Server=tcp:myserver.database.windows.net,1433;Database=mydatabase;User ID=cdptest@myserver;Password=******;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.EntityClient" />
I tried this I got "Keyword not supported : data source"
<add name="myconstring" connectionString="Data Source=myserver.database.windows.net;Initilal Catalog=mydatabase;User ID=cdptest@myserver;Password=*****;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.EntityClient"/>
The following works for me:
<add name="coupdpoAPEkowswAEntities" connectionString="Server=tcp:myserver.database.windows.net,1433;Database=mydatabase;User ID=cdptest@myserver;Password=*****;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.EntityClient"/>
Use Server instead of Data Source, and specify the protocol and the port, and use Database instead of Initial Catalog
这篇关于如何为Azure数据库建立正确的连接字符串?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!