Logging on hangs client program

[FireBlade954]

We have an application that uses a client program to access and SQL database. The program also uses some files that are external from the database and sit in a share on the server. Occasionally we have a situation where users trying to log on just hang. I have established that it is not the SQL server at fault as I can access the databases on it through other software. Some how, these external files are causing the whole thing to hang. All these files contain is some icons and custom forms for people. There is also a lock file in there which each user gets a lock on when they log on. AFAIK, this lock file only provides information about who is logged on, for administrative purposes. I have established that if each user has an independent lock file, then the problem does not occur, but this is not a practical way of running.

 

[tlbroadbent]

This doesn't appear to be a SQL Server Administration issue. Is there a reason you posted this in this forum? We won;t be able to provide help if there is no SQL Server issue. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[FireBlade954]

Sorry, but I was thinking maybe this problem was related to both SQL and windows. I have since nailed it down to a Win2000 SP3 file sharing issue. Thanks for the reply anyway.