SQL Server: Set up a backup plan

Edit plan

Introduction In this article, I will explain how to set up a backup plan with SQL Server. In this tutorial, we will use the wizard available in SSMS to configure the database to save as well as the schedule and then we will modify the plan to indicate the location. Prerequisites SQL Server (no Express …

Read more

Install WSUS with a SQL Server database

Since Windows 2016 server, it is possible to install the Windows Server Update Service (WSUS) directly with a SQL Server database. In this article we will see how to proceed. Prerequisites To install WSUS with a SQL Server database you need: Windows 2016 or 2019 server for the WSUS role An instance of SQL Server …

Read more

SQL Server configure remote access

This article describes how to configure remote access to a SQL Server (EXPRESS). 1. Open the SQL Server Configuration Manager. 2. Go to SQL Server Network Configuration / Protocols for SERVER NAME, then right-click TCP / IP and click Properties. 3. Go to the IP Addresses 1 tab and then search for the IPAll 2 …

Read more

sqlserver error 0x80041010

Problem When opening the SQL Server xxxx Configuration Manager you get the following error message: “Unable to connect to the WMI provider.” You do not have the required permission or the server is not accessible. that you can manage SQL Server 2005 or later with SQL Server Configuration Manager Invalid Class [0x80041010] Cause According to …

Read more