ASP.Net 会员 SQL Server
我刚刚在测试服务器上运行了 aspnet_regsql 工具并设置了 aspnetdb。我已经在 web.config 中设置了会员资格内容，并尝试通过 Visual Studio 2008 中的“项目 -> ASP.net 配置”菜单项来管理它。
前几页显示得很好 - 默认值页面和安全页面。它显示我有 0 个用户和 0 个角色。我可以单击“启用角色管理器”或它所说的任何内容。在我的连接字符串中，我以 sa 用户身份进行连接。
当我单击“创建或管理角色”时，出现错误：“建立与 SQL Server 的连接时发生网络相关或特定于实例的错误。找不到服务器或无法访问服务器。”等等，关于如何无法访问服务器。
好吧，我认为它能够访问服务器，因为它显示我有 0 个用户和角色。如果无法到达那里，根据过去的经验，它会显示空白而不是0。
我知道SQL中安装了许多存储过程和函数来支持成员资格，所以sa用户是否有可能没有执行这些事情的权利？我该如何检查？我真的不擅长 SQL 安全性，正如我使用 SA 用户名和密码所证明的那样。
有什么想法吗？
I've just run the aspnet_regsql tool and setup aspnetdb on a test server. I've setup the Membership stuff in web.config, and I'm trying to administer it via "Project -> ASP.net Configuration" menu item in Visual Studio 2008.
The first few pages pull up just fine -- the default page and the security page. It shows me that I have 0 users and 0 roles. I was able to click on "Enable Role Manager" or whatever it said. In my connection string I'm connecting as the sa user.
When I click on "Create or Manage Roles" I get an error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible." etc, about how the server may not be reachable.
Well, I think it is able to get to the server since it shows me that I have 0 users and roles. If it was unable to get there, in past experience, it would show blank instead of 0.
I know that there are many stored procs and functions installed in SQL to support membership, so is it possible that the sa user doesn't have the rights to execute these things? How would I check? I'm really not good at SQL security, as is evidenced by me using the SA username and password.
Any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
根据我的经验这件事是不可能的。但如果你坚持的话你可以自己检查一下。
检查 sa 用户是否具有 ASPNETDB 所有者权限（默认情况下 sa 用户具有所有数据库所有者权限）
祝你好运伙计
according to my experience this thing is impossible. but if you insist on it you can check it your self .
check that sa user have the ASPNETDB owner privilege(by default sa user have all database owner privilege)
good luck dude
http://forums.asp.net/t/978442.aspx/1
在页面的大部分位置，这里是您需要在 web.config 中包含的代码
http://forums.asp.net/t/978442.aspx/1
Most of the way down the page, here is the code you need to have in your web.config