SQL Server Annoying popup upon boot

I have SQL Server Manager 8.00.2039 installed because I have one program
(app) installed that requires it be installed. For the first little
while when I had SQL server installed it would only show up in the
taskmanager tray, now MOST of the time, it shows up as a popup on my
desktop and also in my task tray when I first start XP (SP2). It stays
there until I close it. Is there a way to prevent the SQL from popping
up?

Thanks

Re: SQL Server Annoying popup upon boot

Sam (unknown@unk.com) writes:
> I have SQL Server Manager 8.00.2039 installed because I have one program
> (app) installed that requires it be installed. For the first little
> while when I had SQL server installed it would only show up in the
> taskmanager tray, now MOST of the time, it shows up as a popup on my
> desktop and also in my task tray when I first start XP (SP2). It stays
> there until I close it. Is there a way to prevent the SQL from popping
> up?

If you don't want it to be running at all, just remove it from the Startup
folder.

If you want to have it the task tray without showing on the desktop, I
don't have that many ideas, as my Server Manager never behaves that way.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: SQL Server Annoying popup upon boot

Erland Sommarskog wrote:
: Sam (unknown@unk.com) writes:
:: I have SQL Server Manager 8.00.2039 installed because I have one
:: program (app) installed that requires it be installed. For the
:: first little while when I had SQL server installed it would only
:: show up in the taskmanager tray, now MOST of the time, it shows up
:: as a popup on my desktop and also in my task tray when I first start
:: XP (SP2). It stays there until I close it. Is there a way to
:: prevent the SQL from popping up?
:
: If you don't want it to be running at all, just remove it from the
: Startup folder.
:
: If you want to have it the task tray without showing on the desktop, I
: don't have that many ideas, as my Server Manager never behaves that
: way.

Thanks for the reply. Actually, I do want it running (on an as needed
basis). I use it to run a smart card reader and the data on the smart
card. I have 3 parts of the program in the startup folder:

MS SQL Manager
Service Manager
and an the Smart Card Reader Program with an unusual path: "C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\scm.exe" -Action 1 -Silent
1 -Service ASUS\ENCOREPRO with target "C:\Program Files\Microsoft SQL
Server\80\Tools\binn"

I have reformatted my hard drive several times and sooner or later this
issue resurfaces.

Sam

Re: SQL Server Annoying popup upon boot

Spaz (none@none.com) writes:
> Thanks for the reply. Actually, I do want it running (on an as needed
> basis). I use it to run a smart card reader and the data on the smart
> card. I have 3 parts of the program in the startup folder:
>
> MS SQL Manager
> Service Manager

This sounds like one too many to me. What paths do they have? And do they
have any command-line options?

On my machine, the commandline for Service Manager is:

"E:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n

I tested to run this from a command-line window. Without /n the application
would appear as a window. With /n it only showed in the tray, which is
the way I normally want it.

> and an the Smart Card Reader Program with an unusual path: "C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\scm.exe" -Action 1 -Silent
> 1 -Service ASUS\ENCOREPRO with target "C:\Program Files\Microsoft SQL
> Server\80\Tools\binn"

The scm application is "Service Control Manager", an application I did
not have any knowledge prior to reading your post. The purpose appears to
be to autostart the ASUS\ENCOREPRO service. A more normal way to do this
would be to configure the service as Automatic in Services under Computer
Management.

> I have reformatted my hard drive several times and sooner or later this
> issue resurfaces.

I hope you have had other reasons for reformatting than just getting
rid of the pop-up!

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx