Error installing SQL2005 SP2

I'm trying to install SP2 for SQL 2005 on Win 2003 sp1. Right now 2005 is installed as a named instance with a 2000 instance running on the same box.

I get this in the log files:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Wed May 23 10:09:03 2007
<Func Name='Do_sqlPerfmon2'>
Error copying file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf-DTSSVCPERF.INI). Error code 2
MSI (s) (5C!64) [10:09:03:671]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:688]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:688]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1603
MSI (s) (5C!64) [10:09:03:723]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:740]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:740]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (5C!64) [10:09:03:740]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

<EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'>
MSI (s) (5C:38) [10:09:03:757]: User policy value 'DisableRollback' is 0
MSI (s) (5C:38) [10:09:03:757]: Machine policy value 'DisableRollback' is 0
Action ended 10:09:03: InstallFinalize. Return value 3.

Can you please check to see if you have the appropriate permissions for the DTSSVCPERF.INI. The error seems to indicate there is a problem copying the file.

Error copying file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf- DTSSVCPERF.INI). Error code 2

|||upon closer inspection I seem to be missing that file for some reason... how do I get it back?
|||Do you have any other server where in you can check to see if you can copy it from there?. I am not sure how the file went missing in the first place. If you dont have any other server then I would suggest that you perform a fresh installation of SQL 2005 on a test box and copy it to your production server.

Error ID 18456 SBS2003 with SQL2005

Hi @.all

We have a SBS2K3 with SQL2k5.

On every Startup we get the following Error:

Ereignistyp: Fehlerüberw.
Ereignisquelle: MSSQL$SHAREPOINT
Ereigniskategorie: (4)
Ereigniskennung: 18456
Datum: 17.10.2006
Zeit: 00:20:25
Benutzer: NT-AUTORIT?T\NETZWERKDIENST
Computer: PDC
Beschreibung:
Fehler bei der Anmeldung für den Benutzer 'NT-AUTORIT?T\NETZWERKDIENST'. [CLIENT: 192.168.2.250]

Weitere Informationen über die Hilfe- und Supportdienste erhalten Sie unter http://go.microsoft.com/fwlink/events.asp.
Daten:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 0f 00 00 00 50 00 44 00 ....P.D.
0010: 43 00 5c 00 53 00 48 00 C.\.S.H.
0018: 41 00 52 00 45 00 50 00 A.R.E.P.
0020: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0028: 00 00 07 00 00 00 6d 00 ......m.
0030: 61 00 73 00 74 00 65 00 a.s.t.e.
0038: 72 00 00 00 r...

The Client: 192.168.2.250 is the SBS itself with the internal LAN NIC (the SBS have 2 NIC′s for WAN and LAN)

The NT-Authority\Networkservice is in Logon of the DB and have dbcreate and dbsecurity rights.

What can we do?

regards.

Can you paste the error from the ERRORLOG file and translate the German into English? The error state will be very helpful in determining what is going on (see http://msdn2.microsoft.com/en-us/library/ms366351.aspx).

Thanks
Laurentiu

Error handling/Error description (SQL2005)

Is there a better/simpler way than mine to get the error description in the
default_language of the current_user for a given message_id?
DECLARE @.ErrNo INT
SET @.ErrNo=21
SELECT [error description]=sys.messages.[text]
FROM sys.messages inner join sys.syslanguages ON language_id=msglangid,
sys.server_principals
WHERE sys.messages.message_id=@.ErrNo AND
sys.syslanguages.[name]=sys.server_principals.[default_language_name] AND
sys.server_principals.[name]=SYSTEM_USER
Thanks in advance.This is slightly shorter:
DECLARE @.ErrNo INT
SET @.ErrNo=21
SELECT m."text" AS "error description", *
FROM sys.messages AS m
INNER JOIN syslanguages AS l ON l.msglangid = m.language_id
WHERE m.message_id=@.ErrNo
AND l.langid = @.@.LANGID
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"LX" <tsld99@.gmail.com> wrote in message news:%23tM15l5cGHA.3900@.TK2MSFTNGP05.phx.gbl...[co
lor=darkred]
> Is there a better/simpler way than mine to get the error description in th
e
> default_language of the current_user for a given message_id?
> DECLARE @.ErrNo INT
> SET @.ErrNo=21
> SELECT [error description]=sys.messages.[text]
> FROM sys.messages inner join sys.syslanguages ON language_id=msglangid,
> sys.server_principals
> WHERE sys.messages.message_id=@.ErrNo AND
> sys.syslanguages.[name]=sys.server_principals.[default_language_name] AND
> sys.server_principals.[name]=SYSTEM_USER
> Thanks in advance.
>
>[/color]