How to Configure PowerProtect Data Manager to Use Local Account on Microsoft SQL Server for Backup

Are you an IT professional or user working with Dell Enterprise Hardware and Software? Are you looking for a way to configure PowerProtect Data Manager to use a local account on a Microsoft SQL server for backup? Look no further! In this video, we’ll show you how to do just that. Our step-by-step guide is perfect for both beginner and experienced users. We’ll cover everything you need to know, from creating a local Microsoft Windows user account to adding a user account to Microsoft SQL Server Logins and assigning roles and permissions. We’ll also show you how to configure credentials within PPDM UI to be used for SQL database backup. With our easy-to-follow instructions, you’ll be able to configure PowerProtect Data Manager to use a local account on a Microsoft SQL server for backup in no time.

Welcome to this tutorial where we will walk you through the process of configuring power protect data manager to utilize a local account on Microsoft's SQL server to complete our goal, ensure you have three key prerequisites in place. First, let's create a local user and include them in the local administrators group to do this. Launch computer management and navigate to users under local users and groups, right? Click to create a new user providing the necessary details.

Move to groups also under local users and groups and add the newly created user to the administrators group. Now add the user account to Microsoft sequel server logins and set up the required roles and permissions using Microsoft sequel studio. Expand the security section right? Click on log ins and select new login in the general section of the new login window. Choose the local user created earlier under server roles, assign the appropriate server roles to the log in.

For further details on user roles and permissions refer to the PPD M SQL user guide. Moving on, let's add credentials for the local user in PPM. Open the PPD mui navigate to the administration section on the left and select credentials, click the add button in the ad credentials window, choose or under type, give a name to identify the credentials within the PPD mui and enter the user name and password associated with the SQL server host.

Now, you can either add these credentials to the existing policies or include them. When creating new policies, you have also the option to save these credentials within PPM for future usage by clicking the add button. These credentials can also be assigned to the SQL server within the asset sources section by clicking the added credentials button. Once assigned these credentials will be used to back up databases on the selected sequel server.

Additionally, you will find an a option at the bottom of the drop down menu allowing you to include new credentials if you haven't already added them to PDM and there you have it, you successfully configured PPM to use the local account in Microsoft SQL server.

Thank you for watching. And if you need more information, don't forget to check the PPD sequel user guide.