DataBase Engine Tuning Advisor

Discussion in 'Databases' started by RajanAM, May 29, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Is it possible to use the DataBase Engine Tuning Advisor?
    I get the following error when opening it.

    Thanks.

    ===================================
    Failed to open a new connection.
    ===================================
    In order to start tuning application needs to create some objects in MSDB database. You have to be a member of sysadmin fixed server role in order to initialize MSDB for tuning (DTAClient)
    ------------------------------
    Program Location:
    at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeTuningParametersDatabase()
    at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeConnection()
    at Microsoft.SqlServer.Management.DTA.Client.TuningServer.Connect()
    at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServerInternal(SqlConnectionInfo connectionInfo, SqlConnection connection)
    at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServer(SqlConnectionInfo connectionInfo, SqlConnection connection)
    at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.OnConnect(Object sender, EventArgs e)
     
  2. Bruce

    Bruce DiscountASP.NET Staff

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page