other programs won't start while SQL is running

First of all I'm not a sql guru. I'm just doing some troubleshooting on the server.
I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints from the DBA about sql performance.
The problem is while sql is running other programs won't start.
IIS
v2i protector
They time out. If I close sql and restart the other services they start fine but then sql won't start.
The event id's I get for all programs are
26-Application popup:'program.exe' application error: The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.
7009- Timeout (30000 milliseconds) waiting for the 'program' service to connect.
7000-The 'program' service failed to start due to the following error" the service did not respond to the start or control request in a timely fashion.
Has anyone seen a situation like this before?
ThanksHi,
Can you make the SQL Server Memory to Static and Restart the SQL Server and
other services. It seems
SQL Server meory set to dynamic and it utilize all the memory available in
the system. This might be a
problem.
Using task manager check the memory utilized by SQLSERVR.EXE.
--
Thanks
Hari
MCDBA
"Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> First of all I'm not a sql guru. I'm just doing some troubleshooting on
the server.
> I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
from the DBA about sql performance.
> The problem is while sql is running other programs won't start.
> IIS
> v2i protector
> They time out. If I close sql and restart the other services they start
fine but then sql won't start.
> The event id's I get for all programs are
> 26-Application popup:'program.exe' application error: The application
failed to initialize properly (0xc0000142). Click on OK to terminate the
application.
> 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
connect.
> 7000-The 'program' service failed to start due to the following error" the
service did not respond to the start or control request in a timely fashion.
> Has anyone seen a situation like this before?
> Thanks
>|||Rich,
Sounds like you may be lacking enough memory to operate properly or someone
has turned off the Dynamic Memory allocation in SQL Server by setting the
SET Working Set size to On. Make sure the Memory in SQL Server is still set
to Dynamic but lower the Max Memory setting enough to leave memory for the
other applications.
--
Andrew J. Kelly SQL MVP
"Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> First of all I'm not a sql guru. I'm just doing some troubleshooting on
the server.
> I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
from the DBA about sql performance.
> The problem is while sql is running other programs won't start.
> IIS
> v2i protector
> They time out. If I close sql and restart the other services they start
fine but then sql won't start.
> The event id's I get for all programs are
> 26-Application popup:'program.exe' application error: The application
failed to initialize properly (0xc0000142). Click on OK to terminate the
application.
> 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
connect.
> 7000-The 'program' service failed to start due to the following error" the
service did not respond to the start or control request in a timely fashion.
> Has anyone seen a situation like this before?
> Thanks
>|||"Andrew J. Kelly" wrote:
> Rich,
> Sounds like you may be lacking enough memory to operate properly or someone
> has turned off the Dynamic Memory allocation in SQL Server by setting the
> SET Working Set size to On. Make sure the Memory in SQL Server is still set
> to Dynamic but lower the Max Memory setting enough to leave memory for the
> other applications.
> --
> Andrew J. Kelly SQL MVP
>
> "Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
> news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> > First of all I'm not a sql guru. I'm just doing some troubleshooting on
> the server.
> >
> > I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
> from the DBA about sql performance.
> >
> > The problem is while sql is running other programs won't start.
> > IIS
> > v2i protector
> >
> > They time out. If I close sql and restart the other services they start
> fine but then sql won't start.
> >
> > The event id's I get for all programs are
> > 26-Application popup:'program.exe' application error: The application
> failed to initialize properly (0xc0000142). Click on OK to terminate the
> application.
> >
> > 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
> connect.
> >
> > 7000-The 'program' service failed to start due to the following error" the
> service did not respond to the start or control request in a timely fashion.
> >
> > Has anyone seen a situation like this before?
> >
> > Thanks
> >
> After you guys replied to my post I checked out the server after the boot. Between the MSMDSRV.EXE and the SQLSERVR.EXE they were using up 1.6 gig of memory!!! I'm still not quite sure of the fix yet but the I found a MS knowledgebase article concerning a memory leak in MSMDSRV.EXE. We're looking into it and are keeping your posts in mind. Thank you both very much.
>

other programs won't start while SQL is running

