-
Keeping your Server Secure Part 1 : Login Password Policy
Dear readers, Now we are going to cover very important activity from a DBA perspective. Database\Server Security is the one of the most important thing on which any organisation relies solely on Database Administrators. Each company has its own sets of Policies applied to Logins & Users and these policies should be thoroughly reviewed…
-
SQL Server Day to Day issues- Part2
Here comes another issue that is being faced by DBAs frequently. (Read part 1 here) Issue- SQL Server Instance fails to start A number of problems can prevent the SQL Server service from starting. Let’s go through each of them. 1) Service account password incorrect or account locked or disabled If someone changes the SQL…
-
Script : How to find SQL Server orphan Logins?
Dear Readers, An attempt has been made to write a short script to find out SQL Server Orphan Logins. By the way, I am not sure if Microsoft has any term like “Orphan Login” within their documentation. However, I have seen that many people are talking about Orphan Logins but not orphan users. There is a difference…
-
Script : Who all have access to SQL Server via AD Groups?
Dear Reader, Few days ago, I was looking for a script to find out who all have access to SQL Server via AD Groups. There are a couple of good scripts available for this task. However I thought of re-inventing the wheel. You are free to modify and re-share it. This script works with SQL Server…
-
Database Permissions extraction script
Dear DBAs, Few days back one of my junior colleague reported me that while performing database refresh, he extracted the permissions of database before refresh and applied the permissions back on it after restore but still all permissions were not applied correctly and user is reporting access related issues. I checked and found that the…
-
March towards SQL Server : Day 2 – SQL DBA Interview Questions Answers – Security Permissions
1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is authentication. Authorization is the process of verifying that you have access to something. Authorization is gaining access to a resource (e.g. directory on…
-
How to enable remote connection to SQL Instances from single SQL Server Management Studio?
Problem : All SQL Server Instances in the Environment are not able to connect from central SQL Server management Studio. Resolution: Below steps need to be followed to enable Remote Connection : 1) RDP to the SQL Server on which remote access needs to be enabled. 2) Open SQL Server Configuration manager (Start>All Programs>Microsoft SQL Server>Configuration Tools>Configuration manager) 3)…
-
How to get access on SQL Server if you don’t have “sa” password or sysadmin access?
PROBLEM DBAs need to have sysadmin access on SQL Server to support Databases effectively. There may come situations where DBAs neither have sysadmin access nor [sa] password. In that case, DBA needs to perform below activity to get the access. RESOLUTION PREREQUISITES: 1) Administrative privileges needed on Host Server. 2) Downtime of approximately 10 minutes…