1. MaxMpxCt Parameter...
I have the next configuration:
A SQL Server running:
a.. W2K Server SP1
b.. SQL 7.0 SP3
A TERMINAL SERVICES Server running:
a.. W2K Server SP1
a.. LAN Clients, running an aplication (in Visual Basic) that connects to the SQL Server.
b.. WAN Clients, that run another aplication (in Visual Basic), and connects, through the Terminal Server, to the SQL Server.
My LAN Clients NO have problems.
But my WAN Clients have the next problems: Some times, most frequently when ALL THE WAN USERS are working, some SQL Procceses are LOCKED (or BLOCKED, the message says LOCK BLOCKED, or something like that)
We suspect that we have a problem with the MAXMPXCT parameter, because I discover an error in the SQL Server Event Log:
The value named MaxMpxCt in the server's Registry key LanmanServer\Parameters was invalid. The value was ignored, and processing continued.
I had 511, and I changed it to 100.
I was ready articles Q271148 and Q141709, and I suspect that we have some problems with the MAXMPXCT and MAXCMDS parameters in BOTH SERVERS.
In article Q271148, I read that Windows 2000 has a problem with the MAXCMDS parameter and it puts to 50.
I don't know if the conection between the W2K Terminal Server and the W2K SQL Server uses this parameter by MACHINE or if it uses by SESION. That means, I don't know if in hits connection I only have 50 Concurrent Outstanding Network Requests.
I think I have a problem. Why? Because I was been erasing MAPS between this SERVERS and the problems now is lower, but it continues.
Can somebody help me?
2. Recordset trouble
3. Can't perform sql6.5 disk backup on win2000pro
4. Please Help....
5. WIn2000pro w/SQL Server
6. Database size limit on MSDE 2000
7. Installing ADO 2.5 on Win2000Pro for VB Program
8. VB Sytax for Connection Pooling in MTS
9. does SQl 7.0 runs on win2000Pro
10. Installing MSSQL2k on WIn2000Pro
11. PLEASE HELP!!! adodb.connection and win2000pro
12. ODBC -> Oracle 16 bit on win2000pro