Management reporter timeout error while data mart creation
While installing MR 2012 CU15, the database creation process threw an error. In checking the deployment log I discovered the following error:
Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Error SQL72014: .Net SqlClient Data Provider: Msg -2, Level 11, State 0, and Line 0 Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Error SQL72045: Script execution error.
For the above error you need go to the below path and increase the timeout time in Sqltimeout value change it to 12000000. Once the value is changed restart the Management reporter services and again start the process of data mart creation.
C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console
The database deployment failed. Additional information:
