Question : Here is an odd issue that is causing me to lose all my hair. Every few days or […]
Tag: active-directory
Invoke-SQLCMD with special characters
Question : I’m currently working on a project integrating AD with SQL Server data, which I am handling mainly via […]
Effective SQL Server permissions when user is in several AD groups
Question : Using Window Authentication via Active Directory Groups, if an Active Directory user exists in two different Active Directory […]
SQL Server grant permissions to STANDBY database
Question : So, first: the setup. We have SQL Server 2012 (ServerA) running in domain A. We have SQL Server […]
Linux sqlcmd connecting to Windows Sql Server using kerberos
Question : I’m pretty sure I am going to have to expand upon this a bit as I am new, […]
See who has access to databases via AD group membership
Question : SharePoint has a button to “Check Permissions”. Here you can select a user from Active Directory, and it […]
Difference Between Sign In and Login (Users and Groups)
Question : I am trying to understand a paragraph from my notes, re Users and Groups in Active Directory. The […]
Windows Authentication for SQL Server Linked Servers
Question : Currently, on our project, we have a situation: there are a SQL Server 2012 instance IA in domain […]
troubleshooting login failure when AD group seems to be fine
Question : I am using the procedure xp_logininfo to find out what groups a user belongs to. I have created […]
Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC
Question : I just completed my first install of SQL as a server based, Enterprise Edition. I wanted to check […]