[chef] RE: RE: RE: Issues with SQL Server 2008 R2 Recipe

["Vinayak, Gaurav" < >]

One thing that I have noticed is that that the recipe is unable to create the 
required SQL Server Service on the target machine.

I can see the SQL server package there though.


Thanks & Regards,

Gaurav Vinayak
IT Strategic Innovation Services
NetApp, Inc.
it.netapp.com
cloud.it.netapp.com
office: 91 120 244 5144 ext 4503
mobile: 408-355-6052, 91-99104-33692

 

nCloud FAQ
nCloud User Manual




-----Original Message-----
From: Vinayak, Gaurav 
[mailto:
 
 
Sent: 05 June 2014 23:11
To: 

 ;
 

 
Subject: [chef] RE: RE: Issues with SQL Server 2008 R2 Recipe

Thanks for responding Adam!

Please find attached the logs for chef client run & also the winrm 
configuration parameter.


Regards,
Gaurav

________________________________________
From: Adam Edwards 
<
 >
Sent: Thursday, June 5, 2014 8:56 AM
To: 

 
Subject: [chef] RE: Issues with SQL Server 2008 R2 Recipe

Gaurav, do you have a log from the Chef run? That would point to clues.
One issue I've seen with sql server is that it uses a lot of memory (it will 
basically allocate as much memory as physical ram on your system for 
performance reasons), and since knife-windows is executing over winrm, you 
can run afoul of WinRM's memory restrictions. You could try setting 
maxmemorypershellmb to something huge, say larger than physical ram on the 
system.

Thanks.

-Adam

-----Original Message-----
From: Vinayak 
[mailto:
 
Sent: Thursday, June 5, 2014 12:04 AM
To: 

 
Subject: [chef] Issues with SQL Server 2008 R2 Recipe


Guys,

I am using the latest version of SQL Server Cookbook i.e. 2.2 on the chef 
community & the chef-client version is 11.12.4.

Issue:

Even after successful execution of the recipe & i don't get to see the SQL 
Server Installed on the target box whereas IIS got installed flawlessly.

I am using the knife windows plugin for bootstrapping.

Target Box OS - Win 2008 R2 64-Bit.


Anybody faced similar issue or can advise what's wrong here?


Regards,
Gaurav Vinayak