Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

sql

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!

Error in Replication how to continue

I have transactional Replication from A to B.

My distribution agent failed becos of a primary key violation error in a table.[i have not included the skip error option].

Then the replication stopped.
The transactions on other tables are also not replicated to B.

IF an error is encountered in one of the tables will the replication stop entirely??.Is there no way for the replication to continue for the rest of the tables..
Pls clarifyI don't think you can skip this error. To use Replication you have to have a primary key in the table you want to replicate.|||The transactions are processed in a serialized fashion, meaning that if one failed nothing else goes through.

error in execution time

hi all

i am working in sql reporting 2000.

In my report i have included field to display the execution time.

That time is not changing if i am running the report again & again.

Its only showing the time at which report was run first time in current Internet Explorer window.

how can i get current time in report?

plz help me.

In your text box, put this:

="Report Created On: " & Globals.ExecutionTime

|||

Thanks for reply.

I am already using Globals.ExecutionTime to display execution time in my report .

But if i am rexecuting the report then also time is not getting updated.

If i am running other report & after that report if i am running this report then also its showing the last time at which the report was executed.

So what is the solutin for this?

Plz help me

|||The reports might have been cached on the server if you specifically have set it to keep the last run report. So it may not be running the report, but instead getting the last cached report. I haven't tinkered with the settings, but it's an idea. You might want to check the report properties and then the execution tab..