|
Home > Archive > Microsoft SQL Server forum > May 2005 > ADO Error Code:0x80040e4d
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ADO Error Code:0x80040e4d
|
|
| Do Park via SQLMonster.com 2005-05-30, 8:23 pm |
| 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.webservertalk.com
| |
| Simon Hayes 2005-05-30, 8:23 pm |
|
"Do Park via webservertalk.com" <forum@nospam.webservertalk.com> wrote in message
news:9caa7e6d6eff41c
1984f7334221dc753@we
bservertalk.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.webservertalk.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
| |
| Do Park via SQLMonster.com 2005-05-30, 8:23 pm |
| I use Windows authentication. I can access other databases via the same way
(Crystal Report). I connected this database via ADO successfully two or
three days ago. There was no change in my environment and SQL Server.
Best regards,
Do.
--
Message posted via http://www.webservertalk.com
| |
| Erland Sommarskog 2005-05-30, 8:23 pm |
| Do Park via webservertalk.com (forum@webservertalk
.com) writes:
> I use Windows authentication. I can access other databases via the same
> way (Crystal Report). I connected this database via ADO successfully two
> or three days ago. There was no change in my environment and SQL
> Server.
Probably there was. Unfortunately, it is impossible for us who don't
have access to your environment to tell what is going on. You will
have to see your local admin to sort it out.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|