无法连接到SQL Server数据库。

I'm trying to use the ASP.NET Web Site Administration Tool. When I click on the Security, I kept getting this message.

我在尝试使用ASP。NET网站管理工具。当我点击安全性时，我不断地收到这个消息。

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

您所选择的数据存储有一个问题。这可能是由无效的服务器名或凭据引起的，也可能是由于权限不足。它也可能是由于角色管理器特性未被启用而引起的。单击下面的按钮可重定向到可以选择新数据存储的页面。

The following message may help in diagnosing the problem:

以下信息可能有助于诊断问题:

Unable to connect to SQL Server database.

无法连接到SQL Server数据库。

First of, which SQL Server does this administration tool trying to connect too? How do I change the "Current User Name" to other user name? It's automatically used my Windows authentication logged on user name. If I can change this and the password, it might just work.

首先，这个管理工具还尝试连接哪个SQL服务器?如何将“当前用户名”更改为其他用户名?它自动使用我的Windows身份验证登录用户名。如果我可以更改这个和密码，它可能就会工作。

1 个解决方案

#1

Your web.config has a connection string. See this question for the full details on how to change that: ASP.NET Website Administration Tool: Unable to connect to SQL Server database

你的网络。配置有一个连接字符串。有关如何更改这一点的详细信息，请参见这个问题:ASP。NET网站管理工具:无法连接到SQL Server数据库