Gain Administrative Access to a SQL Instance

security-policies-icon

Info

If a user requires administrative access to a SQL instance they can easily gain administrative access as long as the following is true:

  • The user is an administrator on the Windows Server that host the SQL instance
  • SQL Server Management Studio is installed on the Windows Server
  • PSExec can be copied to the Windows Server

Steps

  • Download PSExec and copy it locally to the SQL Server
  • Login to the SQL server with an administrative account
  • Find the installation location of SQL Management Studio
    • Typically somewhere under C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\
    • The name of the .exe is SSMS.exe

Read More

Change the Port HP SIM/VCEM Uses

Info

By default HP SIM/VCEM will run on port 50000. In some situations it may be required or desired to change this port. The steps below will walk through the process to change the port.

Steps

For these steps the partnerservice.bat script will need to be used. This script can be found in C:\Program Files\HP\Systems Insight Manager\

  • Stop all services with the command below

partnerservice.bat -stop all

  • RDP to the HP SIM/VCEM server
  • Browse to C:\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\deploy\jboss-web.deployer\
  • Edit the server.xml file
  • Replace port 50000 with the desired port
    • Port 50000 will need to be changed in 2 places
  • Start all services with the command below

partnerservice.bat -start all

Generate a CSR in Windows

Background

In some situations it may be necessary to create a Certificate-Signing Request within Windows. There are many different ways to create a CSR within Windows but the tool outlined on this page is bundled with Windows and doesn’t require any additional software.

Steps

  • Open notepad
  • Paste in the contents below and save as certificate-request.inf
  • Replace CountryCode, CompanyName and domain.com with the correct information

Read More

Create an SMB/CIFS share on Ubuntu

file-sharing-folderSteps

  • Install samba

sudo apt-get update
sudo apt-get install samba

  • Set the samba password for the user account that will be used with the share

sudo smbpasswd -a userName

  • Keep in mind that the user must already exist or a Failed to add entry for user error message will be thrown.
  • Create a directory to mount the share

mkdir /mnt/smbShare

  • Add the share config to the bottom smb.conf file

sudo nano /etc/samba/smb.conf

[shareName]
path = /mnt/smbShare
available = yes
valid users = userName
read only = no
browseable = yes
public = yes
writeable = yes

  • Restart SMB

sudo service smbd restart

  • Test accessing the new share.
    • If accessing from a Windows box then the username needs be pre-fixed with the name of the server hosting the SMB share
      • i.e. UserName admin should be UbuntuServer\admin

Upgrade Drive Firmware on an Isilon Cluster

Info

Occasionally EMC will release new firmware packages for various drives used in Isilon nodes. The process documented here can be used to upgrade the firmware on the drives prior to OneFS version 7.1. The firmware upgrade process prior to OneFS version 7.1 uses the Isilon Drive firmware package.

Prep-Steps

  • Login to support.emc.com
    • PowerLink account required
  • Search for Isilon Drive Firmware Package
  • Download the latest package (1.9 as of 02/2015)
    • Review the release notes of this package
  • Copy this package onto the Isilon cluster
  • Determine how the firmware upgrade will be applied
    • Serial – This is the recommended method. This requires physical access to each node in the Isilon cluster
    • SSH – This allows the firmware upgrade to performed remotely. Unfortunately in some situations the firmware upgrade process can fail after SSH has been stopped on the node. In those situations the node will remain offline until a reboot is performed via a serial connection. Therefore SSH is not the recommended method.
      • If using SSH then the Infiniband IP address must be used as opposed to the 1Gbe or 10Gbe interface. The Infinband IP(s) for each node can be obtained via the Web GUI by simply clicking on the node number and looking for the IP next to int-a or int-b.

isi_drive_firmware1

 

Read More

Upgrade Isilon OneFS

Info

This page documents the basic steps of upgrading the Isilon OneFS operating system. This specific upgrade was from 7.0.2.5 to 7.1.1.2 but the process and screenshots should be accurate for any 7.x upgrades.

Prep-Steps

  • If possible, perform a cluster reboot or reboot each of the nodes individually roughly 2 weeks prior to the OS upgrade
    • Skipping this step may cause the OneFS upgrade to fail on the last step.
  • Download the new version of OneFS from support.emc.com (PowerLink account reqd)
    • Click Downloads
    • Under Find a Product, type Isilon OneFS and hit enter
    • Browse to the desired version of OneFS on the left hand side
    • Expand the Full Release section
    • Download the package that ends in installation file
    • Place this installation file somewhere on the Isilon cluster that will be upgrade
  • If upgrading from 6.x -> 7.x or 7.1 -> 7.2  then a full cluster reboot will be required as opposed to a rolling upgrade.

Read More