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 - 2001-05-06 : 14:34:01
|
Keith writes "We have problem with our SQL 6.5 server running on NT 4.0 OS. We got the message from the server
Microsoft SQL Server Login
COnnection failed
SQLState: S1T00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver] Timeout Expired
and
Microsoft SQL Server Login
Connection failed
SQL State: '01000'
SQL Server Error: 231
[Microsoft][ODBC SQL Server Driver][Named Pipes] Connection Open [Connect()].
Connection failed:
SQLState: '08001'
SQL Server Error:17
[Microsoft][ODBC SQL Serve Driver][Named Pipes]SQL Serve does not exist or access denied.
Wonder there is any limited usage at one time on the SQL server. Our GUI application generates one processor/thread per one input date to the NT server. However, it seems if the GUI application requests a range of date (ie 30 days) at one time, the above problem will occur in the NT server.
I have very limited SQL server but some Oracle experience. Can you point out there is a limited usage of SQL server at one time or not? I know Oracle does. Maybe the GUI application doesn't release back the connection and that limits the usage. Can someone give me any idea, thank you." |
|
|
|
|
|
SQL6.5 Connection Failed on NT server