Unable to modify the SQL Server Maintenance Plan
I am using Microsoft SQL Server 2014 (SP2) (KB3171021) Standard Edition (64-bit) and I have created one Database Maintenance Plan on this server. I am able to modify all of the properties of the plan, however when I try to select the databases it gives me the following Error:
This task requires the connection to be initialized.
And when I click on "ok" I can see the following window but unable to see any database in it:
Can anyone explain this or give me any solution on this?
In order to access the "Local Server Connection" (creds you connected with in SSMS) to view databases instead of a specifically named saved connection, you have to launch SSMS as an administrator.
By default with UAC enabled, it won't ask when you open it, so you have to right-click and select "Run As Administrator" -- or you can save a shortcut that's set to always Run As Administrator.
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by