First of all I'm not a sql guru. I'm just doing some troubleshooting on the server.
I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints from the DBA about sql performance.
The problem is while sql is running other programs won't start.
IIS
v2i protector
They time out. If I close sql and restart the other services they start fine but then sql won't start.
The event id's I get for all programs are
26-Application popup:'program.exe' application error: The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.
7009- Timeout (30000 milliseconds) waiting for the 'program' service to connect.
7000-The 'program' service failed to start due to the following error" the service did not respond to the start or control request in a timely fashion.
Has anyone seen a situation like this before?
Thanks
Hi,
Can you make the SQL Server Memory to Static and Restart the SQL Server and
other services. It seems
SQL Server meory set to dynamic and it utilize all the memory available in
the system. This might be a
problem.
Using task manager check the memory utilized by SQLSERVR.EXE.
Thanks
Hari
MCDBA
"Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> First of all I'm not a sql guru. I'm just doing some troubleshooting on
the server.
> I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
from the DBA about sql performance.
> The problem is while sql is running other programs won't start.
> IIS
> v2i protector
> They time out. If I close sql and restart the other services they start
fine but then sql won't start.
> The event id's I get for all programs are
> 26-Application popup:'program.exe' application error: The application
failed to initialize properly (0xc0000142). Click on OK to terminate the
application.
> 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
connect.
> 7000-The 'program' service failed to start due to the following error" the
service did not respond to the start or control request in a timely fashion.
> Has anyone seen a situation like this before?
> Thanks
>
|||Rich,
Sounds like you may be lacking enough memory to operate properly or someone
has turned off the Dynamic Memory allocation in SQL Server by setting the
SET Working Set size to On. Make sure the Memory in SQL Server is still set
to Dynamic but lower the Max Memory setting enough to leave memory for the
other applications.
Andrew J. Kelly SQL MVP
"Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> First of all I'm not a sql guru. I'm just doing some troubleshooting on
the server.
> I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
from the DBA about sql performance.
> The problem is while sql is running other programs won't start.
> IIS
> v2i protector
> They time out. If I close sql and restart the other services they start
fine but then sql won't start.
> The event id's I get for all programs are
> 26-Application popup:'program.exe' application error: The application
failed to initialize properly (0xc0000142). Click on OK to terminate the
application.
> 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
connect.
> 7000-The 'program' service failed to start due to the following error" the
service did not respond to the start or control request in a timely fashion.
> Has anyone seen a situation like this before?
> Thanks
>
|||"Andrew J. Kelly" wrote:

> Rich,
> Sounds like you may be lacking enough memory to operate properly or someone
> has turned off the Dynamic Memory allocation in SQL Server by setting the
> SET Working Set size to On. Make sure the Memory in SQL Server is still set
> to Dynamic but lower the Max Memory setting enough to leave memory for the
> other applications.
> --
> Andrew J. Kelly SQL MVP
>
> "Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
> news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> the server.
> from the DBA about sql performance.
> fine but then sql won't start.
> failed to initialize properly (0xc0000142). Click on OK to terminate the
> application.
> connect.
> service did not respond to the start or control request in a timely fashion.
> After you guys replied to my post I checked out the server after the boot. Between the MSMDSRV.EXE and the SQLSERVR.EXE they were using up 1.6 gig of memory!!! I'm still not quite sure of the fix yet but the I found a MS knowledgebase article concerni
ng a memory leak in MSMDSRV.EXE. We're looking into it and are keeping your posts in mind. Thank you both very much.
>

other programs won't start while SQL is running

