unable to run multiple queries/connections

[VMRao]

hi
I'm working on MS SQL server 7.0/client machine.Actual server is on some other machine on the network.
protocol used: named pipes
everything worked fine till yesterday.
now i am unable to run multiple queries/connections.If i try to run a second query in query analyzer, the connection is getting broken and the error message is:

[Microsoft][ODBC SQL Server Driver][Named Pipes]
ConnectionRead (NLReadFile()).

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

Connection Broken

can anyone help me??

Thanks
VMRAO

Malli.
When the going gets tough,
Tough gets going..........

 

[JayKusch]

Is the database you are running Query Analyzer in single user mode?

Thanks

J. Kusch

 

[VMRao]

Thanks Kusch
...No.. the database is accessible by many machines on the network..Multiuser mode

Malli.
When the going gets tough,
Tough gets going..........

 

[SQLSister]

My first question is what happened yesterday? Did someone update the SQL Server or network software or operating systems? WHat ever changed yesterday is the likely culprit. I do kknow that most people don;t connect using named pipes, but if it worked before, you should be able to to get it back to its previous state. I would talk to every single person and look inthe logs for automatic updates and see what changed yesterday as my first step in solving a problem of this sort.

 

[VMRao]

Nothing has been changed...everything is same as before.
My query is of 1031 lines ....Is this anyway related(1031 lines)

Malli.
When the going gets tough,
Tough gets going..........

 

[JayKusch]

There were not upgrades or software installs that may have updated/downgraded your MDAC?

Thanks

J. Kusch