I see that I have an instance of SQLSERVR.EXE in my task manager, and I
certainly didn't start it, and can't think of any applications or services
that use it.

How can I find out who started it? Is there a way to connect to SQL server,
and ask it what connections it has currently (or what connections it's had
recently)?

Thanks,
C

You could disable the 'SQL Server (MSSQLSERVER)' service and see what
application complains or give this a go.

http://www.microsoft.com/technet/sys...sExplorer.mspx

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Chris Shearer Cooper" wrote:

Hi,

Probably MSSQL Server service is set to AUTOMATICALLY start. If you do not
want SQL Server to run then go to Control Panel -- Services -- Microsoft SQL
Server-
Stop the service and then Double click on the service and disable it. This
will ensure that SQL Server will get started.

How can I find out who started it?

Just go look the security Log...Not sure it might have that information.

Is there a way to connect to SQL server, and ask it what connections it
has currently (or what connections it's had recently)?

Login to SQL Server using SSMS (SQL 2005) or Query ANalyzer (SQL 2000) and
execute SP_WHO to get the list of connections.//

Thanks
Hari



"Chris Shearer Cooper" <chrisnews (AT) sc3 (DOT) net> wrote