locked
Setting up MBAM - Unable to connect to the SQL Server instance RRS feed

  • Question

  • Hello all,

    I'm setting up MBAM. Setup a SQL server dedicated for this, setting up the databases runs fine.

    When I try to run the setup for the web-application, I get Unable to connect to the SQL Server instance.

    Firewall on the box is disabled, and I even get the error when I try to configure the web-applications on the SQL box itself.

    How can I fix this?


    Please visit http://www.bleumer.eu

    Monday, March 9, 2015 11:05 AM

Answers

  • The application pool account must have the following permission on the following MBAM DBs:-

    MBAM Compliance Status : Compliance Read role

    MBAM Recovery and Hardware : Recovery and Hardware Read role , Recovery and Hardware Write Role.

    If the application pool account has these rights on the MBAM DBs, it can establish the connection with the DataSource.

    For validation, browse the reporting URL using the application pool account credentials.


    Regards, "Gaurav Ranjan" =========== NOTE: Mark as Answer and Vote as Helpful if it helps =======

    • Marked as answer by Robert Bleumer Wednesday, March 11, 2015 1:09 PM
    Wednesday, March 11, 2015 1:08 PM

All replies

  • Does the account your logged in as have sys admin rights to SQL?
    Monday, March 9, 2015 3:14 PM
  • Yes, it does, added the user to both the Sysadmin and Serveradmin roles in SQL.

    Please visit http://www.bleumer.eu

    Monday, March 9, 2015 6:47 PM
  • The application pool account must have the following permission on the following MBAM DBs:-

    MBAM Compliance Status : Compliance Read role

    MBAM Recovery and Hardware : Recovery and Hardware Read role , Recovery and Hardware Write Role.

    If the application pool account has these rights on the MBAM DBs, it can establish the connection with the DataSource.

    For validation, browse the reporting URL using the application pool account credentials.


    Regards, "Gaurav Ranjan" =========== NOTE: Mark as Answer and Vote as Helpful if it helps =======

    • Marked as answer by Robert Bleumer Wednesday, March 11, 2015 1:09 PM
    Wednesday, March 11, 2015 1:08 PM
  • This was the issue. Solved it, thanks!

    Please visit http://www.bleumer.eu

    Wednesday, March 11, 2015 1:09 PM
  • Hi Robert,

    I think I am in need of urgent help, I am trying to setup MBAM 2.5 SP1 with SQL Server 2012 Standard. I have followed the guide on: http://www.mdtechskillssolutions.com/2016/05/microsoft-bit-locker-administration.html however each time I try to connect to any of the SQL databases from the MBAM configurator I get the message "Compliance and Audit Database, the operation failed".

    The error in the event log is;

    Log Name:      Microsoft-Windows-MBAM-Setup/Admin
    Source:        Microsoft-Windows-MBAM-Setup
    Date:          12/03/2018 17:13:24
    Event ID:      401
    Task Category: ConfiguratorUnexpectedError
    Level:         Error
    Keywords:      Configurator
    Description:
    Unexpected configurator error.

    Description:
    Exception thrown from feature provider.

    Exception:
    Microsoft.Mbam.Setup.Common.SetupException: An error occurred deploying the Data Tier Application ---> Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Unable to connect to target server.
       at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointServer.OnInit(ErrorManager errors, String targetDBName)
       at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment..ctor(SqlDeploymentConstructor constructor)
       at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentConstructor.ConstructServiceImplementation()
       at Microsoft.SqlServer.Dac.DacServices.CreatePackageToDatabaseDeployment(String connectionString, IPackageSource packageSource, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, ErrorManager errorManager)
       at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<>c__DisplayClass5.<CreatePlanInitializationOperation>b__1()
       at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
       at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<CreatePlanInitializationOperation>b__0(Object operation, CancellationToken token)
       at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       --- End of inner exception stack trace ---
       at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
       at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext)
       at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
       at Microsoft.Mbam.Setup.Common.Database.DatabaseProvider`1.DeployDac(DacServices services, String databaseName, CancellationToken cancellationToken)
       at Microsoft.Mbam.Setup.Common.ActionItem.Run()
       at Microsoft.Mbam.Setup.Common.ActionItemQueue.Run()
       at Microsoft.Mbam.Setup.Common.Database.DatabaseProvider`1.Enable(IProgress`1 progress, CancellationToken cancellationToken, T configuration)
       --- End of inner exception stack trace ---
       at Microsoft.Mbam.Setup.Common.Database.DatabaseProvider`1.Enable(IProgress`1 progress, CancellationToken cancellationToken, T configuration)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.<>c__DisplayClass34`1.<InvokeAsync>b__33()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at System.Threading.Tasks.Task.Execute()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.<InvokeAsync>d__36`1.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.<>c__DisplayClass2.<<EnableAsync>b__0>d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.<EnableAsync>d__8.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Configurator.ComplianceDBUIFeatureModel.<EnableTransacted>d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Configurator.BatchTaskModel.<>c__DisplayClass5.<<Commit>b__1>d__7.MoveNext()
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-Windows-MBAM-Setup" Guid="{14ACEACA-189B-535D-6F16-33804C7ABED9}" />
        <EventID>401</EventID>
        <Version>0</Version>
        <Level>2</Level>
        <Task>65133</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000080</Keywords>
         <EventData>
        <Data Name="Message">Exception thrown from feature provider.</Data>
        <Data Name="StackTrace">Microsoft.Mbam.Setup.Common.SetupException: An error occurred deploying the Data Tier Application ---&gt; Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. ---&gt; Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Unable to connect to target server.
       at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointServer.OnInit(ErrorManager errors, String targetDBName)
       at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment..ctor(SqlDeploymentConstructor constructor)
       at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentConstructor.ConstructServiceImplementation()
       at Microsoft.SqlServer.Dac.DacServices.CreatePackageToDatabaseDeployment(String connectionString, IPackageSource packageSource, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, ErrorManager errorManager)
       at Microsoft.SqlServer.Dac.DeployOperation.&lt;&gt;c__DisplayClass3.&lt;&gt;c__DisplayClass5.&lt;CreatePlanInitializationOperation&gt;b__1()
       at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
       at Microsoft.SqlServer.Dac.DeployOperation.&lt;&gt;c__DisplayClass3.&lt;CreatePlanInitializationOperation&gt;b__0(Object operation, CancellationToken token)
       at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       --- End of inner exception stack trace ---
       at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
       at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
       at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext)
       at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
       at Microsoft.Mbam.Setup.Common.Database.DatabaseProvider`1.DeployDac(DacServices services, String databaseName, CancellationToken cancellationToken)
       at Microsoft.Mbam.Setup.Common.ActionItem.Run()
       at Microsoft.Mbam.Setup.Common.ActionItemQueue.Run()
       at Microsoft.Mbam.Setup.Common.Database.DatabaseProvider`1.Enable(IProgress`1 progress, CancellationToken cancellationToken, T configuration)
       --- End of inner exception stack trace ---
       at Microsoft.Mbam.Setup.Common.Database.DatabaseProvider`1.Enable(IProgress`1 progress, CancellationToken cancellationToken, T configuration)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.&lt;&gt;c__DisplayClass34`1.&lt;InvokeAsync&gt;b__33()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at System.Threading.Tasks.Task.Execute()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.&lt;InvokeAsync&gt;d__36`1.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.&lt;&gt;c__DisplayClass2.&lt;&lt;EnableAsync&gt;b__0&gt;d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Common.FeatureProviderBase`1.&lt;EnableAsync&gt;d__8.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Configurator.ComplianceDBUIFeatureModel.&lt;EnableTransacted&gt;d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.Mbam.Setup.Configurator.BatchTaskModel.&lt;&gt;c__DisplayClass5.&lt;&lt;Commit&gt;b__1&gt;d__7.MoveNext()</Data>
      </EventData>
    </Event>

    Is this something you could help me resolve?

    Many Thanks,

    Matthew

    Monday, March 12, 2018 5:21 PM