Error 7413

Troubleshooting SQL Server

Troubleshooting

Error 7413

Severity Level 16
Message Text

Could not perform a Windows NT authenticated login because delegation is not available.

Explanation

This error message indicates that a distributed query is being attempted for a Microsoft® Windows® authenticated login without an explicit login mapping. In an operating-system environment in which security delegation is not supported, Windows NT authenticated logins need an explicit mapping to a remote login and password created using sp_addlinkedsrvlogin.

Action

Create explicit mapping to a remote login and password using sp_addlinkedsrvlogin.

See Also

Distributed Queries

sp_addlinkedsrvlogin