Friday top tech tip:
If your iLO mouse pointers are out of sync try moving your mouse around in small circles inside the iLO console screen, after a few attempts you will notice the pointers getting closer and closer.
-
A small bottle of whole milk
-
A small bottle of contact lens (saline) solution
-
A bottle of regular fresh water.
-
Tampons
-
Sanitary pads
-
Athletic tape
I always always forget this so:
Per User CAL is for a set amount of users to connect to a TS server (a TS server with support for 20 users for example)
Per Device CAL is for a set amount of PCs to connect to a TS server (in a hot desking enviroment for example)
sql server 2008 & port 1433
There’s hundreds of guides about how to do this. I’m putting this here as a reminder to myself.
By default sql server 2008 doesn’t bind to a tcp/ip port.
Open SQL Server Configuration Manager on the sql server and select SQL Server Network Configuration (32 or 64bit). You’ll see a list of protocols, right click on TCP/IP and Enable it. Now right click again and go to Properties. Go to the IP Addresses tab.
You may want to set the port for IP1 & IP2. The TCP Port may be blank, enter 1433 in the field. Scroll down to the bottom and you’ll see IPAll. Enter 1433 in the TCP Port box. Press Apply & Save. You’ll now need to restart your instance of SQL Server.
Do netstat -an | find 1433 and you should see sql server LISTENING on port 1433.

