Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-18 : 07:46:56
|
| Pedro writes "We have a VB 6.0 application that connects to SQL 2000 using ODBC with Windows Authentication, this app. is used by the Call Center so there are around 15-20 people using it at any given time. The application works fine like 95 % of the time, however for no obvious reason fails sporadically with Time Out trying to connect to the database. In the SQL log the error shows as: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."It is a very random problem and some days is worse than others. We have Windows 2000 Pro as OS and Active Directory.Any help will be very appreciatedThanksPedro Conde" |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-10-18 : 08:07:15
|
| I dont know whether i m right.. but it may be due to the heavy network traffic.. If you are using ADO then you can increase the ConnectionTimeout .. of the connection propertyComplicated things can be done by simple thinking |
 |
|
|
|
|
|
Login failed for user '(null)'.