BDD 2007 - Troubleshooting Database issues

re: BDD 2007 - Troubleshooting Database issues

Or Tsemah — Wed, 11 Jul 2007 09:58:29 GMT

Hy Ben,

Great Blog,

Did you encountered an error where the BDD tries to use the Machine account to access the DB ?

I get an access denied (of course) but the logs specify only the machine account (Using LTI\Refresh)

Or.

ort@yside.com

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Wed, 11 Jul 2007 11:09:54 GMT

I have seen this but only when there are no ther credentials availablke for the database lookup to use. Have you spoecified userid settings in the bootstrap.ini file?

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

Or Tsemah — Wed, 11 Jul 2007 13:15:39 GMT

Sorry, i was using ZTI\Refresh when it happend

And also, i can't seem to use the instalaltion CD, it keep telling me "Access Denied" "Path not found" stuff

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Wed, 11 Jul 2007 22:05:40 GMT

Can you please email me a copy of the logs, "ben dot hunter at microsoft dot com".

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

OysteinK — Thu, 16 Aug 2007 15:56:13 GMT

Using ypur troubleshooting tips i found that my database always returns "Record count from SQL = 0"

What process moves the computer information into the database? Seems like mine is empty

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Thu, 16 Aug 2007 23:47:33 GMT

I would need more information to help you with this issue. This would include your customsettings.ini file and the logs.

re: BDD 2007 - Troubleshooting Database issues

Johno — Fri, 31 Aug 2007 09:25:05 GMT

G'day Ben,

Thanks for a truly great site, you knowledge has helped me out a great deal in understanding and implementing BDD.

I'm having an issue with a BDD deployment using Lite Touch. I've setup a Database on an SQL 2005 cluster server, but I cant query the database from Windows PE using the above methods.

When the script tries to map to the SQL share I get:

'Validating connection to \\sqlserver\share'

'FindFile: The file OSDConnectToUNC.exe could not be found in any standard locations'

'Find File: The file Wizard.hta could not be found in any standard locations.'

'Error - unable to find Wizard.hta, so it is impossible to prompt for credentials'

Then the script tries to open a trusted SQL connection and fails with:

'ZTI error opening SQL connection: [DBNETLIB][ConnectionOpne (Connect()).]SQL Server does not exist or access denied. (-2147467259)'

'Unable to establish database connection using [MMAPPS] properties.

I dont claim to know much about SQL, but I've checked and had a DB Admin check that the server is definetly enabled for named pipes, the Domain account specified in the CustomSettings.ini has read,write and execute permissions on the database. The SQL server name is resolvable from the Windows PE environment.

I can how ever query the database logged into a Windows XP machine with the same specified account, using the above methods.

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Fri, 31 Aug 2007 11:38:01 GMT

Could you please email me a copy of the full ztigather.log file. My address is ben dot hunter at microsoft dot com.

Thanks,

Ben

BDD Database Connectivity Troubleshooting

Brad Tucker — Mon, 17 Sep 2007 18:28:56 GMT

Many of you may have read my colleague Ben Hunter's blog entry for troubleshooting connectivity issues

BDD Database Connectivity Troublshooting

Brad Tucker — Mon, 17 Sep 2007 19:16:34 GMT

Many of you may have read my colleague Ben Hunter's blog entry for troubleshooting connectivity issues

re: BDD 2007 - Troubleshooting Database issues

Ted — Fri, 28 Sep 2007 00:07:10 GMT

Ben,

I am trying to use the make and model in the database to install applications but I cannot get this to work. Basically, there is no error message and the install just finishes. It appears as if it doesn’t query the database.

It looks like all the settings are correct in the rules tab, however I do not have SQLSHARE= defined. Is that required? If so is it just a share on that server and what permissions for what user ID are required? Here are my rules properties:

[MMSettings]

SQLServer=SQLSERVERNAME

Database=DATABASENAME

Netlib=DBNMPNTW

Table=MakeModelSettings

Parameters=Make, Model

[MMApps]

SQLServer=SQLSERVERNAME

Database=DATABASENAME

Netlib=DBNMPNTW

Table=MakeModelApplications

Parameters=Make, Model

Order=Sequence

Lastly are there any logs that I can use to find out why it is not working (somehow I think the answer has to do with not having SQLSHARE defined).

Thank you

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Fri, 28 Sep 2007 00:41:08 GMT

The SQLShare value is used to connect to authentication to the server. The SQLShare can be any share on the server.

Have a look at the log file C:\minint\smsosd\osdlogs\ztigather.log for more information.

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

Or Tsemah — Thu, 25 Oct 2007 15:07:58 GMT

