无法连接到memebrship数据库 [英] unable to connect to memebrship database

问题描述

亲爱的所有人;



问题如下： -



我有VS 2010&与VS 2010一起安装的SQL Express 2008.



问题是我安装了一个名为SQLEXP的命名实例并删除了默认的SQLEXPRESS实例。我在选项中更改了它 - >在VS2010中使用新实例工作正常我可以连接到数据库





但问题仍然出现在ASP.net网站上[创建]在实例更改之前]当运行用户无法登录时，服务器无法连接



错误-26无法连接到指定的实例;



为什么我在VS设置菜单中更改了[实例名称]时无法连接数据库。



我也可以提前使用网站管理工具创建存储在ASPNET.MDF中的用户，但现在它也无法连接到Web管理工具。任何解决方案都可以使用

Dear All;

The problem is as follows:-

I have VS 2010 & SQL Express 2008 which installed alongwith VS 2010.

The problem is I installed a named instance called SQLEXP & deleted default SQLEXPRESS instance .I changed it in Options -> in VS2010 to use new instance works fine I can connect to database


But still the problems appear in a ASP.net site [created before instance change] when run user cant login as server cant be connected

Error-26 Cannot connect to instance specified;

Why cant the database be connected when I changed it[instance name] in VS settings menu.

Also I could earlier use Website Admin Tool to create users which store in ASPNET.MDF but now it also cant connect in Web admin tool.Any solutions pls?

推荐答案

在连接字符串中更新您的DataSource。转到web.config - >找到您的连接字符串 - >将数据源从。\SQLEXPRESS 更新为 YourMachineName \SQLEXPRESS 。

试试这个：

Update your DataSource in connection string. Go to web.config --> Find your connection string --> Update data source from .\SQLEXPRESS to YourMachineName\SQLEXPRESS.
Try this:

connectionString="data source=YourMachineName\SQLEXPRESS;
   Integrated Security=SSPI;
   Initial Catalog=aspnetdb;" 

--Amit

--Amit

这篇关于无法连接到memebrship数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！