Fwd: remote execution sql_server cookbook - big fail


#1

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: oheydorn@gmail.com
Date: Wed, Feb 29, 2012 at 6:32 PM
Subject: [chef] remote execution sql_server cookbook
To: chef@lists.opscode.com

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