用户“NT AUTHORITYNETWORK SERVICE"登录失败 [英] Login failed for user 'NT AUTHORITYNETWORK SERVICE'

问题描述

我已经为此苦苦挣扎了 2 天，但一直没有接近解决方案.我已经阅读了 20-30 个线程，但仍然无法解决这个问题.

I been strugling with this for 2 days now without comming any closer to solution. I have read 20-30 threads alteast and stil can not resolve this.

请帮帮我.

我已禁用匿名身份验证，启用 asp.net 模拟.

I have disable anonymous authentication, enable asp.net impersonation.

我添加了

我已将 a 用户添加到连接到我尝试连接的数据库的安全登录

I have added the a user to the security logins that is connected to the database I try to connect to

这是我使用的连接字符串:

This is the connectionstring I use:

Data Source=IPTOSERVER;Initial Catalog=Phaeton;User Id=User;Password=Password;

错误信息:

无法打开登录请求的数据库Phaeton.mdf".登录失败.

Cannot open database "Phaeton.mdf" requested by the login. The login failed.

用户NT AUTHORITYNETWORK SERVICE"登录失败.

Login failed for user 'NT AUTHORITYNETWORK SERVICE'.

推荐答案

您收到的错误消息告诉您应用程序无法连接到 sqlexpress 数据库，而不是 sql server.我将在 sql server 中更改数据库的名称，然后相应地更新连接字符串并重试.

The error message you are receiving is telling you that the application failed to connect to the sqlexpress db, and not sql server. I will just change the name of the db in sql server and then update the connectionstring accordingly and try it again.

您的错误消息说明如下:

Your error message states the following:

Cannot open database "Phaeton.mdf" requested by the login. The login failed.

在我看来，您仍在尝试连接到基于文件的数据库，名称Phaeton.mdf"与您的新 sql 数据库名称Phaeton"不匹配.

It looks to me you are still trying to connect to the file based database, the name "Phaeton.mdf" does not match with your new sql database name "Phaeton".

希望这会有所帮助.

这篇关于用户“NT AUTHORITYNETWORK SERVICE"登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！