Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What would a security checklist for an sql server look like? i am facing an error when i am trying to create SQL Server Failover

What would a security checklist for an sql server look like?

i am facing an error when i am trying to create SQL Server Failover Cluster. 

The error is Volume that contains SQL Server data directory does not belong to the cluster group.

However i have already create the failover cluster to link both Server together

sql.jpeg 

X File S -> Home Microsoft SQ Share Database Engine Configuration Actions Disks "Windo Specify Database Engine authentication security mode, administrators, data directories, TempDB, Max degree of parallelism, Memory limits, and Filestream settings. Add Disk Move Available Storage Quick access Global Rules Server Configuration Data Directories TempDB MaxDOP Memory FILESTREAM View Desktop Downloads Install Setup Files * Refresh Install Failover Cluster Rules Data root directory: C:\Program Files\Microsoft SQL Server Help Product Key System database directory: C:\Program Files\Microsoft SQL Documents Pictures License Terms Server\MSSQL15.SQLSITEB\MSSQL\Data * Feature Selection User database directory: C:\Program Files\Microsoft SQL Server\MSSQL15.SQLSITEB\MSS *** I SITEB-DBSERVER Feature Rules I SiteA-ADServer This PC Network tsclient Instance Configuration Cluster Resource Group Cluster Disk Selection Cluster Network Configuration Server Configuration Database Engine Configuration Feature Configuration Rules Ready to Install User database log directory: C:\Program Files\Microsoft SQL Server\MSSQL15.SQLSITEB\MSS Backup directory: C:\Program Files\Microsoft SQL Server\MSSQL15.SQLSITEB\MSS items e Installation Progress Complete The volume that contains SQL Server data directory C:\Program Files\Microsoft SQL Server\... The volume that contains SQL Server data directory C:\Program Files\Microsoft SQL Server\... The volume that contains SQL Server data directory C:\Program Files\Microsoft SQL Server\... The volume that contains SQL Server data directory C:\Program Files\Microsoft SQL Server\MSSQL15.SQLSITEB2\MSSQL\DATA does not belong to the cluster group. < Back Next > Cancel & ENG 1:28 PM 7/29/2022 D

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

Define the term CHAMPERTY

Answered: 1 week ago

Question

Redo Problem 5.34, given 6x1 + 4x2 = 47 2x1 +9x277

Answered: 1 week ago