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 |
|
rj_khatri
Starting Member
13 Posts |
 Posted - 2003-07-04 : 03:09:05
|
Dear friends,Hi!WE have a Win2k m/c and on that we have both SQL 7.0 and SQL 2000 installed. These were working pretty properly until yesterday.We changed the number of connections to single user for SQL server 7.0 for an experiment. Since then we are unable to access the SQL server 7.0 (from the same m/c as well as other client m/c's)SQL 2000 is working fine. but when we attempt to connect to sQL 7 thriugh Query analyzer it says[Microsoft}{ODBC SQL Server Driver][shared Memory]General Network Error,..I tried both with TCP/IP and Named Pipes.While when we try to check properties on Enteroprise manager It saysGeneral Network Error. ConnectionRead()...Can you please help me to resolve this error.Thanks. Rajesh Khatri |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-04 : 03:14:35
|
| Erm. If you are on single user then you will only be able to connect to it once. How many connections do you have?Is the server running?-------Moo. |
 |
|
|
rj_khatri
Starting Member
13 Posts |
Posted - 2003-07-04 : 09:08:11
|
| Server is running ( i say this because service manager works fine)But when i try to connect using Query Analyzer or Enterprise manager it gives the above mentioned errors.Currently i am not able to connect to it.About the connections i have taken it out from the network so there should not be any connection to the server. As i cannot open even the Enterprise manager so can not get the process info from the management->current Activity.Any ideas about that.Rajesh Khatri |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-04 : 09:32:35
|
| Not really. Have you tried restarting it?-------Moo. |
|
|
|
rj_khatri
Starting Member
13 Posts |
Posted - 2003-07-04 : 10:46:18
|
| Dear Friend,Hi!I am done with all that stuff. Not able to get a clue yet.Please help!!Rajesh Khatri |
|
|
|
rj_khatri
Starting Member
13 Posts |
Posted - 2003-07-05 : 04:37:11
|
| Any idea about that.Please help.Rajesh Khatri |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-05 : 16:30:26
|
| Suspect it is because somnething else has already got a connection.e-m gets mor ethan one connection so that won't work.You could have started in single user mode by using the -m switch.Look at the nt event log and sql server logs - you will probably find errors there.Try starting sql server using sqlserver.exe -m - this will start it from a user window rather than as a service.Then it's worth trying query analyser - not enterprise manager.To set the value back to 0 you will have to use sp_configure.Probably best to reinstall v7 and attach the databases - I assume you haven't tried this on anything important.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-05 : 20:21:54
|
| Make sure SQL Agent Service is stopped and then start from a command prompt as Nigel suggested and reconfigure the server.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
rj_khatri
Starting Member
13 Posts |
Posted - 2003-07-08 : 05:45:59
|
| Dear Mr. Nigel Rivett & Mr. Jasper Smith Thanks a lot.It worked greatly. And now I am able to connect. :)Thanks again for your efforts.Rajesh Khatri |
|
|
|
|
|
|
Single user/multiple user(number of connections)