Thursday, March 29, 2012

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.

No comments:

Post a Comment