Service Pack 3 failed!

[Guest_imported]

Hello,

We tried to install Service Pack 3 on SQLServer(7.00.623) on Window2000 Terminal Server. It didn't raise any errors
while installing. After installing we checked the version of sqlserver using "SELECT @@VERSION" command. But it is

still showing below said message.

"Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Oct 24 2000 18:39:12
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)"

We also cheked in Log file. Here are the 2 errors.
********************************************************
06:24:19 Begin Action: Self Registration
06:24:25 Failed to register files c:\MSSQL7\Binn\dtsui.dll
06:24:25 End Action: Self Registration

06:24:54 C:\WINNT\TEMP\_ISTMP15.DIR\osql.exe -n -d master -i "c:\MSSQL7\install\upgrade.sql" -U sa -P
06:25:16 Process Exit Code: (6006) There are no EFS keys defined for the user.
********************************************************
Except this, every statement exit code is (0).

Please help me in this problem.

Thanks in advance,
V.Thandava Krishna.

 

[RickCole]

I've not come across this error before so can't help there but if your post is correct and according to @@version your server is actually running service pack 3. Here are the actual translations:


+---------------------------------------------------------+
| @@VERSION | SQL Server version |
+---------------------------------------------------------+
| 7.00.623 | Original SQL Server 7.0 or MSDE 1.0 release |
+---------------------------------------------------------+
| 7.00.699 | Database components SP1 |
+---------------------------------------------------------+
| 7.00.842 | Database components SP2 |
+---------------------------------------------------------+
| 7.00.961 | Database components SP3 |
+---------------------------------------------------------+


Rick.