Microsoft KB Archive/812282

= BUG: &quot;Login time-out&quot; Property Value Does Not Take Effect For SQL Query Analyzer =

Article ID: 812282

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
When a log on process takes more than 15 seconds, Microsoft SQL Query Analyzer times out, without considering the LoginTimeout property value.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
You use the LoginTimeout property to specify the time to wait (in seconds) for a connection before the operation times out.

How to Set LoginTimeout for SQL Query Analyzer
To set the LoginTimeout value for SQL Query Analyzer, use these steps:
 * 1) Open Query Analyzer.
 * 2) On the Tools menu, click Options.
 * 3) In the Options dialog box, click Connections.
 * 4) Type the value for LoginTimeout in the Login time-out (seconds) text box.
 * 5) Click OK

How to Set LoginTimeout for SQL Enterprise Manager
To set the LoginTimeout value for SQL Enterprise Manager, use these steps:
 * 1) Open Enterprise Manager.
 * 2) On the Tools menu, click Options.
 * 3) In the Options dialog box, click Advanced.
 * 4) Type the value for LoginTimeout in the Login time-out (seconds) text box.
 * 5) Click OK.

Keywords: kbbug kbnofix KB812282

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.