Question : First, this is for SQL Server 2016. If I was on 2017+, I would be using sp_add_trusted_assembly. Just […]
Tag: active-directory
Azure PostgreSQL Active Directory Admin – works as my AD user but not as an AD group I’m in
Question : I have an Azure PostgreSQL server that is giving different connection results in Azure Data Studio (with the […]
Service Principal as SQL Active Directory Admin, does it use Graph API?
Question : I’m looking to use a service principal as the server admin, so it can be used in a […]
Creating domain user login from another domain?
Question : I have two domains named “Domain1” and “Domain2”. I have SQL server 2005 in Domain2, and users in […]
Add Active Directory User For Azure-SQL-DB
Question : I have an active directory user LDomainLUser and I want that user to be able to connect to […]
AD group added to SQL as sysadmin not allowing users to login who are part of the group
Question : So I am helping with some work and we have built a few servers in Azure with their […]
SysAdmin server role and Active Directory Groups
Question : I’ve been struggling to find best practices information or any advice regarding Active Directory Groups that provide group […]
Single Domain Controller for SQL Server Always On Availability Group
Question : I was wondering if SQL Server Always On Availability Group supports a single Domain Controller server as opposed […]
Are there any big security risks for opening ports 1433 and 1434 to VPN Only? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Login failed for user Error: 18456, Severity: 14, State: 11
Question : I have an AD group XYZ that I have added to SQL Server security with data_reader permissions. The […]