Error 18456 - Connecting via DSN

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
My MS Access application needs to connect to a SQL server via a system
dsn. However, I keep getting the error 18456 - Login failed for user 'xxxx'.
The surprising bit is I am able to use the same password and user id and
connect to the server using Enterprise Manager. Any ideas on why the dsn is
throwing this error? Connection is via SQL authentication.
Any help would be much appreciated.
Rgds,
San
.

Relevant Pages

  • Re: vfp + sql server
    ... Don't use SQL Server. ... I find this surprising. ... Regards, ... Mike ...
    (microsoft.public.fox.vfp.dbc)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... Our san guy is ... completely forget about is that moving the head on the disk is the slowest ... the drives that were being assigned to the SQL machine. ... I mean the binn folder which contains the sql server executable among ...
    (microsoft.public.sqlserver.setup)
  • Re: Disaster recovery
    ... I'm not familiar with REDO groups. ... use the SAN replication functionality to replicate the SQL Server data. ... "tram" wrote in message ...
    (microsoft.public.sqlserver.server)
  • SQL Server High Availability/Fault Tolerance.
    ... Node Active/Passive SQL Server 2000 Enterprise Ed. Cluster,running on ... The shared storage is on HP EVA 5000.The 2 servers and SAN are all in the ... SQL Server 2005 Standard or Enterprise Edition is considered as the DB ... After the upgrade 2 separate buildings will be used. ...
    (microsoft.public.sqlserver.clustering)
  • Re: question about disaster recovery ala virtualization
    ... If the SAN tells SQL Server "data is written" but it's stored in cache on the SAN and the SAN dies and there's no battery backup, etc. then you risk data loss. ... Lets say the motherboard on the host suddenly dies, ...
    (comp.databases.ms-sqlserver)