Location Deployment Wizard for ConfigMgr 2007/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxWhen working on deployment projects, there is often a requirement for a workstation to be customised on a location by location basis. Common workstation customisations which are applied in this manner include:
Localisation settings (locales, keyboardHelping to deploy your world automagically...7.x ProductionRE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxWed, 12 Jun 2013 12:31:50 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>is LDW available for SCCM 2012 yet ? </p>
<img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxSat, 08 Jun 2013 01:59:44 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>I am connecting to the share, everything is fine but I get Unable to connect to MDT Database. Same user credentials I use for everything else MDT</p>
<img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxTue, 11 Dec 2012 05:19:44 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Ben Hunter0<p>Hi &quot;am I missing something&quot;,</p>
<p>Here are a couple of things that could be causing this issue:</p>
<p>1) &nbsp; &nbsp; &nbsp;If you are not seeing the location selector page at all, it suggests that the WinPE boot image with customized pre-execution hooks has not been created correctly. The Pre-execution hooks in the TSConfig.ini file force WinPE to launch the location HTA before running the ConfigMgr Task Sequence wizard.</p>
<p>2) &nbsp; &nbsp; &nbsp;If the HTA is firing but not connecting to the SQL Database, a few people have posted about having this issue (Named Pipes v’s TCP) and there is a solution for this issue in the comments above.</p>
<p>Thanks Ben (via Mark)</p>
<img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxFri, 07 Dec 2012 05:32:55 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>I followed the instructions to the letter and I can&#39;t get the Location page to load before the Task Sequence</p>
<img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxWed, 28 Apr 2010 22:18:57 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>Encountering the same kind of error as cdrider and Sridhar.</p>
<p>Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'</p>
<p>While connecting to SQL database using a HTA which is ran in WinPE during the OSD deployment.</p>
<p>&quot;Provider=MSDASQL;Driver=SQL Server;Trusted_Connection=Yes;SERVER=SERVERNAME;DATABASE=DB;UID=domain\user;PWD=secretWord;&quot;</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxWed, 14 Apr 2010 15:40:35 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>I'm working on a similar setup and followed the steps outlined above. I see the same error as cdrider mentioned above if I dont modify the code Data Source=np: i.e.,</p>
<p>*******************************************</p>
<p>An error has occurred in the script on this page.</p>
<p>Line: 116</p>
<p>Char: 3</p>
<p>Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'</p>
<p>Code: 0</p>
<p>URL: file:///X:/LocationDeploymentWizard/LocationHTA.hta</p>
<p>*******************************************</p>
<p>If I update the code with Data Source=np:, I see a different error which is as follows-</p>
<p>An error has occured in the script on this page.</p>
<p>Line: 132</p>
<p>Char: 3</p>
<p>Error: [DBNETLIB][ConnectionOpen (Connect())]SQL Server does not exist or access denied.</p>
<p>Code: 0</p>
<p>URL: file:///X:/LocationDeploymentWizard/LocationHTA.hta</p>
<p>*******************************************</p>
<p>My SQL server is ver 2008 and have ensured that Named Pipes are enabled under network configuration. I can also ping the server from the client end when I see this message. Not sure what I'm missing here. Can anyone help me with you valuable inputs?</p>
<p>Thanks in advance.</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxTue, 12 Jan 2010 03:32:33 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>I had an issue with Windows PE connecting to the database after I had upgraded to SCCM 2007 SP2. &nbsp;The error was &quot;Safety settings on this machine prohibit accessing a data source on another domain.&quot;</p>
<p>I have a post in my blog with the details to fix it:</p>
<p><a rel="nofollow" target="_new" href="http://joshuasmueller.spaces.live.com/blog/cns">http://joshuasmueller.spaces.live.com/blog/cns</a>!39ED2989E824DC77!343.entry</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxWed, 30 Dec 2009 01:44:27 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>Can you still use the defaultgateway in customsettings.ini. I am setting location as an SCCM variable which works great if I change customsettings.ini to search on location as your example. Thing is for a &quot;normal&quot; install I would leave this variable blank and therefore want ztigather to pick up the location based on defaultgateway. I've tried putting BOTH Default Gateway and Location into the customsettings.ini and this works but SQL returns 2 records one for your &quot;home&quot; office gateway settings, then the variable you set for the other office. I can't get it to pick up just the one record. Any ideas ??</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxThu, 17 Sep 2009 07:02:01 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>Looks like one issue we couldn't get around was making sure that the sccm SQL server was installed locally on the SCCM &nbsp;07 server. &nbsp;Once we did that and did the named pipes change, everything worked perfectly...</p>
<p>Not sure why the SQL location matters...</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxFri, 11 Sep 2009 23:59:06 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>Hi guys-thank you for this post on SCCM and LDW - it's been very helpful. Question for you though: I get the Location Deployment Wizard screen to popup &nbsp;right after I enter the password for the task sequence. It runs through connecting to the database and all that, gets to 100%, then just continues with the task process.</p>
<p>The login audits on the SQL side say that the MDT user successfully connected to the database, so not sure why I'm not receiving prompts to change the locations, language, etc.....</p>
<p>Any guidance would be helpful. Thanks very much.</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxSat, 05 Sep 2009 02:36:41 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1tmenzel0<p>cdrider, did you have any luck resolving your error? &nbsp;I am encountering the same issue.</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxFri, 04 Sep 2009 11:31:30 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>You Guys Rock!</p>
<p>cdrider, </p>
<p>I received the same error until forcing it to connect using the Named Pipe protocol.</p>
<p>On line 117 in the LocationHTA, add np: in front of the server name.</p>
<p>Data Source=np:</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxFri, 21 Aug 2009 04:24:05 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>For non-config manager usage of similar functionality, you can utilize a modified version of Schuff's Role Selection wizard here: &nbsp;<a rel="nofollow" target="_new" href="http://myitforum.com/cs2/blogs/jscheffelmaer/archive/2008/06.aspx">http://myitforum.com/cs2/blogs/jscheffelmaer/archive/2008/06.aspx</a></p>
<p>By duplicating location information into your Roles database, and utilizing this, you can create a similar functionality for MDT based LTI deployments.</p>
<p>With some custom modifications to this i have very similar functionality in my MDT environment for LTI, allowing &quot;Depot Sites&quot; to image systems for multiple locations, while still maintaining their site specific setups in the database.</p>
<p>Also, by kicking this off via a userexit, you can remove the need to modify your boot media for this same functionality, and everything is kept serverside. (simply reduces boot media updates)</p>
<p>-D</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxWed, 19 Aug 2009 13:58:14 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1cdrider0<p>This is great! &nbsp;I'm having a little trouble though and hope you can help. &nbsp;Upon PXE-booting into WinPE, I see the &quot;Windows is starting up...&quot; message and then &quot;Preparing network connections. I type in my password (password-protected PXE Service Point) and that's when the &quot;Contoso Build Wizard&quot; screen should appear allowing me to specify a computername and location. Instead, I see a flash (possibly the &quot;Contoso Build Wizard&quot; appearing and then closing) and get the window &quot;Initialising connection to MDT Build Database&quot; (with the Task Sequence Wizard underneath). The database initialization screen goes away after about 30 seconds and then all I see is my Task Sequence Wizard for selecting the advertised deployment task sequence for my image. I've tried hitting F8, navigating to where the LocationHTA.hta file resides and rerunning it from the WinPE command prompt, but the &quot;Contoso Build Wizard&quot; just appears for a second or two and then disappears again. It appears I am experiencing a login failure to SQL as I can get the following error to appear by commenting out the &quot;On error Resume Next&quot; command on line 113 in the LocationHTA.hta file.</p>
<p>*******************************************</p>
<p>An error has occurred in the script on this page.</p>
<p>Line: 116</p>
<p>Char: 3</p>
<p>Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'</p>
<p>Code: 0</p>
<p>URL: file:///X:/LocationDeploymentWizard/LocationHTA.hta</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">RE: Location Deployment Wizard for ConfigMgr 2007http://blogs.technet.com/b/deploymentguys/archive/2009/08/17/location-deployment-wizard-for-configmgr-2007.aspxTue, 18 Aug 2009 07:39:35 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:7349ea16-444f-4724-b3d5-806293f02ce1Anonymous0<p>Nice one guys, this will sure come in handy!</p>
<p>You guys might want to take a look at: <a rel="nofollow" target="_new" href="http://www.ithastobecool.com/2009/08/17/zerotouch-for-mdt-2010-without-sccm/">http://www.ithastobecool.com/2009/08/17/zerotouch-for-mdt-2010-without-sccm/</a> as well :)</p><img src="http://blogs.technet.com/aggbug.aspx?PostID=3274244&AppID=6127&AppType=Weblog&ContentType=0" width="1" height="1">