SQL Server连接字符串: Web托管服务提供的连接字符串似乎不正确
SQL Server连接字符串: Web托管服务提供的连接字符串似乎不正确
提问于 2012-08-14 21:12:36
我有一个带有SQL server2008 R2数据库的ASP.NET C#应用程序，该数据库具有合并的成员资格提供程序和应用程序数据库。我正在尝试根据虚拟主机服务提供商提供的说明修改我的网络配置，但我想我遗漏了一些东西。
下面是我当前的web.config连接字符串：
<connectionStrings>
<add name="RestaurantDB" connectionString="data source=SFP\SFP_SQL_SVR;attachdbfilename=C:\Users\Susan\Documents\Databases\Restaurants.mdf;Integrated Security=SSPI;"/>
<add name="RestaurantsEntities" connectionString="metadata=res://*/Restaurant.csdl|res://*/Restaurant.ssdl|res://*/Restaurant.msl;provider=System.Data.SqlClient;provider connection string="data source=SFP\SFP_SQL_SVR;attachdbfilename=C:\Users\Susan\Documents\Databases\Restaurants.mdf;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>这是虚拟主机服务给我的连接字符串：
Data Source=RESTAURANT.db.9319451.hostedresource.com; Initial Catalog=RESTAURANT; User ID=your username; Password='your password';如何根据上述情况修改我当前的连接字符串？提前谢谢。
回答 2
Stack Overflow用户
回答已采纳
发布于 2012-08-14 21:19:55
只需替换data source=SFP\SFP_SQL_SVR;attachdbfilename=C:\Users\Susan\Documents\Databases\Restaurants.mdf;Integrated Security=SSPI;
至
Data Source=RESTAURANT.db.9319451.hostedresource.com; Initial Catalog=RESTAURANT; User ID=your username; Password='your password';
像这样：
<add name="RestaurantDB" connectionString="data source=RESTAURANT.db.9319451.hostedresource.com;
Initial Catalog=RESTAURANT; User ID=your username; Password='your password'>
<add name="RestaurantsEntities" connectionString="metadata=res://*/Restaurant.csdl|res://*/Restaurant.ssdl|res://*/Restaurant.msl;
provider=System.Data.SqlClient;provider connection string="Data Source=RESTAURANT.db.9319451.hostedresource.com;
Initial Catalog=RESTAURANT; User ID=your username; Password='your password;
multipleactiveresultsets=True;App=EntityFramework""
providerName="System.Data.EntityClient" />Stack Overflow用户
发布于 2012-08-14 21:22:50
我不知道如何处理这件事，但我只是给你一个想法。尝试一下，可能会先这样修改您的RestaurantDB连接字符串
<add name="RestaurantDB" connectionString="RESTAURANT.db.9319451.hostedresource.com;Initial Catalog=RESTAURANT; User ID=your username; Password='your password';"/>像这样的RestaurantsEntities
<add name="RestaurantsEntities" connectionString="metadata=res://*/Restaurant.csdl|res://*/Restaurant.ssdl|res://*/Restaurant.msl;provider=System.Data.SqlClient;provider connection string="data source=RESTAURANT.db.9319451.hostedresource.com;Initial Catalog=RESTAURANT;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />如果上述方法不起作用，则还要在RestaurantsEntities连接字符串中添加UserID和Password
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/11953048
复制相关文章
相似问题
腾讯云开发者
