Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Groups

1
January 14, 2012  8:00 AM

PS script to check SQL Server Groups



Posted by: Colin Smith
AD, Groups, Powershell, SQL Server

This is the script that I threw together to check and see if a user is in multiple AD Groups that are logins to the SQL Server instance. This helped me resolve an issue and it may help you look for things like explicit deny or some other reason why a user does not have the access they need or...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 30, 2011  4:13 AM

Powershell to add logins to SQL Server



Posted by: Colin Smith
Groups, Logins, Powershell, SQL Server

This is a script that I threw together for an app that needed to have 60 logins created on the sql server. We had all the ad groups created using a standard naming convention.
app_dev_groupname
was the standard that we went with so here is...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

April 13, 2010  5:00 PM

Powershell: AD Groups



Posted by: Colin Smith
AD, Groups, Powershell

Two weeks ago was part of implementing a large upgrade in one of our Sybase environments. In order for this upgrade to be succesful we had to do some work in some AD groups. We needed to find all the users that would need to be a member of the new group that we were creating and take them out of...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

July 30, 2009  3:17 PM

Add a AD Group to MSSQL Server and add to a role using Powershell



Posted by: Colin Smith
Database Administration, DBA, Groups, Powershell, Roles, SQL Server

In SQL Server 2005 the Builtin Administrators group is a login, by default, to your MSSQL Server Instance and is also a member of the sysadmin role. Well this has been changed in SQL Server 2008 with good reason. I decided that I would like to add a group for my DBA Group to every SQL Server in...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1