MAP Toolkit: Increasing the SQL Database Timeout Value

MAP Toolkit: Increasing the SQL Database Timeout Value

If MAP is taking too long or fails at the assessment stage, you may want to increase the timeout value for the database.

To increase the MAP SQL database timeout value:

  1. Exit MAP
  2. Open the AppConifgInfo.xml file
    • Located in C:\Program Files\Microsoft Assessment and Planning Toolkit\bin
  3. Modify the SqlCommandTimeout value from 1800 to another value. I.e. changing the value from 1800 to 21600 will change the timeout from 30 minutes to 6 hours.
  4. Restart MAP and try running Tools > Refresh Inventory Assessment again.
Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Revision 4. Comment: Removing "(en-US)" from the title. Title casing.

  • Michael Switzer [MSFT CSG] edited Revision 3. Comment: Added product and language to title

  • Michael Switzer [MSFT CSG] edited Revision 2. Comment: Updated formatting to use ordered list

  • Michael Switzer [MSFT CSG] edited Revision 1. Comment: Added tags and added clarification "assessment phase"

Page 1 of 1 (4 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Michael Switzer [MSFT CSG] edited Revision 1. Comment: Added tags and added clarification "assessment phase"

  • Michael Switzer [MSFT CSG] edited Revision 2. Comment: Updated formatting to use ordered list

  • Michael Switzer [MSFT CSG] edited Revision 3. Comment: Added product and language to title

  • Ed Price - MSFT edited Revision 4. Comment: Removing "(en-US)" from the title. Title casing.

Page 1 of 1 (4 items)