无法打开登录请求的数据库。登录失败。用户'NT AUTHORITY \ NETWORK SERVICE'登录失败。 [英] Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

问题描述

亲爱的Alll



在sql .i中运行作业时遇到上述错误，在程序中添加了链接服务器并收到错误。



无法打开登录请求的数据库。登录失败。用户'NT AUTHORITY \ NETWORK SERVICE'登录失败。



请帮助解决错误的解决方案..



提前感谢

Dear Alll

Getting the mentioned error while running the job in sql .i have added link server in the procedure and getting the error.

Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

Pls help with the solution for the error..

thanks in advance

推荐答案

嗨Prathma，





此链接应该可以正常使用：

http://blog.sqlauthority.com/2009/08 / 20 / SQL服务器修复错误，无法打开数据库请求由这为登录的登录失败的登录失败的 - 为用户-NT-authoritynetwork服务/ [ ^ ]



欢呼，

Marco Bertschi

Hi Prathma,


This link should work fine for you:
http://blog.sqlauthority.com/2009/08/20/sql-server-fix-error-cannot-open-database-requested-by-the-login-the-login-failed-login-failed-for-user-nt-authoritynetwork-service/[^]

cheers,
Marco Bertschi

因为这是我的链接服务器的问题。问题已经纠正，需要添加链接服务器并解决问题。

As this was the issue with my linked server .issue rectified and required linked server added and issue resolved .

这篇关于无法打开登录请求的数据库。登录失败。用户'NT AUTHORITY \ NETWORK SERVICE'登录失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！