Location Deployment Wizard for ConfigMgr 2007

re: Location Deployment Wizard for ConfigMgr 2007

Ben Hunter — Mon, 10 Dec 2012 21:19:44 GMT

Hi "am I missing something",

Here are a couple of things that could be causing this issue:

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

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

Thanks Ben (via Mark)

re: Location Deployment Wizard for ConfigMgr 2007

Am I missing something — Thu, 06 Dec 2012 21:32:55 GMT

I followed the instructions to the letter and I can't get the Location page to load before the Task Sequence

re: Location Deployment Wizard for ConfigMgr 2007

mrdj — Wed, 28 Apr 2010 14:18:57 GMT

Encountering the same kind of error as cdrider and Sridhar.

Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

While connecting to SQL database using a HTA which is ran in WinPE during the OSD deployment.

"Provider=MSDASQL;Driver=SQL Server;Trusted_Connection=Yes;SERVER=SERVERNAME;DATABASE=DB;UID=domain\user;PWD=secretWord;"

re: Location Deployment Wizard for ConfigMgr 2007

Sridhar — Wed, 14 Apr 2010 07:40:35 GMT

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

*******************************************

An error has occurred in the script on this page.

Line: 116

Char: 3

Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Code: 0

URL: file:///X:/LocationDeploymentWizard/LocationHTA.hta

*******************************************

If I update the code with Data Source=np:, I see a different error which is as follows-

An error has occured in the script on this page.

Line: 132

Char: 3

Error: [DBNETLIB][ConnectionOpen (Connect())]SQL Server does not exist or access denied.

Code: 0

URL: file:///X:/LocationDeploymentWizard/LocationHTA.hta

*******************************************

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?

Thanks in advance.

re: Location Deployment Wizard for ConfigMgr 2007

Josh — Mon, 11 Jan 2010 19:32:33 GMT

I had an issue with Windows PE connecting to the database after I had upgraded to SCCM 2007 SP2. The error was "Safety settings on this machine prohibit accessing a data source on another domain."

I have a post in my blog with the details to fix it:

http://joshuasmueller.spaces.live.com/blog/cns!39ED2989E824DC77!343.entry

re: Location Deployment Wizard for ConfigMgr 2007

Ian B — Tue, 29 Dec 2009 17:44:27 GMT

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 "normal" 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 "home" 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 ??

re: Location Deployment Wizard for ConfigMgr 2007

Pete — Wed, 16 Sep 2009 23:02:01 GMT

Looks like one issue we couldn't get around was making sure that the sccm SQL server was installed locally on the SCCM 07 server. Once we did that and did the named pipes change, everything worked perfectly...

Not sure why the SQL location matters...

re: Location Deployment Wizard for ConfigMgr 2007

Chris — Fri, 11 Sep 2009 15:59:06 GMT

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

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

Any guidance would be helpful. Thanks very much.

re: Location Deployment Wizard for ConfigMgr 2007

tmenzel — Fri, 04 Sep 2009 18:36:41 GMT

cdrider, did you have any luck resolving your error? I am encountering the same issue.

re: Location Deployment Wizard for ConfigMgr 2007

James — Fri, 04 Sep 2009 03:31:30 GMT

You Guys Rock!

cdrider,

I received the same error until forcing it to connect using the Named Pipe protocol.

On line 117 in the LocationHTA, add np: in front of the server name.

Data Source=np: