SQL Server Login

[R4quel]

Individuals with acccess to our 3-party software have been encountering
the following error messages:

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Drive ][SQL Sever}Login failed for
user'xxxxxxx x'

User's have been using the default login id and p/w which it would
allow them to get in; but the problem have elevated to where it does
not allow all users to use the default login id and p/w and users
personal login id and p/w.

Please advice.

Thank you

 

[Sylvain Lafontaine]

Maybe a time-out problem on an overloaded SQL-Server? Try increasing the
limit for opening a connection from its default of 15 seconds to something
like 30 seconds or more.

Another possibility is that you are exceeding the number of client licenses.

When you have a problem make your ODBC connection, do you have the same
problem using another client software like Enterprise Manager or Query
Analyser? Does the problem persists using the exact same login and password
but on another machine? What happen after some time has passed?

Also, this newsgroup is more about ADP and SQL-Server than about a MDB
database file with linked tables. You should post in m.p.a.externaldata,
m.p.a.odbclientsvr or m.p.sqlserver.server to get a better answer than the
above.