Showing posts with label management. Show all posts
Showing posts with label management. Show all posts

Friday, November 21, 2014

SQL - If you don't have permission to logon fix

Purpose: If you don't want to put a SQL db into single user mode, you can try the following to give yourself permission to a SQL instance. The following will open a command prompt as the built in security principal "System" using PSExec. psexec -i -s -d cmd From there open SQL management studio from within that command prompt. ie: c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" I came up with this independently, but a simple google search will show you others have figured it out as well. Should be able to now give yourself permissions to log on now depending on how the SQL was initially configured. If this doesn't work you will have to Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.

http://msdn.microsoft.com/en-us/library/dd207004.aspx

Monday, October 7, 2013

VMware: Change Load Balance Policy to IP Hash on ESXi Host Console

This command changes the vSwitch Load Balance Policy to iphash

esxcli network vswitch standard policy failover set -l iphash -v vSwitch0

This command changes the Port Group Management Network Load Balance Policy iphash

esxcli network vswitch standard portgroup policy failover set -p "Management Network" -l iphash

Powershell: Microsoft Graph to add new roles to application registration

PowerShell Script Bulk add new roles to application registration in azure. Update $roles with ,Us...