Hello all,
For the last few weeks I have been trying to Repackage SQL Server 2005 for the last few weeks. Has anybody had sucess repackaging this software. I have tried a bunch of the free repackagers and none have repackaged successfully for me. Is this one peice of Software I should get a real repackager for? My intentions are to deploy via Group Pollicy. If there is a better way to do this let me know Thanks Andrew
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Hello Andrew.
I have been doing the same with SQL 2005 Express (may not be the same that you have tried to package) with SQL Server Management Studio Express.
First I did an administrativ installation (from SQLEXPR_ADV.EXE), then I run a silent installation with the components that I want to install.
"setup.exe /qn ADDLOCAL=SQL_Data_Files,SQL_SSMSE INSTANCENAME=SQLExpress".
I distribute this with SMS 2003.
If you want to deploy it with Group Policy I would recommend you to make a msi-file with a Custom Action that executes the setup.exe with your selection of components.

I got a problem with my package when distributing with SMS 2003, when I start Management Studio, I get a warning sound and a empty dialog box with a OK buttion on it, and I dont know how to get rid of it, I get it every time I start Management Studio, but the application seems to run fine.
If I do the installation manualy it works fine. I have checked the event viewer and the applications install logfiles and compared it with a manualy installation and theres is no difference....
I also tried to exclude the Management Studio from the SMS 2003 installation and put it on afterwards, but I still get the warning sound and the empty dialog box.... Anyone have any suggestions??

/M.N
Answered 10/22/2007 by: Mackan75
Orange Belt

Please log in to comment
0
Hi Marcus,

Have you ever read Ian's (VBScab) signature? [;)]
Process Monitor should help you in finding what is missing or triggering the message box.
Answered 10/23/2007 by: AngelD
Red Belt

Please log in to comment
0
Wow...I don't even need to respond now: I have proxies to do it for me. Sweet!
Answered 10/23/2007 by: VBScab
Red Belt

Please log in to comment
0
Hey AngelD & VBScab. (yepp read it, and laughted at it :))
This was 2-3 weeks ago, but I think I used both regmon/filemon to check the error, but it didnt give any good answers.
The thing is that in the tests I have done was done with an admin account... I will test regmon/filemon or procmon again.

/M.N
Answered 10/23/2007 by: Mackan75
Orange Belt

Please log in to comment
0
Execute Process Monitor with "Run As" and run the application as the normal user if non-admin users are having the problem.
Answered 10/23/2007 by: AngelD
Red Belt

Please log in to comment
0
most of the newer MS stuff can be packaged from the software itself.

in the newer apps there is an Admin mode which allows transform creation.

If there is a setup "folder" under the main folder which contains another setup file.

try running that with /admin switch.

ie setup /admin

this kicks into an ORK style configuration screen which allows transform generation. (works on Visual Studio 2005 id be surprised if it didn't work with SQL as well haven't tried it but)
Answered 10/23/2007 by: jmcfadyen
Fifth Degree Black Belt

Please log in to comment
0
My apologies the correct command line is actually

/CreateTransform=your.MST

Doesn't seem to work on SQL 2005 I figured I should test it before handing over the advice.

/CreateTransform puts many of the other late MS products into administrator mode allowing admin type functions to be performed.
Answered 10/23/2007 by: jmcfadyen
Fifth Degree Black Belt

Please log in to comment
0
I tried that and it didnt work. Any other sugestions? Thanks
Answered 10/30/2007 by: a9a1c1
Yellow Belt

Please log in to comment
0
Just finished this package with SP1.
I found Wise crashing when compiling so ended up using Orca.

Created admin install point with SQL 2005 install.
See this blog::
http://blogs.msdn.com/heaths/archive/2006/12/16/slipstreaming-visual-studio-2005-service-pack-1.aspx
Disbaled the MaxPatchCacheSize
Applied patch to install point (it took a looonng time)
In Orca deleted:
CA_LaunchCondition_4.3643236F_FC70_11D3_A536_0090278A1BB8
CA_LaunchCondition_6.3643236F_FC70_11D3_A536_0090278A1BB8
Changed ALLUSERS=1
Added our PIDKEY value and ROOTDRIVE=C:\

