login failed

By jrobjones ·
Microsoft OLE DB Provider for SQL Server error '80040ed'

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Pasting your error message into Google yielded:

by robo_dev In reply to login failed

This error occurs if SQL Server security mode is set to Microsoft Windows NT only and the NT account that is being used to authenticate the user on the IIS computer (such as IUSR_computer for anonymous IIS access) does not have permissions to connect to the remote SQL Server's NT computer.

See if you can connect via OSQL from the command line. If you can connect with sa and a blank password, then go slap your DBA for not having any database security.

Related Discussions

Related Forums