Distribution of SQL-Server Management Studio 2008 (not express)

[kugman]

Hi there

 

i have problems with the distribution of the SSMS 2008 R2 via SCCM

 

First of all. I'm not talking about SQL Express or the Express Management Studio. I'm talking about the SQL Server 2008 Enterprise DVD (R2).

I copied the entire DVD to the Network share, that can be accessed by the sccm.

 

then I created a package with the programm "installation" with the following parameter:

"setup.exe /QS /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=SSMS,ADV_SSMS /HIDECONSOLE" (source: www.appdeploy.com)

Then I advertised it and made it not mandatory, so I can start the installation process from within "run advertised programs"

 

problem: setup starts but exits after 15 seconds with status failed. I can't find anything in any logfiles, exept in smscliui:

 

Could not find the policy in WMI for package program smscliui 23.01.2012 12:46:15 4172 (0x104C)

 

 

Who has distributed SSMS successful with SCCM and can give me a hint?

 

thanks

Markus

[wmmayms]

Im using this command line successfully: setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /features=ssms /HIDECONSOLE

 

This will only install the management studio though =)

[kugman]

unfortunately this didn't work for me...

[wmmayms]

Try these wrappers

If they don´t work check your media..and then run the scripts without silentflagg to see if the setup is prompting a specifik error..

 

PS: I know it was hell getting this to work properly..

 

Install.vbs:

 

 
On Error Resume Next
Set oShell = CreateObject("WScript.Shell")
Set ofso = CreateObject("Scripting.FileSystemObject")
strWinDir = oShell.ExpandEnvironmentStrings("%SYSTEMROOT%")
sDest =  oShell.ExpandEnvironmentStrings("%ALLUSERSPROFILE%") & "\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008"
strUserAppDir = oShell.ExpandEnvironmentStrings("%LOCALAPPDATA%")
oShell.CurrentDirectory = oFSO.GetParentFolderName(Wscript.ScriptFullName)
scriptpath=oShell.CurrentDirectory + "\"


App1="""" & scriptpath & "setup.exe" & """" &" /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /features=ssms /HIDECONSOLE"
App2=""

RunnApp1 = oShell.Run(App1, 1, true)
'RunnApp2 = oShell.Run(App2, 1, true)


strShortcut = sDest & "\Configuration Tools\SQL Server Installation Center.LNK"
' msgbox strShortcut
If ofso.FileExists(strShortcut) Then ofso.DeleteFile(strShortcut)
If ofso.FolderExists(sDest) Then ofso.DeleteFolder(sDest)
If ofso.FolderExists(sDest) Then ofso.DeleteFolder(sDest)            

wscript.quit 0

 

uninstall.vbs:

On Error Resume Next
Set oShell = CreateObject("WScript.Shell")
Set ofso = CreateObject("Scripting.FileSystemObject")
strWinDir = oShell.ExpandEnvironmentStrings("%SYSTEMROOT%")
strUserAppDir = oShell.ExpandEnvironmentStrings("%LOCALAPPDATA%")
oShell.CurrentDirectory = oFSO.GetParentFolderName(Wscript.ScriptFullName)
scriptpath=oShell.CurrentDirectory + "\" 


App1="""" & scriptpath & "setup.exe" & """" &" /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=uninstall /features=ssms /HIDECONSOLE"
App2="MsiExec.exe /X {4AB6A079-178B-4144-B21F-4D1AE71666A2} /qb"
App3="MsiExec.exe /X {3A9FC03D-C685-4831-94CF-4EDFD3749497} /qb"
App4="""C:\Windows\Microsoft.NET\Framework\v2.0.50727\Microsoft Report Viewer Redistributable 2008 (KB971119)\install.exe""" & " /qu"

RunnApp1 = oShell.Run(App1, 1, true)
RunnApp2 = oShell.Run(App2, 1, true)
RunnApp3 = oShell.Run(App3, 1, true)   
RunnApp4 = oShell.Run(App4, 1, true)    

wscript.quit 0