Remote execution sql_server cookbook


#1

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