[chef] Fwd: remote execution sql_server cookbook - big fail

[Olaf Heydorn < >]

Hi Razvan,

sorry for my late answer.

Remote execution and installation of microsoft sql server 2008 on windows 2008 isn't working. Nether via knife ssh nor via knife winrm.

The installer is doing ui calls during the silent installation, but there isn't any ui at all. That's why it's not working via knife ssh. Knife winrm has

another error. There is a new path for the security store on windows 2008 and winrm has no full user profile during the run:

Microsoft's own remoting framework (WinRM) is not able to do a silent install of 
SQL Server 2008. The installation fails with security errors,which only appear 
on remote installations (WinRM and SSH), local installations with a proper environment 
(local login / RDP) are working OK. Other remote management frameworks are failing, 
too. 

Likely root cause: 

The SQL server installer was designed for server 2003 fs layout (c:\Documents and Settings (2003) and not c:\Users (2008) ), 
when running under a full login microsoft provides a mapping from the old style directories to the new style. 
When logged in remotely those mappings are not in place. 

If you have any other solution please send me any information.

Regards,

Olaf

---------- Forwarded message ----------
From: < "> >
Date: Wed, Feb 29, 2012 at 6:32 PM
Subject: [chef] remote execution sql_server cookbook
To: ">


Hi,

I still have problems with the sql_server cookbook (SQL Server 2008 R2
Enterprise) and execution via knife ssh or knife-windows (winrm). Chef-client
run with sql_server::server cookbook is successfull, if it is executed on the
machine itself, but if it's executed via knife ssh or knife-windows, I get
different errors like via winrm 2.0:
System.Security.Cryptography.CryptographicException: Access is denied. during
xml creation.

or via knife ssh: GUI errors, but the installation itself is a silent
installation with all gui options turned off.

I think the installer itself isn't a silent as it should be and is doing silent
gui calls in the background. Or is this wrong?

The second question I have is ,that the sql server 2008 r2 installer, which I
got from the msdn download page is a selfextracting archive, which ask for a
destination directory, which couldn't be set via any option and the sql_server
passes the silent installation response file directly to the download file. Did
anyone tested this with sql server 2008 r2?

Maybe anyone has already played around with it.

Thanks.

Olaf Heydorn