Can you speculate why there are no Record Counts in the SQL Server ?

I've went over the setting time after time with no answer

Or.

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Sun, 28 Oct 2007 08:23:02 GMT

I am not sure what you mean with this question. Can you elaborate a little?

Thanks,

Ben

extending the database?

Hartmut Henk — Tue, 30 Oct 2007 17:40:19 GMT

Ben,

I am using the Database to preconfigure the client settings and realized, that not all of the configuration options that you can e.g. specify in MyCustomSettings.ini are available in the database. The option BDERecoveryPassword for example cannot be configured through the database.

I already tried, using an SQL Client to manually add a line to the corresponding table in th db. However, the option did not appear in the DB view in deployment workbench.

How can I extend the DB to include settings, that are not available out of the box, or is this not possible at all?

Thanks,

Hartmut

p.s.: By the way - great blog! It helped me alot so far!

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Wed, 31 Oct 2007 06:34:26 GMT

There are three "spare" fields in the BDD DB. ServerA ServerB and ServerC you could use these fields.

Other than that if you change the BDD DB the changes will ot be reflected in the Workbench.

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

JARED WETMORE — Wed, 07 Nov 2007 00:43:07 GMT

Ben, when running the test to test for connectivity and to see if results are returned, I am getting an error

ERROR - Unable to find Wizard.hta, so it is impossible to prompt for credentials.

I get a positive result back about connecting to the sql server and it says it returned records=1 as result

any thoughts, or is this normal when running from this method? if this is not normal, and idea why i am getting this ?

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Wed, 07 Nov 2007 10:29:21 GMT

Hi Jared,

That is normal. BDD will try a number of connectivity methods and as one succeeds then everything is god :)

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

JARED WETMORE — Wed, 07 Nov 2007 17:29:37 GMT

Ben, thanks for that info. i guess im confused as to why the wizard is not displaying the applications selection I have in the database when I run the wizard on a machine that has make and model info. I get "check" marks in the applications that are to be installed on that particualr make and model as I did wiht the BDD-2007? any suggestions ?

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Thu, 08 Nov 2007 10:22:26 GMT

I am pretty sure that BDD 2007 will not display check marks either.

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

JARED WETMORE — Thu, 08 Nov 2007 16:57:27 GMT

Ben, I can confirm that the bdd-2007 does populate the applciation section from the databse with checkmarks. I do it all the time and it does do this. It must somehow return the results to the windows deployment wizard after it gathers the info from the databse..

re: BDD 2007 - Troubleshooting Database issues

Martin — Mon, 19 Nov 2007 20:04:54 GMT

Hi Ben.

Is it possible to use wildcards in make and model? Like Make=Hewlett-Packard Model=*

Thanks

Martin

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Tue, 20 Nov 2007 10:50:23 GMT

Unfortunately it is not possible to use wild cards directly. Although you could get creative with userexit scripts and create this functionality.

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

kongkuba — Tue, 11 Mar 2008 13:38:07 GMT

Hi Ben

I have this strange problem where during refresh (using MDT and SMS/OSD) i get a timeout while OSDconnectToUNCpath tries to establish at connection to the defined SQLshare=ZTI$. What happens then I that I get a "Login failed for user domain\pcname$" while connecting to the SQL database. This results I no DB data being collected by ZTIgather.wsf and therefore no language settings, package installation etc. The really strange thing though, is that I created a workaround where I rerun ZTIgather.wsf as the first step in Validation, and then the data is collected without problems, and the installation runs as expected. Any ideas to why this is would be greatly appreciated

Michael

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Thu, 13 Mar 2008 04:44:29 GMT

Hi Kongkuba,

Have you given the advanced client access account rights to the BDD database?

Thanks,

Ben

re: BDD 2007 - Troubleshooting Database issues

Jim — Wed, 26 Mar 2008 22:21:23 GMT

Hi Ben

I have a strange issue where the my domain joining credentials are changing in the middle of the process. My unattend.xml has the correct information in it but the bdd.log shows that somewhere along the way it changes it back to the credentials I supplied in bootstrap.ini to gain access to the deployment point share.

Thanks

Jim

re: BDD 2007 - Troubleshooting Database issues

BenHunter — Mon, 31 Mar 2008 01:58:01 GMT

Hi Jim,

BDD/MDT should only change the credentials if you update the DOMAINADMIN user settings and password.

Thanks,

Ben

Don’t forget our old blogs!

The Deployment Guys — Mon, 21 Apr 2008 21:31:59 GMT

I am very happy with the progress of the deployment guys blog so far. Hopefully you all agree that we