That's it basically. We have a large list of dependencies for this package in the GPO so as long as they are installed correctly beforehand (takes about 10 minutes) this install (VS 2005 SP1) takes about 20 mins on our boxes.

Regards
Wayne
Answered 10/30/2007 by: WayneB
Blue Belt

Please log in to comment
0
Hi.
I only get the problem when deploying with SMS2003 and I havnt got so far to test it with an non-admin account.

I have found a thing when using filemon... First the application tries to "query information" from "C:\windows\microsoft.net\framework\v2.0.50727\mscorlib.tlb" and gets a success, direct after that it does a new query for "C:\windows\microsoft.net\framework\??????\mscorlib.tlb" and for obvious reason it fails, I get "name invalid" as result. I only get this when deploying wiht SMS2003, not if I install it myself, then I only get the first "query information".

I looked in the registry on the machine where I deployed it with SMS2003:
HK_LM\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb Tlbpath=%windir%\Microsoft.net\Framework\%CLRVERSION%\mscorlib.tlb and think that it doesnt find the %CLRVERSION%, but when checking on the manually installed I find the same registry key..
Any ideas??

/Mackan
Answered 11/05/2007 by: Mackan75
Orange Belt

Please log in to comment
0
G'Day Mackan75,
Try this link and see if this goes towards helping your issue:
http://blogs.msdn.com/astebner/archive/2005/08/09/449720.aspx

Are you allowing VS2005 to install the .net 2.0? Try deploying .net 2.0 prior to VS2005 separately. Depending on what's already installed on the machine .net 2.0 runs optimisation on all assemblies installed; see this link:
http://blogs.msdn.com/astebner/archive/2005/10/03/476706.aspx

Good luck,
Wayne
Answered 11/05/2007 by: WayneB
Blue Belt

Please log in to comment
0
Hi Mackan ,
This is sumit here,i have been traying to repcakge the sql server 2005 enterprise edition,I found out the setup.exe file has msi within that,but i was not able to find the sql.cab file.
Can u tell how did u got the msi from the setup.exe??
One more doubt i have is which setup.exe to use (from tools folder or from server folder)??
Any help will be appreciated.
Thanks and regards
sumit
Answered 11/05/2007 by: sumitsingh1984
Second Degree Green Belt

Please log in to comment
0
Hi WayneB
We are deploying both .net 2.0 & 3.0 with a role in BDD in the SMS 2003/SQL server (RolePackages in BDDAdminDB) so they go on during the installation of the machine, I deploy SQL 2005 with a normal Collection that has a Query to a Group in the Active Directory.
I found a work-around... I change the variable %CLRVERSION% to the actually name of the folder "v2.0.5.0272", then the application only tries the "query information" once and it works fine.
I´ll probably make an new program in the SQL 2005 package thats run regedit with a .reg file that does the change after the SQL installation has finished.
Thanx for the links :-)

Hello sumitsingh1984!
It seems that we have different versions of SQL, I´m installing SQL 2005 Express Advanced, and it looks lite you are installing SQL Enterprise Edition, so I dont know if this will be of any help, but here goes:
I got the media for SQL 2005 as a executable zipfile (SQLEXPR_ADV.EXE), when you run it it will first make a folder in C:\ were it will extract the files & folders, you can copy the files & folders from there to were you want it, I got a file called $shtdwn$.req that "were in use" so I couldnt copy that, but I dont think it is needed.
Among the files & folders that get extracted I got a folder called setup with a lot of msi, cabs and some msp files, I dont find a sql.cab file though...
I hope that you can do someting like I did, even that we dont have the same variant of SQL 2005.

/Mackan
Answered 11/05/2007 by: Mackan75
Orange Belt

Please log in to comment
0
Hi ,
Thanks for replying.
Can u please let me know what command u used for extracting the setup.exe??
I have tried with /x,/a,/c all of these does not work??
Any other options for extracting the setup.exe ??
Looking forward to hear from you.
Thanks and regards
sumit
Answered 11/06/2007 by: sumitsingh1984
Second Degree Green Belt

Please log in to comment
0
Hi.
I did not use any command, when I executed the compressed exe-file it automatically started setup.exe, and I did not have to use any variant of /x or /a.
Remember you seem to have SQL 2005 Enterprise, I have SQL 2005 Express.

/Mackan
Answered 11/06/2007 by: Mackan75
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity