Showing posts with label failure. Show all posts
Showing posts with label failure. Show all posts

Tuesday, March 27, 2012

Error installing SQL Server 2005 SP1 - Reporting Services - log excerpt included

Hello, any information about this issue would certainly be appreciated! I've been trying to install SP1 for my SQL Server 2005. There is a failure for the reporting services which appears in the following text from the log:

--

MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Executing op: CacheBaselineFile(Baseline=0,FileKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,FilePath=C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\Bin\ReportingServicesWebUserInterface.dll,,Existing=1)
MSI (s) (7C:38) [13:43:05:433]: Note: 1: 2318 2: C:\WINDOWS\Installer\$PatchCache$\Managed\E281BDB31738DB64CA931CA4195DEE8F\9.0.1399\RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587
MSI (s) (7C:38) [13:43:05:621]: Executing op: FileCopy(SourceName=WebUse~1.dll|ReportingServicesWebUserInterface.dll,SourceCabKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,DestName=ReportingServicesWebUserInterface.dll,Attributes=20992,FileSize=1235744,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=9.0.2047.0,Language=0,InstallMode=58982400,,,,,,,)
MSI (s) (7C:38) [13:43:05:621]: File: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\Bin\ReportingServicesWebUserInterface.dll; Overwrite; Won't patch; Existing file is a lower version
MSI (s) (7C:38) [13:43:05:621]: Source for file 'RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587' is compressed
MSI (s) (7C:38) [13:43:05:636]: Re-applying security from existing file.
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2318 2: C:\Config.Msi\73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Using source file security for destination.
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 1310 2: 5 3: C:\Config.Msi\73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 1310. Error writing to file: C:\Config.Msi\73537e.rbf. System error 5. Verify that you have access to that directory.

Error 1310. Error writing to file: C:\Config.Msi\73537e.rbf. System error 5. Verify that you have access to that directory.
MSI (s) (7C:38) [13:43:05:730]: User policy value 'DisableRollback' is 0
MSI (s) (7C:38) [13:43:05:730]: Machine policy value 'DisableRollback' is 0
Action ended 13:43:05: InstallFinalize. Return value 3.
MSI (s) (7C:38) [13:43:05:746]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=892169565,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 Reporting Services)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\73536e.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\73536f.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735370.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735371.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735372.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735373.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735374.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735375.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735376.rbf)

--

Please note that I develop reports locally against a database on another server; would this be part of the problem? Let me know if you need more info, too. Thanks.

Hi !

Did you check the following ones:

You receive an "Error 1303. The installer has insufficient privileges to
access this directory" error message when you
http://support.microsoft.com/default.aspx?scid=kb;en-us;228658


You receive the "Error 1303" error message when you try to install
http://support.microsoft.com/default.aspx?scid=kb;en-us;836194


HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||Hi Jens, the first link was the problem! The install completed successfully now. Thank you for your help!

Friday, February 24, 2012

error in connection

Hi

i am trying to connect my application with SQL SERVER. but

it gives error as below.

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Please reply me soon.

Best regards,
ASIFU have to enable remote connections in SQL 2005 if u want to connect from remote clients.

1) Open SQL 2005 Surface Area configuration-->Surface Area configuration for Services and connections -->Database Engine-->Remote Connections-->Enable Local and remote connections.

2) Enable the protocol from SQl Server Configuration manager which u are using(in ur case 'Named Pipes').
To do that,
SQl Server Configuration manager -->SQL server 2005 Network Configuration-->Protocols for SQl2005-->Enabe Named Pipes.