[SQL Server]Login failed for user

I am using Crystal Reports, VB.net, SQL Server 2000sp3, MDAC 8.0, and Windows XP. When I try to make a connection from a Crystal Report to SQL Server via an ODBC connection, I get the following message:

Details: 28000:[Microsoft][SQL Server Driver][SQL Server]Login failed for user domain/username

In the odbc, I specify SQL Server authentication and provide a username and password but these are being ignored. Why is Windows authentication being used in place of the SQL Server authentication that I specify in my odbc?

Thanks in advance,

MattThat's Crystal for you :)|||What version of Crystal Reports are you using?|||Originally posted by awsterling
What version of Crystal Reports are you using?

I am the version that came with Visual Studio .Net 2003. I don't know how to get the version number from it.

Thanks.|||Get ActiveReport from DataDynamics and you won't have to deal with these issues any more :)

[ConnectionWrite (send()).]General network error

Hi All
I have a visual basic application, which uses SQL Server 2000(sp3a) as
the database, MDAC 2.8 library. I open one connection to the db on the
application start, and the applicaiton works fine for few days, then
suddenly it gives this error [DBNETLIB][ConnectionWrite
(send()).]General network error. -2147467259 .
I tried to close the connection and open again on this error, and I get
this error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied. -2147467259. If the application is closed
and opened again, it works fine without any problems.
This applicaiton runs on at around 12 different sites.There is no
pattern to when this error
occurs and I really cannot replicate it.
I have checked the SQL server logs, application logs, system logs on
server and client machines, there is nothing useful I could find.
The client running the application, and the server and on the same LAN,
no firewall.
I already posted this message in SQLSERVER.Server group, but didnt get
any help.
Any help is highly appreciated.
Thanksi have seen faulty NICs do weird things. the error simply means the app
can't get to the server. this is definitely _connection_ problem.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150444943.918481.99820@.g10g2000cwb.googlegroups.com...
> Hi All
> I have a visual basic application, which uses SQL Server 2000(sp3a) as
> the database, MDAC 2.8 library. I open one connection to the db on the
> application start, and the applicaiton works fine for few days, then
> suddenly it gives this error [DBNETLIB][ConnectionWrite
> (send()).]General network error. -2147467259 .
> I tried to close the connection and open again on this error, and I get
> this error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
> not exist or access denied. -2147467259. If the application is closed
> and opened again, it works fine without any problems.
> This applicaiton runs on at around 12 different sites.There is no
> pattern to when this error
> occurs and I really cannot replicate it.
> I have checked the SQL server logs, application logs, system logs on
> server and client machines, there is nothing useful I could find.
> The client running the application, and the server and on the same LAN,
> no firewall.
> I already posted this message in SQLSERVER.Server group, but didnt get
> any help.
> Any help is highly appreciated.
> Thanks
>|||oj wrote:
> i have seen faulty NICs do weird things. the error simply means the app
> can't get to the server. this is definitely _connection_ problem.
> --
> -oj
Thanks for ur reply oj., but i certainly do not think this is a case of
faulty NIC's. One or two or three pcs getting this error, i would
understand., but this happens everywhere, but without a pattern.|||would you by any chance using windows authentication? unable to communicate
with the domain controller would cause issue.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150451691.161431.42480@.r2g2000cwb.googlegroups.com...
> oj wrote:
> Thanks for ur reply oj., but i certainly do not think this is a case of
> faulty NIC's. One or two or three pcs getting this error, i would
> understand., but this happens everywhere, but without a pattern.
>|||oj wrote:
> would you by any chance using windows authentication? unable to communicat
e
> with the domain controller would cause issue.
> --
> -oj
>
> <tech.support.b@.gmail.com> wrote in message
> news:1150451691.161431.42480@.r2g2000cwb.googlegroups.com...
No, I am not using Windows authentication, I am using SQL server
authentication. No Domain, its a workgroup. Funny part is, the moment
this error happens, if i kill the application and run the application
again, there is no problem., however, if at the time of the error, I
try to close and re-open the connection, it always fails.|||hmm...what is the value for @.@.max_connections. and @.@.version.
can you ping the server once an error occurs. can you connect via <ip,port>.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150483296.616430.109960@.h76g2000cwa.googlegroups.com...
> No, I am not using Windows authentication, I am using SQL server
> authentication. No Domain, its a workgroup. Funny part is, the moment
> this error happens, if i kill the application and run the application
> again, there is no problem., however, if at the time of the error, I
> try to close and re-open the connection, it always fails.
>|||oj wrote:
> hmm...what is the value for @.@.max_connections. and @.@.version.
> can you ping the server once an error occurs. can you connect via <ip,port
>.
>
> --
> -oj
>
> <tech.support.b@.gmail.com> wrote in message
> news:1150483296.616430.109960@.h76g2000cwa.googlegroups.com...
@.@.version returns
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: )
@.@.max_connections is 32767
The server is pingable, and other users continue working without any
problems while this problem happens.