logging server configuration changes

Hi,
Does anyone know if SQL Server 2000 sp3a log server configuration
changes. I am acting as a dba for a client and the old DBA added Named
Pipes as a protocol to a production database without following
protocol.
My supervisor wants me to track down when this was done. I am not sure
if it even possible unless the change is logged somehow. I checked the
SQL server logs but there seems to be no entry.
Can someone point me in the right direction or at least verify that
this change was never logged.
Thanks
Mike.Hi
There is no specific logging of these events, you may want to check the SQL
Server log and the Windows Event Log for Names pipes starting, although if
this was done some time ago the original change may not be there. SQL 2005
logs Event ids 26028 and 26048 in the Windows Application Event log when
named pipes are started.
John
"MD" <miked1119@.gmail.com> wrote in message
news:1145301860.104228.88070@.e56g2000cwe.googlegroups.com...
> Hi,
> Does anyone know if SQL Server 2000 sp3a log server configuration
> changes. I am acting as a dba for a client and the old DBA added Named
> Pipes as a protocol to a production database without following
> protocol.
> My supervisor wants me to track down when this was done. I am not sure
> if it even possible unless the change is logged somehow. I checked the
> SQL server logs but there seems to be no entry.
> Can someone point me in the right direction or at least verify that
> this change was never logged.
> Thanks
> Mike.
>|||If you have the backp of old SQL Server log files may be you can find the
following entry:
SQL server listening on TCP, Shared Memory, Named Pipes.
This part in the error log indicates what all protocols have enabled for the
SQL Server.
jAj
"MD" <miked1119@.gmail.com> wrote in message
news:1145301860.104228.88070@.e56g2000cwe.googlegroups.com...
> Hi,
> Does anyone know if SQL Server 2000 sp3a log server configuration
> changes. I am acting as a dba for a client and the old DBA added Named
> Pipes as a protocol to a production database without following
> protocol.
> My supervisor wants me to track down when this was done. I am not sure
> if it even possible unless the change is logged somehow. I checked the
> SQL server logs but there seems to be no entry.
> Can someone point me in the right direction or at least verify that
> this change was never logged.
> Thanks
> Mike.
>