Archives | Tech Tips

Enable the Ability to Remotely Manage IIS

by Jacki Moody | Dec 13, 2016 | IIS, Windows

Remote management of Microsoft Windows Internet Information Services is turned off by default in version 7.x and higher. You must manually install and configure the Web Management Service to enable remote management. You will get this error if web management service...

Copy Database Workaround for “The login already has an account under a different username”

by Jacki Moody | Nov 18, 2016 | SQL

I ran across the error “the login already has an account under a different username” while trying to copy a database from one server to another using SQL’s copy database tool. This error occurred using both the SQL 2012 and SQL 2016 versions of...

Easily retrieve an Active Directory group membership’s recursive user list with PowerShell.

by Jacki Moody | Oct 17, 2016 | Active Directory, PowerShell

You can easily retrieve an Active Directory group membership’s recursive user list with PowerShell. This three-line PowerShell command will retrieve all users in the Domain Admins group, and all users’s in that group’s groups, without returning the...

SQL Add Auto-increment Identity Column to Existing Table

by Jacki Moody | Sep 16, 2016 | SQL

SQL server uses the Identity Specification to add a numbered column that automatically increments. You can add this to a new table you are designing or to an existing one. SQL uses integer as the data type, so you are restricted to integers for your automatic...

SQL Enable Broker

by Jacki Moody | Sep 9, 2016 | SQL

Some applications require broker to be enabled on SQL in order for the application to work correctly. This includes System Center Operations Manager (SCOM) and System Center Service Manager (SCSM). If broker is not enabled for those applications, changes that you make...

« Older Entries