asp.net 如何配置RDS示例的连接字符串(MSSQLServer Express)

cbwuti44 于 2023-03-13 发布在 .NET

关注(0)|答案(1)|浏览(147)

我已经使用Managment Studio从我的PC连接到我的示例RDS（MSSQL Server Express），没有问题，因为我已经配置了策略组和其他东西。
我的“简单”问题是，当我尝试从我的WebApp连接时，我有一个web.config，这是我在ASP.NETMVC5项目中的配置...非常简单：
您能帮助我正确配置连接字符串吗？
谢谢！

<add name="Entities" connectionString="metadata=res://*/Business.Interactive.Model.csdl|res://*/Business.Interactive.Model.ssdl|res://*/Business.Interactive.Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=aa1XXXXXXXXXbi.cruXXXXXXym4.eu-west-1.rds.amazonaws.com:1433;Database=Business.interactive.gci;User Id=userroot;
Password=XXXXXXXX;pooling=False;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
<add name="myBusinessContext" connectionString="Data Source=aa1XXXXXXXXXbi.cruXXXXXXym4.eu-west-1.rds.amazonaws.com:1433;Database=Business.interactive.gci;User Id=userroot;
Password=XXXXXXXX;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

asp.net

来源：https://stackoverflow.com/questions/24647129/how-to-configure-connection-string-to-rds-instance-mssqlserver-express

1条答案

按热度按时间

vwoqyblh1#

好的，问题是数据库名称的长度，我还必须删除端口号：
最后：

<add name="Entities" connectionString="metadata=res://*/Business.Interactive.Model.csdl|res://*/Business.Interactive.Model.ssdl|res://*/Business.Interactive.Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=aa1XXXXXXXXXbi.cruXXXXXXym4.eu-west-1.rds.amazonaws.com;Database=Businessgci;User Id=userroot;
Password=XXXXXXXX;pooling=False;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
<add name="myBusinessContext" connectionString="Data Source=aa1XXXXXXXXXbi.cruXXXXXXym4.eu-west-1.rds.amazonaws.com;Database=Businessgci;User Id=userroot;
Password=XXXXXXXX;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

问候！！

赞(0）回复(0）举报 2023-03-13

我来回答

asp.net 如何配置RDS示例的连接字符串(MSSQLServer Express)

1条答案

相关问题

热门标签

最新问答