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
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.