March 25, 2010 at 7:30 am
Hello everyone i am new to these forums and partially new to SQL server.
Question: I am trying to install KB956717 on a windows xp embedded box. This system already has sql and windows installer 4.5 installed on the box and everything is working fine. This KB Hotfix helps us with reporting services issue that we encountered. The problem i am having is that when i go to install this KB hotfix it starts by unpacking all the files to a random location. Then when it is doing the MSItiming packages it states that a resource could not be found and asks for a sql_common_core.msi file. Well i located where it is but its not an MSI file it is a MSP file. I can not get the kb hot fix to complete the upgrade of my sql server instance. If you need more information i can provide this.
I have also tried unpacking the kb hotfix using the /X command and then running setup but i can not seem to determine which file to start manually.
The exact error is:
the feature you are trying to use is on a network resource that is unavailable
Then it states its looking for SQL_COMMON_CORE.msi. It appears the path its looking for it is in C:\xxxxxxx however it extracted to d:\xxxxxxxx.
Thanks in advance
March 25, 2010 at 7:40 am
When you originally install SQL server, where did it install from? perhaps it's looking for the original MSI? I've seen issues where a custom installer was used and applying updates became somewhat problematic, without access to the original installer. This was with previous versions however...
I would think that this would be a covered support call to MS although they may just direct you to install SP1 for SQL 2008 instead. Any reason why you are installing CU1 instead of SP1?
-Luke.
March 25, 2010 at 7:48 am
We have found that a drill down feature in a report we designed will not work if u jump straight to SP1. One would think that SP1 would cover CU1 and resolve this issue but we found that putting SP1 and not CU1 this feature does not work.
I installed this sql server 2008 by running the install on the local machine not over the network.
Im at a loss as to why it wont install the hot fix.
March 25, 2010 at 7:52 am
What about if you skip CU1 and go to CU2, they are "supposed" to be cumulative right? Odd that the fix you were looking for in CU1 isn't in SP1. Either way I'd think this would probably be a free PSS call.
March 25, 2010 at 9:04 am
ive requested and started download CU2 i will attempt to install this and see if the reporting issue is resolved obviously i can install this CU.
thanks for the suggestion.
Im unsure why the CU1 is not included or appears not included in SP1 but i know if we update from 1600 to straight to SP1 our report wil not be able to drill down.
March 25, 2010 at 9:11 am
if you are having issues with a report drilling correctly, you could post appropriate information about it and the issues you are seeing in the SSRS forum here and someone may have some suggestions for you.
-Luke.
March 25, 2010 at 11:54 am
I believe i figured it out.
I unpacked the SQLEXPRADV_x86_ENU.exe into a folder which contained all the files needed to install SQL08 Express with Adv Svcs. In this folder were the MSI files that the CU1 patch was looking for.
I used the patch CU1 and pointed it to those specific files in the Unpacked SQLEXPRADV_x86_ENU.exe folder. This upgraded the sql server to the CU1.
According to sql server it is patched to this CU1 patch version. I will be testing the reports out when i recieve a database to test with and i will post results.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply