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 »
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 »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 »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 »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 »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 »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 »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 is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …
Read More »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 »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 »