用户实例 SQL Server 2005 Express mdf 文件的问题
我有一个正在单独服务器上使用的网络应用程序。我最初没有创建它，但我必须维护它。我必须对其中一个数据库表进行一些手动编辑，这是通过安装在同一台计算机上的 Visual Studio 2008 完成的。现在我收到有关网络服务没有正确权限的 SQL 异常。
我该如何避免这种情况发生？我没有修改有关安全或访问信息的任何设置。在我修改之前它可以工作，但现在不行了。
谢谢！
I have a web app that I am working with on a separate server. I didn't originally create it, but I have to maintain it. I had to to do some manual editing of one of the database tables, which I did through Visual Studio 2008 installed on the same machine. Now I get SQL exceptions regarding Network Service not having the right privileges.
How do I avoid this from happening? I haven't modified any settings regarding the security or access information. It was working before I made the modification, and now it isn't.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您是否偶然更改了为数据库存储的连接信息？也许删除显式用户（SQL 身份验证）并将其替换为 Trusted_Connection？
您是否还更改了网络服务器以不再使用身份验证？
该错误听起来像是来自网络服务帐户（通常负责运行 ASP.NET 页面的帐户）无法访问数据库这一事实。这种情况主要发生在禁用身份验证并且没有显式 SQL 身份验证时。
Did you by chance change the connection information stored for the DB? Perhaps remove a explicit user (SQL Authentication) and replace it with a Trusted_Connection?
Also did you change the webserver to no longer use authentication?
The error sounds like it is coming from the fact that the Network Service account (the one generally responsible for running ASP.NET pages) cannot access the DB. This happens mostly when authentication is disabled, and there is no explicit SQL Authentication.