Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server Session Timeout
- Thread starter asanjue
- Start date
Bernadette
MIS
Hi There
This may seem a silly question. I am sure you have tried this already but are you trying to login using NT Integegrated Security on the Win 9x machines as Win 9x machines cannot authenticate WIndows NT accounts. Windows NT authentication mode is not available when SQL Server 7.0 is installed on these operating systems. Only mixed mode is available.
Hope this helps
Good Luck AsanJue
Bernadette
This may seem a silly question. I am sure you have tried this already but are you trying to login using NT Integegrated Security on the Win 9x machines as Win 9x machines cannot authenticate WIndows NT accounts. Windows NT authentication mode is not available when SQL Server 7.0 is installed on these operating systems. Only mixed mode is available.
Hope this helps
Good Luck AsanJue
Bernadette
- Thread starter
- #3
Hi. Thanks for answering. I am using mixed mode security. The problem is intermittent ie sometimes the connections work but then suddenly start timing out and i have noticed the problem on two separate installation sites where the network is not NT. Thanks
Bernadette
MIS
Can you connect via ODBC in your Control Panel, if not what error does it give you ?
- Thread starter
- #6
Hi. Thanks for replying. Yes i can connect via odbc without any errors. The app i'm running uses OLEDB as a provider. The timeouts occur like once every 10 times the app tries to connect. When i use the SQL Performance monitor to view the connections in NT i can see that the App releases connections. The time out problem is only on Windows 9x machines and networks. By The Way, on these machines the SQL installation is the Standard Edition. Would installing the Desktop edition help? Thanks
Bernadette
MIS
Microsoft does recommend that the "Desktop Edition" is installed on Windows 95/98 systems. As this doesnt support "NT authentication" you will have to connect with TCP/IP (port 1433).
When you get a timeout, try your ODBC connection and see what ODBC error is displayed. What is the SQLState given in the ODBC error ? Are you getting errors in your SQL Error Log or NT Event Log ... if so what are they ?
When you get a timeout, try your ODBC connection and see what ODBC error is displayed. What is the SQLState given in the ODBC error ? Are you getting errors in your SQL Error Log or NT Event Log ... if so what are they ?
- Status
Similar threads
- Locked
- Question
