You have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …
Read More »
Windows
How to Fix “Cannot open backup device” Error?
When you want to back up your database, you may see “Cannot open backup device” error as you see in the picture below. To resolve …
Read More »How To Add MS DTC To The Cluster
In this article I will tell you how to add the MS DTC service to the windows cluster. First, we open Disk Management. You …
Read More »How To Define a Share and Map This Share To Windows
In this article We create a share on a server and then we map this share on a server. I selected MSSQL as Category. …
Read More »SQL Server Password Policy
When creating a SQL Login, you can select the Enforce Password Policy option as described in my article “How To Create a Login On …
Read More »Security Policy for SQL Server(secpol.msc)
After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows for the performance of SQL …
Read More »What is Mounted Drive and How to Create It
We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …
Read More »SQL Server Configuration Manager Settings
SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …
Read More »SQL Server Service Account’s Permissions on Windows
Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is not necessary. You must not …
Read More » How To Detach and Attach a Database Containing FileStream Data
You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …
Read More »