Posted by Simon Hayes on 10/01/51 11:17

"Do Park via SQLMonster.com" <forum@nospam.SQLMonster.com> wrote in message
news:9caa7e6d6eff41c1984f7334221dc753@SQLMonster.com...
> Hello all,
>
>
> I use Crystal Report v9, SQL server 2000.
> When I try to connect to a Database via ADO, I got the following error.
>
> Login failed.
> Details :ADO Error Code:0x80040e4d
> Source:Microsoft OLE DB Provider for SQL Server
> Description:Login failed for use'xxxxxxx'
> SQL State: 42000
> Native Error:18456
>
> Is there anyone how has this problem?
> How can I fix this?
>
> Thanks in advance,
> Do.
>
> --
> Message posted via http://www.sqlmonster.com

"Login failed" suggests that you need to check the login you're using to
connect with - is it a SQL login, or a Windows account; are you using a DSN
or a connection string; can you connect from osql.exe or Query Analyzer
using the same account (or another account) etc.

Simon

[Back to original message]