First of all I'm not a sql guru. I'm just doing some troubleshooting on the
server.
I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints fr
om the DBA about sql performance.
The problem is while sql is running other programs won't start.
IIS
v2i protector
They time out. If I close sql and restart the other services they start fin
e but then sql won't start.
The event id's I get for all programs are
26-Application popup:'program.exe' application error: The application failed
to initialize properly (0xc0000142). Click on OK to terminate the applicati
on.
7009- Timeout (30000 milliseconds) waiting for the 'program' service to conn
ect.
7000-The 'program' service failed to start due to the following error" the s
ervice did not respond to the start or control request in a timely fashion.
Has anyone seen a situation like this before?
ThanksHi,
Can you make the SQL Server Memory to Static and Restart the SQL Server and
other services. It seems
SQL Server meory set to dynamic and it utilize all the memory available in
the system. This might be a
problem.
Using task manager check the memory utilized by SQLSERVR.EXE.
Thanks
Hari
MCDBA
"Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> First of all I'm not a sql guru. I'm just doing some troubleshooting on
the server.
> I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
from the DBA about sql performance.
> The problem is while sql is running other programs won't start.
> IIS
> v2i protector
> They time out. If I close sql and restart the other services they start
fine but then sql won't start.
> The event id's I get for all programs are
> 26-Application popup:'program.exe' application error: The application
failed to initialize properly (0xc0000142). Click on OK to terminate the
application.
> 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
connect.
> 7000-The 'program' service failed to start due to the following error" the
service did not respond to the start or control request in a timely fashion.
> Has anyone seen a situation like this before?
> Thanks
>|||Rich,
Sounds like you may be lacking enough memory to operate properly or someone
has turned off the Dynamic Memory allocation in SQL Server by setting the
SET Working Set size to On. Make sure the Memory in SQL Server is still set
to Dynamic but lower the Max Memory setting enough to leave memory for the
other applications.
Andrew J. Kelly SQL MVP
"Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> First of all I'm not a sql guru. I'm just doing some troubleshooting on
the server.
> I've got a Win2000 adv server sp4 w/ sql2000 sp3. I've had no complaints
from the DBA about sql performance.
> The problem is while sql is running other programs won't start.
> IIS
> v2i protector
> They time out. If I close sql and restart the other services they start
fine but then sql won't start.
> The event id's I get for all programs are
> 26-Application popup:'program.exe' application error: The application
failed to initialize properly (0xc0000142). Click on OK to terminate the
application.
> 7009- Timeout (30000 milliseconds) waiting for the 'program' service to
connect.
> 7000-The 'program' service failed to start due to the following error" the
service did not respond to the start or control request in a timely fashion.
> Has anyone seen a situation like this before?
> Thanks
>|||"Andrew J. Kelly" wrote:

> Rich,
> Sounds like you may be lacking enough memory to operate properly or someon
e
> has turned off the Dynamic Memory allocation in SQL Server by setting the
> SET Working Set size to On. Make sure the Memory in SQL Server is still s
et
> to Dynamic but lower the Max Memory setting enough to leave memory for the
> other applications.
> --
> Andrew J. Kelly SQL MVP
>
> "Rich Lehr" <Rich Lehr@.discussions.microsoft.com> wrote in message
> news:2062A7B0-6AC9-4507-86ED-C7206DA1574F@.microsoft.com...
> the server.
> from the DBA about sql performance.
> fine but then sql won't start.
> failed to initialize properly (0xc0000142). Click on OK to terminate the
> application.
> connect.
> service did not respond to the start or control request in a timely fashio
n.
> After you guys replied to my post I checked out the server after the boot. Betwee
n the MSMDSRV.EXE and the SQLSERVR.EXE they were using up 1.6 gig of memory!!! I'm
still not quite sure of the fix yet but the I found a MS knowledgebase article conce
rni
ng a memory leak in MSMDSRV.EXE. We're looking into it and are keeping your posts in mind.
Thank you both very much.
>

osql will not come up MSDE (sp3) or earlier

When I try to run osql, I get the following error:
c:\program files\Microsoft SQL Server\80\Tools\Binn\

> osql -E -d CCOP or osql -U sa -P AStrongPassword -d CCOP
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
I can start the instance "CCOP" from sqlmangr without any
issue, but when I try to run osql against the database, I
can never get past the startup
-d is the switch for the database name, not the instance name. Use the -S
switch to specify the instance name.
If you are not sure of the instance name, issue a osql -L for a list of SQL
Server instances.
See
http://msdn.microsoft.com/library/de...ta_01_2r1e.asp
for more information on running the osql utility.
Terri Morton
MVP - ASP/ASP.NET
"Ed H" <anonymous@.discussions.microsoft.com> wrote in message
news:0f4301c4ff5e$4c209930$a401280a@.phx.gbl...
> When I try to run osql, I get the following error:
> c:\program files\Microsoft SQL Server\80\Tools\Binn\
>
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> I can start the instance "CCOP" from sqlmangr without any
> issue, but when I try to run osql against the database, I
> can never get past the startup
|||
>--Original Message--
>-d is the switch for the database name, not the instance
name. Use the -S
>switch to specify the instance name.
>If you are not sure of the instance name, issue a osql -
L for a list of SQL
>Server instances.
>See
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/acdata/ac_8_mta_01_2r1e.asp
>for more information on running the osql utility.
>Terri Morton
>MVP - ASP/ASP.NET
>"Ed H" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0f4301c4ff5e$4c209930$a401280a@.phx.gbl...
CCOP[vbcol=seagreen]
denied.[vbcol=seagreen]
any[vbcol=seagreen]
database, I
>
>.
> Thx Terri. I had to re-install amoung other things.
The MSDN Help was a very valuable.