Error starting SQLserver on windows 2000

When starting the SQLserver service on a windows 2000 server, we get
following error:
17050 :
initerrlog: Could not open error log file
's:\MSSQL8\MSSQL\log\ERRORLOG'. Operating system error = 3(error not
found).
We're running SQL 2000 std ed.. This is no cluster, access rights on
file are correct, the file is not locked by another process.
I've compared registry settings with a working server (same config) and
there identical.
registry setting:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
"SQLArg0"="-ds:\\MSSQL8\\MSSQL\\data\\master.mdf"
"SQLArg1"="-es:\\MSSQL8\\MSSQL\\log\\ERRORLOG"
"SQLArg2"="-ls:\\MSSQL8\\MSSQL\\data\\mastlog.ldf".
There's a local d, e and l-drive (No SAN)
Anyone has an idea what's going wrongHi Olivier
The parameters are expecting a S drive, where are the files supposed to be?
You could start sqlservr.exe from the command prompt and specify the correct
file names, see the topic "sqlservr Application" in Books Online and change
the values through Enterprise Manager, if you don't want to change the
registry directly.
John
"sqlservr Application"
"olivier.lammens@.gmail.com" wrote:
> When starting the SQLserver service on a windows 2000 server, we get
> following error:
> 17050 :
> initerrlog: Could not open error log file
> 's:\MSSQL8\MSSQL\log\ERRORLOG'. Operating system error = 3(error not
> found).
> We're running SQL 2000 std ed.. This is no cluster, access rights on
> file are correct, the file is not locked by another process.
> I've compared registry settings with a working server (same config) and
> there identical.
> registry setting:
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
> "SQLArg0"="-ds:\\MSSQL8\\MSSQL\\data\\master.mdf"
> "SQLArg1"="-es:\\MSSQL8\\MSSQL\\log\\ERRORLOG"
> "SQLArg2"="-ls:\\MSSQL8\\MSSQL\\data\\mastlog.ldf".
> There's a local d, e and l-drive (No SAN)
> Anyone has an idea what's going wrong
>