SQL Server Service Deployment Error (SCVMM 2012)
-
Sunday, May 20, 2012 3:42 PM
brief details of activity performed in SCVMM 2012 for 2 Tier Service Template ( included SQL Profile and Web application).
Activity performed
- Created NEW VM with Windows 2008 R2 SP1 OS.
- Power off the VM and Converted it to Template
- Copy the syspreped VHD from template to VHD folder in SCVMM library.
- Deleted Template and its VHD
- Created SQL Profile and put the path of SQL media from Local Drive
- Configured the Authentication method and Set run as Accounts for SQL Services.
- Created Custom VM Template
(a) Added sysprep VHD in it.
(b) Set logical Switch in it.
(c) Set Local Admin user.
(d) Set Domain information and its credentials to join domain.
(e) Attach SQL Profile in it.
- Created 1 Tier Service Template.
- Drag and Drop the created VM Template in Service Template.
- Save and Validate the created Service Template.
- Click on Custom Deployment and Set the name of Service.
- Define the Path for VM deployment ( cloud/ Hyper-V host Group)
- Deploy the Service.
- VM creation is done but Error in job at 99 %.
Details of Errors in Job
Error (22042)
The service (SQLWOSTDSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\70167c36-c325-41ec-beba-d1a67baee833\sqlHost.cmd) was executed on the computer (ServiceVM00001.dcs.org) and returned a result exit code (-2068643838).
Error (22557)
VMM could not install the SQL Server instance on the guest virtual machine (ServiceVM00001.dcs.org).
Recommended Action
The installation of the SQL Server instance will be skipped on job restart. Log on to the virtual machine and look in the time-stamped event logs (%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\), and run SQL Server Setup (C:\SQL2008R2\setup.exe) again if needed..
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (SQLWOSTDSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
Error in Web Tier Deployment
Error (22042)
The service (WEBTIERSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Error (22525)
An operation for an application (Web Application 1, WebDeploy) failed on the virtual machine (ServiceVM00002.dcs.org). Detailed error message: ApplicationFrameworkNotInstalled;2.0.1070.
Recommended Action
Try the operation again.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (WEBTIERSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
Regards, Rishi
All Replies
-
Wednesday, May 23, 2012 8:58 PM
Had the same problem with a web tier, the solution was adding to the tier application configuration a Pre-Install script that will install the WebDeploy tool.
Executeable program: cmd.exe
Parameters: /q /c InstallWebDeploy.cmd
Script resource package: WebDeploy_x64_en-US_2.0.1070.cr / WebDeploy_x86_en-US_2.0.1070.cr
Regards,
Oren. -
Thursday, May 24, 2012 1:52 PM
Hi, Rishi
for the SQL VM the steps are:
1. Create VM and install window 2008
2. install SQL in Sysprep mode ( write down the installation instance ID , will be needed in deployment)
4. copy the SQL media to local VM disk ( write down the path, will be needed in deployment)
3. open firewall port 1433
4. Sysprep windows
take file to VMM lib and continue
Hikmat Kanaan Amman-Jordan MCSE
- Marked As Answer by Kristian NeseMVP, Moderator Saturday, May 26, 2012 5:34 PM
-
Saturday, May 26, 2012 5:34 PMModerator
You will also need to sysprep your SQL server - as Hikmat stated in his post.
After you have run through the sysprep process, VMM will complete the installation during deploymet by using the SQL Server Profile.
Kristian (Virtualization and some coffee: http://kristiannese.blogspot.com )
-
Wednesday, June 06, 2012 6:59 AM
hi Oren,
It is not working...
Error in Web Tier Deployment
Error (22042)
The service (WEBTIERSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Error (22525)
An operation for an application (Web Application 1, WebDeploy) failed on the virtual machine (ServiceVM00002.dcs.org). Detailed error message: ApplicationFrameworkNotInstalled;2.0.1070.
Recommended Action
Try the operation again.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (WEBTIERSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
Now, we are going to log call in Microsoft, We have SCVMM 2012 RC.
Thanks
Kirpal Singh
-
Wednesday, June 06, 2012 7:17 AM
Hi Hikmat,
It is not working, configured SQL Profile. and done mentioned steps.
.
Activity performed
- Created NEW VM with Windows 2008 R2 SP1 OS.
- Power off the VM and Converted it to Template
- Copy the syspreped VHD from template to VHD folder in SCVMM library.
- Deleted Template and its VHD
- Created SQL Profile and put the path of SQL media from Local Drive
- Configured the Authentication method and Set run as Accounts for SQL Services.
- Created Custom VM Template
(a) Added sysprep VHD in it.
(b) Set logical Switch in it.
(c) Set Local Admin user.
(d) Set Domain information and its credentials to join domain.
(e) Attach SQL Profile in it.
- Created 1 Tier Service Template.
- Drag and Drop the created VM Template in Service Template.
- Save and Validate the created Service Template.
- Click on Custom Deployment and Set the name of Service.
- Define the Path for VM deployment ( cloud/ Hyper-V host Group)
- Deploy the Service.
- VM creation is done but Error in job at 99 %.
Details of Errors in Job
Error (22042)
The service (SQLWOSTDSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\70167c36-c325-41ec-beba-d1a67baee833\sqlHost.cmd) was executed on the computer (ServiceVM00001.dcs.org) and returned a result exit code (-2068643838).
Error (22557)
VMM could not install the SQL Server instance on the guest virtual machine (ServiceVM00001.dcs.org).
Recommended Action
The installation of the SQL Server instance will be skipped on job restart. Log on to the virtual machine and look in the time-stamped event logs (%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\), and run SQL Server Setup (C:\SQL2008R2\setup.exe) again if needed..
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (SQLWOSTDSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
Thanks
Kirpal Singh
-
Wednesday, June 06, 2012 7:17 AM
Hi Hikmat,
It is not working, configured SQL Profile. and done mentioned steps.
.
Activity performed
- Created NEW VM with Windows 2008 R2 SP1 OS.
- Power off the VM and Converted it to Template
- Copy the syspreped VHD from template to VHD folder in SCVMM library.
- Deleted Template and its VHD
- Created SQL Profile and put the path of SQL media from Local Drive
- Configured the Authentication method and Set run as Accounts for SQL Services.
- Created Custom VM Template
(a) Added sysprep VHD in it.
(b) Set logical Switch in it.
(c) Set Local Admin user.
(d) Set Domain information and its credentials to join domain.
(e) Attach SQL Profile in it.
- Created 1 Tier Service Template.
- Drag and Drop the created VM Template in Service Template.
- Save and Validate the created Service Template.
- Click on Custom Deployment and Set the name of Service.
- Define the Path for VM deployment ( cloud/ Hyper-V host Group)
- Deploy the Service.
- VM creation is done but Error in job at 99 %.
Details of Errors in Job
Error (22042)
The service (SQLWOSTDSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\70167c36-c325-41ec-beba-d1a67baee833\sqlHost.cmd) was executed on the computer (ServiceVM00001.dcs.org) and returned a result exit code (-2068643838).
Error (22557)
VMM could not install the SQL Server instance on the guest virtual machine (ServiceVM00001.dcs.org).
Recommended Action
The installation of the SQL Server instance will be skipped on job restart. Log on to the virtual machine and look in the time-stamped event logs (%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\), and run SQL Server Setup (C:\SQL2008R2\setup.exe) again if needed..
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (SQLWOSTDSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
Thanks
Kirpal Singh
-
Wednesday, June 06, 2012 7:19 AM
-
Wednesday, June 06, 2012 7:49 AMIt is not working, please suggest something which would be helpful.
-
Wednesday, June 06, 2012 8:02 AM
This is to update you that we have troubleshooting many step but we got the error at 99% Job completed. VM is created with SQL profile but we received the error in jobs. Tomorrow we will troubleshoot some more step to resolved the error. We posted the error details in technet article also.
Please find the brief details of activity performed in SCVMM 2012 for 2 Tier Service Template ( included SQL Profile and Web application).
Activity performed
- Created NEW VM with Windows 2008 R2 SP1 OS.
- Power off the VM and Converted it to Template
- Copy the syspreped VHD from template to VHD folder in SCVMM library.
- Deleted Template and its VHD
- Created SQL Profile and put the path of SQL media from Local Drive
- Configured the Authentication method and Set run as Accounts for SQL Services.
- Created Custom VM Template
(a) Added sysprep VHD in it.
(b) Set logical Switch in it.
(c) Set Local Admin user.
(d) Set Domain information and its credentials to join domain.
(e) Attach SQL Profile in it.
- Created 1 Tier Service Template.
- Drag and Drop the created VM Template in Service Template.
- Save and Validate the created Service Template.
- Click on Custom Deployment and Set the name of Service.
- Define the Path for VM deployment ( cloud/ Hyper-V host Group)
- Deploy the Service.
- VM creation is done but Error in job at 99 %.
Details of Errors in Job
Error (22042)
The service (SQLWOSTDSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\70167c36-c325-41ec-beba-d1a67baee833\sqlHost.cmd) was executed on the computer (ServiceVM00001.dcs.org) and returned a result exit code (-2068643838).
Error (22557)
VMM could not install the SQL Server instance on the guest virtual machine (ServiceVM00001.dcs.org).
Recommended Action
The installation of the SQL Server instance will be skipped on job restart. Log on to the virtual machine and look in the time-stamped event logs (%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\), and run SQL Server Setup (C:\SQL2008R2\setup.exe) again if needed..
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (SQLWOSTDSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
Error in Web Tier Deployment
Error (22042)
The service (WEBTIERSRV) was not successfully deployed. Review the event log to determine the cause before you take corrective action.
Recommended Action
The deployment can be restarted by retrying the job.
Error (22525)
An operation for an application (Web Application 1, WebDeploy) failed on the virtual machine (ServiceVM00002.dcs.org). Detailed error message: ApplicationFrameworkNotInstalled;2.0.1070.
Recommended Action
Try the operation again.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (WEBTIERSRV). Check job logs to get more information on the failed operation.
Recommended Action
Check error messages and retry the operation if needed.
We are not interested for Petshop and we are not interested stock traders as they are not available now, we want to deploy SQL instance, SQL database, IIS package. Please suggest what we are missing, we are facing this issue from 2 months, we have logged advisory calls in microsoft, they are not interested to troubleshoot it, i think SQL Profile and Application Profile is wastage of time because manaul installation is easy.
and Noone is expert on it.
technet blogs are not helpful.
http://blogs.technet.com/b/scvmm/archive/2011/09/27/vmm-2012-sql-server-profile.aspx
http://kristiannese.blogspot.in/2011/07/understanding-service-concept-in-vmm.html
http://www.systemcentercentral.com/Default.aspx?tabid=143&IndexId=89033
Thanks
Kirpal Singh
-
Wednesday, June 06, 2012 10:13 AM
hi, Kirpal Singh
I have go through this hers is the setups and where is you problem:
the steps to setup SQL:
1. Install windows 2008R2SP1
2. Open firewall Rules for : port 1433 SQL
open ports for file sharing
3. install sql in Sysprep mode as my previous post
4. if you are using SQL2008R2 without SP1 please install the SQL DAC Framework
http://www.microsoft.com/en-us/download/details.aspx?id=24000
4.sysprep windows and shutdown
5. Copy the VHD to VMM library
6. Create SQL Profile use MSSQLSERVER for instance name , don't use other name because it create SQL instance and it does not listen on SQL Profiles
For the web tier Problem:
if this is an upgrade from VMM2012 Beta , most likely that the webdepoly.msi file that is located in your VMM library is out dated , please copy this file to anther machine and install it manually. in add and remove programs check the version of the webdeploy does not read 2.0.1070.
download the webdeploy.msi package from www.iis.net and copy it over the package that you have in VMM library.
I hope this will solve your problem.
please mark this as an answer if solved your problem :-)
My Post about this http://hikmatkanaan.wordpress.com/2012/06/06/troubleshooting-deploying-sql-2008r2-service-in-vmm-2102/
Hikmat Kanaan Amman-Jordan MCSE
- Edited by Hikmat Kanaan Wednesday, June 06, 2012 10:19 AM
- Edited by Hikmat Kanaan Wednesday, June 06, 2012 9:03 PM
- Proposed As Answer by kirpal.kaushal Tuesday, July 10, 2012 1:36 AM
-
Friday, June 15, 2012 2:39 PM
Hi Hikmat,
Suggested 6 points for SQL profile deployment are helpful. it solved this issue.
For Webdeploy msi, version is 2.0.1070, i have downloaded it from iis.net but it is lower than it. i haven't tried it yet, let u know the result asap.
Suppose i have configured Hardware,OS and SQL profile, Excluded Application profile, now i want to deploy SQL data tier via application profile and Web App via Application profile, tell me the steps to configure it.
Thanks
Kirpal Singh
-
Tuesday, June 19, 2012 12:16 PM
Hi Hikmat,
I have used downloaded and uploaded Webdeploy pacakage, now it is deploying but there is some errors.
Error (22042)
The service (WebTSRV1) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (cmd.exe /q /c InstallWebDeploy.cmd) was executed on the computer (wah3.dcs.org) and returned a result exit code (0).
Error (22521)
Application (Web Application 1, WebDeploy) installation failed on the virtual machine (wah3.dcs.org). DetailedErrorMessage: Site 'GAE' does not exist.. See the event log file (C:\ProgramData\Microsoft\Virtual Machine Manager\Applications\VmmApplicationManager.log) on the virtual machine for more details.Recommended Action
Try the operation again.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (WebTSRV1). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed. -
Tuesday, June 19, 2012 12:17 PMWeb deploy package version is 2.0
-
Thursday, June 21, 2012 4:41 PM
In SQL deployment I am getting below problem which deploying the service template for SQL. I tried the same step as mentioned above, could someone help me on this
-
Friday, June 22, 2012 6:47 PM
Him Nalin
your screen shoots does not appear , please reload them ?
Hikmat Kanaan Amman-Jordan MCSE
-
Friday, June 22, 2012 6:55 PM
Hi, Kirpal
The problem is in your web deploy GAE.zip package , it's trying to create a new web site but it's failing.
try to rebuild your deploy package and use the default IIS website .
the other solution is to work more with web deploy and customize your package to create a new site
http://learn.iis.net/page.aspx/37/deploying-web-sites-on-iis/
Hikmat Kanaan Amman-Jordan MCSE
- Proposed As Answer by kirpal.kaushal Tuesday, July 10, 2012 1:36 AM
-
Tuesday, June 26, 2012 7:18 AM
Hi Hikmaat,
Today, I have deployed Web package (FOMS) via Service Template, thanks a lot for helping me.
Actually i want to deploy 2 VM mcahine via service template, first vm is having IIS package and second vm should have SQL instance with Application DB.
Now, i have deployed SQL instance with SQL profile and IIS package with Application profile but they are not connected with each other, working separate, want to deploy Application DB on SQL instance VM.
Activity Performed for Web package Deployment.
Helpful link:->
Export a Application.
http://learn.iis.net/page.aspx/514/export-a-package-through-iis-manager/
Application profile in SCVMM 2012
Thanks
Kirpal Singh
Kirpal Singh
- Proposed As Answer by kirpal.kaushal Tuesday, July 10, 2012 11:46 AM
-
Tuesday, June 26, 2012 7:20 AM
Webdeploy Script syntax
Snapshot of deployed Service with VM and Application Package.
Thanks
Kirpal Singh
Kirpal Singh
-
Tuesday, June 26, 2012 7:22 AM
WEB PACKAGE in Deployed VM Machine
Kirpal Singh
-
Tuesday, June 26, 2012 7:54 AM
Hi Hikmaat,
i want to deploy SQL db by application profile and in second vm and IIS package will be in first vm.
so, i don't know the parameters to fill it in attached snapshots.
Kirpal Singh
-
Tuesday, June 26, 2012 7:54 AM
Kirpal Singh
-
Tuesday, June 26, 2012 8:59 AM
hi hikmat,
I want to deploy application by scvmm 2012, in which one vm has application package and another one has SQL instance with Application DB, i have deployed SQL instance in one vm and IIS Application package in second vm but dont know the syntex of script to deploy SQL DB on first vm having SQL instance, kindly suggest , DB is already uploaded in SCVMM library. snapshot is already uploaded.
Thanks
Kirpal SinghKirpal Singh
-
Tuesday, June 26, 2012 10:34 AM
Hi Hikmat,
i have added SQL script in application profile but it is giving error.
Error (22042)
The service (SQLINSTDBSRV1) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\e39f075b-2b2b-48c9-9d9a-b18c0b7f1e01\sqlHost.cmd) was executed on the computer (wah007.dcs.org) and returned a result exit code (0).
Information (21947)
The script command (C:\Windows\System32\cmd.exe /q /c "C:\Windows\MSSCVMMApplications\SQLDAC\FOMS.dacpac\RunSQLScript.cmd") was executed on the computer (wah007.dcs.org) and returned a result exit code (1).
Warning (22047)
The SQL Server script command on Computer (wah007.dcs.org) did not run. This SQL Server script command will be skipped on retry.Recommended Action
If this job will be restarted, ensure that the effects of skipping the SQL Server script command are mitigated.
Error (22570)
The SQL Server script command "script.sql FOMS " associated with a SQL Server data-tier application deployment (SQL Server Data-Tier Application 1, 9b5e106e-3544-421f-b2a7-b06ef80ab254) for the computer (wah007.dcs.org) failed.
Detailed error message: The script command exit code (1) matched the regular expression ([^0]) that is specified in the failure policy. Standard output log data: "Msg 4060, Level 11, State 1, Server WAH007, Line 1
Cannot open database "FOMS" requested by the login. The login failed.
Msg 18456, Level 14, State 1, Server WAH007, Line 1
Login failed for user 'DCS\administrator'."
Running the script command will be skipped when the job is restarted. To mitigate the effects of a script command failure, take corrective action..Recommended Action
The SQL Server script command will be skipped on job restart. Ensure that the effects of skipping the SQL Server script command are mitigated by taking any required corrective action within the computer.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (SQLINSTDBSRV1). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed.Kirpal Singh
-
Tuesday, June 26, 2012 11:13 AM
Kirpal Singh
-
Tuesday, June 26, 2012 11:14 AM
Kirpal Singh
-
Tuesday, June 26, 2012 11:15 AM
Error (22042)
The service (SQLINSTDBSRV1) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\e39f075b-2b2b-48c9-9d9a-b18c0b7f1e01\sqlHost.cmd) was executed on the computer (wah007.dcs.org) and returned a result exit code (0).
Information (21947)
The script command (C:\Windows\System32\cmd.exe /q /c "C:\Windows\MSSCVMMApplications\SQLDAC\FOMS.dacpac\RunSQLScript.cmd") was executed on the computer (wah007.dcs.org) and returned a result exit code (1).
Warning (22047)
The SQL Server script command on Computer (wah007.dcs.org) did not run. This SQL Server script command will be skipped on retry.Recommended Action
If this job will be restarted, ensure that the effects of skipping the SQL Server script command are mitigated.
Error (22570)
The SQL Server script command "script.sql FOMS " associated with a SQL Server data-tier application deployment (SQL Server Data-Tier Application 1, 9b5e106e-3544-421f-b2a7-b06ef80ab254) for the computer (wah007.dcs.org) failed.
Detailed error message: The script command exit code (1) matched the regular expression ([^0]) that is specified in the failure policy. Standard output log data: "Msg 4060, Level 11, State 1, Server WAH007, Line 1
Cannot open database "FOMS" requested by the login. The login failed.
Msg 18456, Level 14, State 1, Server WAH007, Line 1
Login failed for user 'DCS\administrator'."
Running the script command will be skipped when the job is restarted. To mitigate the effects of a script command failure, take corrective action..Recommended Action
The SQL Server script command will be skipped on job restart. Ensure that the effects of skipping the SQL Server script command are mitigated by taking any required corrective action within the computer.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (SQLINSTDBSRV1). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed.Kirpal Singh
-
Thursday, June 28, 2012 12:29 PM
Hi, Kirpal
The steps to deploy two machine service is like this:
1. for your Web application package GAE , use the web deploy export function to include a parameter " connection string"
2. Create a DAC package for the Application DB , in SQL Studio use " Extract Data-tier Application" not Generate Script
3. create a two tier service template adding corresponding VM's
4. Create the SQL DAC Profile , in the SQLDAC instance name (this your Database name "for example: GAEDB") , you can run the install DAC frame work in the script section
5.Create the Application profile for your web deploy package "GAE.zip" , configure the connection string , if web deploy 2.0 is not installed use the script section to install it
6. for the SQL script screen , you can add SQL script , if the script will be run against the SQL such "alter user " don't specify a database name , if the script will manipulate the DB " such as adding table to DB" type the name of DB to run the script against "for example: GAEDB"
7. in the SQL VM , you need to add the SQL Profile and the DAC package
8. in WEB Server you need to add the GAE application profile and configure the connection string
for the error above 'DCS\administrator' , is due to the wrong name of SQLDAC instance name
Hikmat Kanaan Amman-Jordan MCSE
-
Saturday, June 30, 2012 6:23 AM
Hi Hikmaat,
Point no. 2 and 6 is creating confusion, SQL Script is required or not ? if required then Generate Script is the Right Way ? how we get the script for DACPAC depolyement.
Point no.8 DB name is FOMS and Aplication Package Name is FOMS, so SQLDAC instance name in Application profile is FOMS.
SQL instance is MSSQLSERVER in SQL Profile, suggested by you and it is working fine.
Thanks
Kirpal Singh
Kirpal Singh
-
Saturday, June 30, 2012 7:19 AM
Extract Data tier is already done for SQL DAC PAC.
Kirpal Singh
-
Saturday, June 30, 2012 12:23 PM
Hi Hikmaat,
Do u have any step by step doc on SQL dacpac package deployment with SQL Instance Deployment ? like mentioned blogs
Mentioned Technet blog is deploying Petshop
Is parameters is required in SQL dacpac application profile.
Parameters: /q /c configure-datatier.cmd @sqlAdmin@ @sqlAdminPassword@
If i install SQL instance by domain administrator and windows authentication, it will not enable SA login, so above parameters will not work and SQL script get failed.
It is also not deploying with parameters and without parameters
Thanks
Kirpal Singh
Kirpal Singh
-
Saturday, June 30, 2012 12:31 PM
There are two type of Script command type: Pre and Post-Install, i am using pre-install, Is it ok
Kirpal Singh
-
Sunday, July 01, 2012 10:51 PM
Hi, Kirpal
Read this for now http://hikmatkanaan.wordpress.com/2012/07/01/creating-web-deploy-and-dac-packages-for-deploying-in-scvmm-2012-services-template/
my next blog will be ready soon , to show how to deploy this application using services template
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
- Proposed As Answer by kirpal.kaushal Tuesday, July 10, 2012 1:37 AM
-
Monday, July 02, 2012 3:40 AM
hi Hikmaat,
How we install SQL dacpac DB of SQl 2008 R2 Advance Express edition on SQL 2008 R2 instance ?
Mentioned link is installing SQL 2008 R2
and mentioned link is deploying SQL 2008 R2 Advance Express Edition
I am waiting for your next blog... which will clear all queries.
Thanks
Kirpal Singh
Kirpal Singh
-
Monday, July 02, 2012 3:51 AM
Hi hikmaat,
i want to deploy 2 VM's by Service Template, one is having SQL instance and SQL DB, Second one have IIS Web package.
one more thing in SQL installation by SQL profile , SQL studio is missing, how end user use SQL without Studio.
Thanks
Kirpal Singh
Kirpal Singh
-
Monday, July 02, 2012 8:16 PM
Hi, Kirpal
I have finished the full service deployment blog posts , please Check my blog posts I hope that it will be easy to follow the steps .
http://hikmatkanaan.wordpress.com/2012/07/01/creating-web-deploy-and-dac-packages-for-deploying-in-scvmm-2012-services-template/
http://hikmatkanaan.wordpress.com/2012/07/02/deploying-incentive-social-collaboration-software-using-scvmm-2012-service-template-part-1/
http://hikmatkanaan.wordpress.com/2012/07/02/deploying-incentive-social-collaboration-software-using-scvmm-2012-service-template-part-2/Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
- Proposed As Answer by kirpal.kaushal Tuesday, July 10, 2012 1:37 AM
-
Thursday, July 05, 2012 4:29 PM
hi hikmaat,
I have SQL 2008 R2 , will it work with incentive application ?
Thanks
Kirpal Singh
-
Thursday, July 05, 2012 4:59 PM
unable to do mentioned things.
- Create a database user and make sure that the user has the database roles db_datawriter and db_datareader on your created database.
unable to modify webconfig file.
Kirpal Singh
-
Thursday, July 05, 2012 5:19 PM
don't know how to edit webconfig file
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="incentive" connectionString="server=localhost;database=incentive2;trusted_connection=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>Kirpal Singh
-
Thursday, July 05, 2012 5:21 PMto “server=.\mssqlserver;database=incentive;user=administrator;password=wipro@123”
Kirpal Singh
-
Thursday, July 05, 2012 5:27 PM
Not clear, do u asking for local folder permissions or permissions in IIS ?
Set security of the incentive local folder , by adding the “defaultAppPool” with read permission.
Kirpal Singh
-
Thursday, July 05, 2012 5:41 PM
not clear
Open web.config located in the web-directory and update the connection string “incentive”. Open your web browser and enter the address to your created site.
Kirpal Singh
-
Thursday, July 05, 2012 5:47 PM
i have created incentive as local admin and my machine is in workgroup, installed SQL 2008 R2 with default instance, MSSQLSERVER.
Now, don't have the options as you shown in point no.8
In the new logon screen enter user name and password (eg. intensive ,P@ssw0rd) , select SQL server Authentication , Select the intensive Database as the default database . deselect the enforce password policy.
Kirpal Singh
-
Thursday, July 05, 2012 6:03 PM
hi hikmaat,
It would be helpful, if you explore more with snapshots for first link, please avoid to add technet links in your blog, it again creates confusion.
just give step by step guide, as most of infra persons are not aware about SQL queries and IIS, we have to do test case on it, thats why are trying it otherwise it is wastage of time, i have spend lot of time on it...
In SQL profile, i have sysprep SQL 2008 R2 and for Application Profile, we need SQL 2008 R2 Sqlexpress, it creates again a Big confusion..
i am not agree with Microsoft thought on this..
Kirpal Singh
-
Thursday, July 05, 2012 6:06 PM
Application is not running.
point no. 10. Open you internet browser at http://localhost/incentive and check that the Application is running
Kirpal Singh
-
Thursday, July 05, 2012 6:21 PM
Hi hikmaat,
We just need simple web page application in one vm and its database in second vm under SQL 2008 R2 instance with SQL management studio.
I know Service Template creation and Deployment, only SQL and Application package is big Deal in it.. Suggest some simple process to show demo to our customers. Petshop and Stock Traders is already removed from microsoft panel.
http://hikmatkanaan.wordpress.com/2012/07/01/creating-web-deploy-and-dac-packages-for-deploying-in-scvmm-2012-services-template/
http://hikmatkanaan.wordpress.com/2012/07/02/deploying-incentive-social-collaboration-software-using-scvmm-2012-service-template-part-1/
http://hikmatkanaan.wordpress.com/2012/07/02/deploying-incentive-social-collaboration-software-using-scvmm-2012-service-template-part-2/
Kirpal Singh
-
Sunday, July 08, 2012 10:46 AM
Hi,
I have uploaded the package files to my Skydrive , download it and go through Part1 & Part2 of deploying the service as per my blog.
https://skydrive.live.com/#cid=1DD40A69183AF0CF&id=1DD40A69183AF0CF%21174
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Monday, July 09, 2012 7:38 AM
Hi hikmaat,
Thanks a lot for Providing the dump on skydrive but issue is not resolved. it stucks with mentioned error.
i have SQLsysprep vhd with SQL Framework so have only SQL script, not attached another script as suggested by you.
Error (22042)
The service (Incentive Application Deployment) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (cmd.exe /q /c InstallWebDeploy.cmd) was executed on the computer (IWEB01.MAHAGOV.LOCAL) and returned a result exit code (0).
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\0bfcfa4e-6a0b-4bd6-8f1a-89af0c0aacef\sqlHost.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (0).
Error (22525)
An operation for an application (incentive SQl Server Data-Tier, SQLDAC) failed on the virtual machine (ISQL01.MAHAGOV.LOCAL). Detailed error message: MissingMandatoryProperty;DomainName.Recommended Action
Try the operation again.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (Incentive Application Deployment). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed.Kirpal Singh
-
Monday, July 09, 2012 7:58 AM
Please post a screen Shoot of your DAC application Profile .
also Please check:
1. That your using an Account that is SQL administrator
2. Check that the username and Domain names are correct
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Monday, July 09, 2012 9:09 AM
Is SQL Administrator account for DB deployment is Incentive ?
SQL aDMIN id need to be tag with SQL Profile ?
Sql admin id need to be tag with Application profile of SQL Dac pac ?
Kirpal Singh
-
Monday, July 09, 2012 9:10 AM
Kirpal Singh
-
Monday, July 09, 2012 9:15 AM
i have installed SQL sysprep by msadmin domain id, msadmin is used for domain joining also.
Domain name is mahagov.local
Kirpal Singh
-
Monday, July 09, 2012 9:46 AM
Hi,
From the screen Shoots above , I see that you have selected windows authentication for the SQL SA account Type , but you are using an SQL authentication for your deployment credentials.
The Authentication type Should match the Account type that you are using .
in the above screen Shoots:
Either Change the Authentication type to SQL Authentication or use a Windows Account that is an SQL Administrator
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Monday, July 09, 2012 9:59 AM
for complete installation , if i use msadmin user ( domain admin & SQL admin) and domain joining and SQL service accont,
I want to go with windows authentication, Is there any challenge ?
If i use windows authentication, then incentive user will work, which is in script ?
incentive user is SQL sa user, for Windows authentication user and it should be part of SQL syprep ?
Kirpal Singh
-
Monday, July 09, 2012 10:00 AM
msadmin user created in domain, not local one.
I have joined the windows machine to domain before sql sysprep, As i need msadmin user in all places and msadmin is availbale in domain.
Kirpal Singh
-
Monday, July 09, 2012 10:07 AM
if i use msadmin account for complete deployment then i need to change mentioned script.
“server=ISQL01;database=incentive;user=incentiveuser;password=P@@ssw0rd”
@@ stands for what ?
in SCVMM , i have create run as account as incentive and password will be P@@ssw0rd, Am i right ?
domin vaildation need to be uncheck as it is not neither available in domain nor in local sysprep vhd, Am i right ?
Kirpal Singh
-
Monday, July 09, 2012 10:24 AM
if i use, msadmin in all places in SQL profile and Application profile for SQl dac pac, then
in Application profile for Web , is changes required here
server=.\ISQL01;database=incentive;user=incentive;password=P@@ssw0rd
like user name will be msadmin and passsword wipro@123
Kirpal Singh
-
Monday, July 09, 2012 12:12 PM
hi,
Please reread again my blog Part1 carefully
"NOTE: connection string cannot contain at sign (“@”); to express literal at sign (“@”), use double at sign (“@@”). This is true for most of templates setting is SCVMM , the @ is used to define service setting , for more information about service setting check this post SC VMM 2012 Service Settings"
that's why the P@ssw0rd" has double @@ = P@@sw0rd
you can use MS Admin Account every where , except in the SQL Profile , in the SQL Configuration , you must use SQL SA Account , so that you SQL installation gets configured for mixed mode as per Point 8 screen Shoot 2 , in my Article my script use a SQL user called "incentiveuser"
The connection string is “server=ISQL01;database=incentive;user=incentiveuser;password=P@@ssw0rd”
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Monday, July 09, 2012 1:47 PM
Hi hikmaat,
i have used windows authentication for SQL profile and SQL dac pac and used tag SQL framework installation in SQL deployment with dacpac, it is installed without any issue.
but when i am deploying 2 tier , SQL and IIS VM, it gives mentioned error.
Error (22042)
The service (Incentive Service) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (cmd.exe /q /c InstallWebDeploy.cmd) was executed on the computer (IWEB01.MAHAGOV.LOCAL) and returned a result exit code (1).
Warning (22624)
The script command (cmd.exe /q /c InstallWebDeploy.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.a63e919636\SQL2008R2_DAC_Framework_X64.crRecommended Action
If this job will be restarted, ensure that the effects of skipping the script command are mitigated.
Error (22632)
The script command standard error matched the failure policy setting "Match any string" with its result ("'InstallWebDeploy.cmd' is not recognized as an internal or external command,
operable program or batch file."). For more information, see the standard error log (C:\Windows\TEMP\gce_stderror92feb6612e704775a4af53129c06c442.log).Recommended Action
The script command will be skipped when the job is restarted. Ensure that the effects of skipping the script command are mitigated by taking any required corrective action within the computer.
Error (20400)
1 parallel subtasks failed during execution.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\53dfbb4c-2c72-4dd3-8a31-02b0d1af72e7\sqlHost.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (0).
Information (21947)
The script command (cmd.exe /q /c installSQLDac.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (1).
Warning (22624)
The script command (cmd.exe /q /c installSQLDac.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.938d273880\WebDeploy_x64_en-US_2.0.1070.crRecommended Action
If this job will be restarted, ensure that the effects of skipping the script command are mitigated.
Error (22632)
The script command standard error matched the failure policy setting "Match any string" with its result ("'installSQLDac.cmd' is not recognized as an internal or external command,
operable program or batch file."). For more information, see the standard error log (C:\Windows\TEMP\gce_stderror61d4ea07485f4c29a9319f4feb29a765.log).Recommended Action
The script command will be skipped when the job is restarted. Ensure that the effects of skipping the script command are mitigated by taking any required corrective action within the computer.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (Incentive Service). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed.Kirpal Singh
-
Monday, July 09, 2012 4:57 PM
Hi,
I think you have misplaced your scripts , you are using InstallWebDeploy.cmd to install the DAC framework and installSQLDac.cmd to install the web deploy , you need to check the script name in each profile
The script command (cmd.exe /q /c InstallWebDeploy.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.a63e919636\SQL2008R2_DAC_Framework_X64.crThe script command (cmd.exe /q /c installSQLDac.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.938d273880\WebDeploy_x64_en-US_2.0.1070.crRegards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Tuesday, July 10, 2012 1:39 AM
Hi Hikmaat,
I will cross check it and let u know the update by today and i will attach screen shots also.
Kirpal Singh
-
Tuesday, July 10, 2012 5:37 AM
Hi Hikmaat,
I have cross check the scripts, that is ok.
Only web vm has issue, web directory is not deploying as SQL dac pac is in parameter as per script send by you.
and that is in snapshot also.
Kirpal Singh
-
Tuesday, July 10, 2012 5:38 AM
In link 2...
6.Click Application configuration , from the Application Profile list select the : incentive web Package Profile , double check the profile settings –>click ok
Note:Double Check your SQL Connection String for the SQL Server name , Database name , user name and Password
Kirpal Singh
- Proposed As Answer by kirpal.kaushal Tuesday, July 10, 2012 5:53 PM
-
Tuesday, July 10, 2012 5:58 AM
yes , just double check it
it should read
“server=ISQL01;database=incentive;user=incentiveuser;password=P@@ssw0rd”
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Tuesday, July 10, 2012 9:55 AM
Hi Hikmaat,
I have done mentioned steps.
1. Uploaded SQl dac pac ,Scripts and web package on scvmm library, refresh it.
2. Created Application profile for SQL dac pac with windows authentication.
3. created Application Profile for Incentive Web package with proper cmd script of web deploy.
4. change parametes as suggest by you as mentioned in above reply.
5. SQL profile is already created with windows authentication.
6. created 2 Templates ( SQLTIERTEMPLATE) and (WEBTIERTEMPLATE)
7. in SQLTIERTEMPLATE tag syspep vhd of WINSQL 2008 R2 and hardware profile( already created), OS Profile( Already Created), DAC PAC Application profile and SQL profile in it.
8. in Webtiertemplate tag sysprep OS vhd with hardware, OS Profile with IIS Roles, Dotnet 3.5 features, Application profile, Incentive Web application profile.
9. Created new service Template and Drag SQLTIER Template in 1 Tier and WEBTIERTEMPLATE in 2 Tier Template.
10. Save it and configure deployment.
11. mention the name of Service.
12. provided the name to VM machine ( ISQL01 to SQL VM and IWEB01 to WEB VM).
13. Now clicked on deploy service.
14. It creates OS of both VM, it deploy SQL and SQL dac pac on SQL VM.
15. Failed to deploy web package on WEB VM.
Errors are mentioned below.
Kirpal Singh
-
Tuesday, July 10, 2012 10:01 AM
Error (22042)
The service (INCENTIVESERVICE) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (cmd.exe /q /c InstallWebDeploy.cmd) was executed on the computer (IWEB01.MAHAGOV.LOCAL) and returned a result exit code (1).
Warning (22624)
The script command (cmd.exe /q /c InstallWebDeploy.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.ae1ecfe625\SQL2008R2_DAC_Framework_X64.crRecommended Action
If this job will be restarted, ensure that the effects of skipping the script command are mitigated.
Error (22632)
The script command standard error matched the failure policy setting "Match any string" with its result ("'InstallWebDeploy.cmd' is not recognized as an internal or external command,
operable program or batch file."). For more information, see the standard error log (C:\Windows\TEMP\gce_stderrorecada3ddc5c54051a818418418e86f8f.log).Recommended Action
The script command will be skipped when the job is restarted. Ensure that the effects of skipping the script command are mitigated by taking any required corrective action within the computer.
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\47a3ad4e-c6f6-4899-bd81-78523720fb19\sqlHost.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (0).
Information (21947)
The script command (cmd.exe /q /c installSQLDac.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (1).
Warning (22624)
The script command (cmd.exe /q /c installSQLDac.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.cb8b9737a7\WebDeploy_x64_en-US_2.0.1070.crRecommended Action
If this job will be restarted, ensure that the effects of skipping the script command are mitigated.
Error (22632)
The script command standard error matched the failure policy setting "Match any string" with its result ("'installSQLDac.cmd' is not recognized as an internal or external command,
operable program or batch file."). For more information, see the standard error log (C:\Windows\TEMP\gce_stderror15b74984a50c45248b28a60edf43ba47.log).Recommended Action
The script command will be skipped when the job is restarted. Ensure that the effects of skipping the script command are mitigated by taking any required corrective action within the computer.
Error (20400)
1 parallel subtasks failed during execution.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (INCENTIVESERVICE). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed.Kirpal Singh
-
Tuesday, July 10, 2012 10:21 AM
Please go and read point 13 in part1 Carefully !!!!!!!!!!!!!!!!!!!!!!!
the script cmd.exe /q /c InstallWebDeploy.cmd , Should go with package WebDeploy_x64_en-US_2.0.1070.cr not with SQL2008R2_DAC_Framework_X64.cr
Check the First Screen shoot against your setup , field by field
the same hold true or the SQL DAC
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
- Edited by Hikmat Kanaan Tuesday, July 10, 2012 10:24 AM speel Check
-
Tuesday, July 10, 2012 11:25 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:26 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:28 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:29 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:31 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:32 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:33 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:34 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:35 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:37 AM
SQL Profile , Application Profile are ok...
but Error is still coming... let me know what i missed in it.
Kirpal Singh
-
Tuesday, July 10, 2012 11:40 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:40 AM
Kirpal Singh
-
Tuesday, July 10, 2012 11:41 AMwebdeploy is also downloaded from IIS website suggested by you.. We have Licensed version of SCVMM 2012
Kirpal Singh
-
Tuesday, July 10, 2012 11:56 AM
your SQL Profile Should Have as SQL SA account and authentication type set to SQL
please upload your Screen shoot for Content of :
InstallWebDeploy.cmd (file)
WebDeploy_x64_en-US_2.0.1070.cr (folder)
installSQLDac.cmd (file)
SQL2008R2_DAC_Framework_X64.cr (folder)Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Tuesday, July 10, 2012 12:04 PM
Kirpal Singh
-
Tuesday, July 10, 2012 12:05 PM
Kirpal Singh
-
Tuesday, July 10, 2012 12:06 PM
Kirpal Singh
-
Tuesday, July 10, 2012 12:06 PM
Kirpal Singh
-
Tuesday, July 10, 2012 12:10 PMI am changing SQL profile to SA ( SQL Authentication) and deploying it again... but cross check it , i think it may be different issue.
Kirpal Singh
-
Tuesday, July 10, 2012 1:01 PM
Hi hikmaat,
I have changed the SQL profile and redeployed it but getting mentioned error.
Error (22042)
The service (NEWSR) was not successfully deployed. Review the event log to determine the cause before you take corrective action.Recommended Action
The deployment can be restarted by retrying the job.
Information (21947)
The script command (cmd.exe /q /c installwebdeploy.cmd) was executed on the computer (IWEB01.MAHAGOV.LOCAL) and returned a result exit code (0).
Information (21947)
The script command (c:\windows\System32\cmd.exe /q /c c:\windows\MSSCVMMSQLInstance\64e20f2e-be8f-4e25-a075-fe99d1a0c486\sqlHost.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (0).
Information (21947)
The script command (cmd.exe /q /c installSQLDac.cmd) was executed on the computer (ISQL01.MAHAGOV.LOCAL) and returned a result exit code (1).
Warning (22624)
The script command (cmd.exe /q /c installSQLDac.cmd) did not run successfully. This script command will be skipped on retry.
Script package location: C:\Windows\temp\SCVMM.7add718767\WebDeploy_x64_en-US_2.0.1070.crRecommended Action
If this job will be restarted, ensure that the effects of skipping the script command are mitigated.
Error (22632)
The script command standard error matched the failure policy setting "Match any string" with its result ("'installSQLDac.cmd' is not recognized as an internal or external command,
operable program or batch file."). For more information, see the standard error log (C:\Windows\TEMP\gce_stderror818a89693b9a422ba4b8aa27d68aaa43.log).Recommended Action
The script command will be skipped when the job is restarted. Ensure that the effects of skipping the script command are mitigated by taking any required corrective action within the computer.
Error (20400)
1 parallel subtasks failed during execution.
Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (NEWSR). Check job logs to get more information on the failed operation.Recommended Action
Check error messages and retry the operation if needed.Is there any CASE sensitive issue in installsqldac.cmd
Thanks
Kirpal Singh
Kirpal Singh
-
Tuesday, July 10, 2012 1:10 PM
and one more thing, after changing of SQL profile from Windows to SQL authentication, incentive DB is not deployed.
with windows authentication was deploying.
Kirpal Singh
-
Tuesday, July 10, 2012 1:14 PMWEB vm is showing Incentive App but not working, it depends on DB.
Kirpal Singh
-
Tuesday, July 10, 2012 1:17 PM
Kirpal Singh
-
Tuesday, July 10, 2012 1:19 PM
Kirpal Singh
-
Tuesday, July 10, 2012 1:24 PM
How many library servers you have ?
is the Application frame work folders are sync between them ?
the screen Shoot you uploaded show a folder name of WebDeploy_x64_en-US_2.0.cr
but the error says the folder name is WebDeploy_x64_en-US_2.0.1070.cr ?
Please check that your Application framework folder is sync every where
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
-
Tuesday, July 10, 2012 1:40 PM
One library server.
Downloaded web deploy from website and uploaded it with new folder, without deletion of default webdeploy package of SCVMM 2012.
Using downloaded one in app profile.
Kirpal Singh
-
Tuesday, July 10, 2012 1:44 PM
Kirpal Singh
-
Tuesday, July 10, 2012 1:45 PMI can share Remote session with u, if you want to see it
Kirpal Singh
-
Tuesday, July 10, 2012 1:46 PM
I would suggest to you to remove all webdeply and SQL DAC farmwork folders make sure they don't show up in VMM console
, recreate them using the downloaded version , copy the corresponding scripts to each folder and try again
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
- Proposed As Answer by kirpal.kaushal Wednesday, July 11, 2012 3:02 AM
-
Tuesday, July 10, 2012 2:12 PM
yes Sure ,
My email is hikmetsalim@hotmail.com , I will need a round 30 Min to get home then I can connect .
send me the connection information , I will reply to you as soon as I get home
Regards, Hikmat Kanaan Amman-Jordan Remember to click “Mark as Answer” on the posts that helps you
- Proposed As Answer by kirpal.kaushal Wednesday, July 11, 2012 3:02 AM
-
Tuesday, July 10, 2012 2:37 PM
ok, details on your mail..
we are waiting for your reply.
Kirpal Singh
-
Tuesday, July 10, 2012 5:51 PM
Special thanks to Mr. hikmaat to complete the 2 Tier deployment on our infrastructure. Only Mr. Hikmaat knows how to deploy the 2 Tier Application.
Kirpal Singh
-
Tuesday, July 10, 2012 5:54 PM
ok done..
removed Quotes, changed name of user to incentive, password is ok with double @@.
Kirpal Singh
.png)
