Monday, July 4, 2016

Prevent Excel from Refreshing Data When Copying and Pasting

Problem:

When copying dynamic data out of excel when pasting the value pasted changes.

Solution:

Change the setting in excel to perform automatic calculations:

File tab -> options -> Formulas side tab -> Under the calculation Options, workbook calculation, select manual. Optionally you can shut off recalculate workbook before saving depending on situation.





Source:
Co-worker and tested with my own application.

Wednesday, June 29, 2016

Recursively Reset Permissions in Windows Path Using iCacls

Situation:

Need folders and files under a specific folder to regain all inheritance from the specified folder.

Solution:

Run the icacls with the recursive and reset switches:

icacls <folder> /reset /t

/t = recursive
/reset removes any modifications from inheritance in the ACL. By default, folders will inherit their permissions from the folder above them.





The final step in this is to give the primary folder that you want to push inheritance from down through the folders the appropriate permissions, all child folders will then have access as intended.



Primary Source:
http://stackoverflow.com/questions/22327776/using-icacls-to-set-permissions-of-a-folder-to-inherit-recursively

Wednesday, April 1, 2015

Minecraft / MineOS End of Stream Issue

So I was recently working on a project to bring several servers into a single consolidated server that would allow my friends to join me, play on servers, but not have to have my desktop running 24/7 for that to happen. So I bought a server to run MineOS on but I want to run multiple versions of minecraft, including some serious changes in version (FTB/Tekkit) all the way to Vanilla. So during testing I was working with a vanilla server and a copy of the tekkit server. Once I finally got past the firewall issues (of which you can find the fix here) I ran into an issue with connecting to my vanilla server on a non-standard port (25564 and 25563). Well I found out something interesting, the tekkit game seems to be fine with connecting on the default port (25565) but not on alternate ports when connecting to a newer version of the game on those other ports. So I received an end of stream error from minecraft in tekkit while connecting.


SOLUTION:
Run Vanilla minecraft launcher with vanilla minecraft games and tekkit launcher for tekkit games.


Dumb... I know.... this took me a while to fix so I wanted to document it. There does seem to be multiple other possible issues with end of stream errors but this seemed to be the big one. Hope this helps someone else out.

Friday, August 22, 2014

d3dx9_43.dll is Missing

This is actually a two fold issue for my specific case.

My issue: Launching a game like World of Tanks or some other game that requires D3DX9_43.dll crashes with a cannot be found error

My sub-issue: When attempting to install DirectX Redistributible the error is given "directx an internal system error occurred"


How to fix it:
First you will need the DirectX redistributible: Get it here
Second, if you get the sub issue I had, you will need to modify the registry. Go to:

HKLM>Software>Microsoft>

IF a sub directory called DirectX does not exist, create it. If it already exists, modify the code called "version" to be anything other than what it is. I changed it to "installedversion" and re-ran the installer which then completed successfully. 


Thursday, August 21, 2014

Windows Backup to ESXi Virtual (B2V)

My problem: 

I have a backup from Windows backup (Server 2012 in this case) that I wanted to restore to an ESXi virtual machine.

My Sub-Problem: 

I could not get an NTFS mounted drive to mount into ESXi for the windows recovery system to work properly.

How I solved it: 

I created a virtual machine within Hyper-V which allowed the backup drive to be direct mounted. Ran through the restoring backup solution, then ran the VMware vCenter Converter Standalone to convert the Hyper-V machine to a virtual on the ESXi Server.

Things to consider for this project:

Requires two physical servers, not including the downed server. One of which running ESXI the other running HyperV, this cannot be a virtual machine of a HyperV server unless you can raw map the backup drive into that virtual machine (if anyone has any way of doing this and not requiring the HyperV server please comment).

Requires having storage space on the HyperV larger than the total hard drive space of the downed server.

Requires upward of a day's worth of time to complete even on high end hardware. It can require more time if there is large amounts of data being restored and migrated. The more data involved the longer the process. The lag I was getting seemed to be related to how fast the storage drives are, since I was using backup disks on a simple Raid 1 on sata drives the performance was low. The disk creation time took 100% active time on the disk at 60-80MB/sec.


My in-process problems: 


  •  The backup drive on the Hyper-V server must be "offline" to be mounted within the VM for cloning. 


    Solved by putting the drive offline through disk management.




  • The restore would not function because the destination drive in BIOS is too small. 


    Solved by creating a fixed disk which exceeded the backup size instead of a dynamic disk in the virtual machine settings (I had to create a 250GB fixed disk which required a fair bit of time so if it goes fast (A minute or less) and you have a larger sized disk, you will need to go back, it created a fixed disk by deleting the disk you just created, which should take around 400k if you haven't installed anything, and making a new disk and be sure to select fixed size). Your description should look like this (I originally created a partition too small explained below):
I later found out the error code I was getting (shown below) means that the target drive is smaller than the original backup drive which is required to be bigger by microsoft's backup system.

I then expanded my drive from 200 to 250 since my original drive was 236 (240GB SSDs) and retried.


  • When attempting the restore of the system, the search for a recovery file would take forever.
I was not able to find a "resolution" for this issue. I just bounced back and forth between find and refreshing the image searcher (Microsoft why can't we just target a file? Waiting is ridiculous for system admins, we know what we are doing (usually)). 

  • When I first got the P2V conversion completed successfully I ended up accidentally creating a hardware version 10 virtual machine. 
When I did so and got reminded that 10 is not capable of being managed through the vsphere system, I ended up restarting the rebuild process after deleting the virtual machine due to hard drive size limitations on my destination server. It turns out that there are some pretty simple ways to fix this. Most of them are detailed here but the last one just blew me away in frustration: 

  • Create a new virtual machine with required hardware version and attach the existing disk from the virtual machine.
So simple yet so frustrating after you already dedicate yourself to starting over from scratch. Yet again, lesson learned.

Wednesday, July 2, 2014

Fix Temporary User Profile Account or Missing Desktop Content

If you log in and get the following:





  1. Run REGEDIT
  2. Navigate to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList"
  3. You should find your profile key, with another named identically except for a ".bak" extension
  4. Delete the "normally named" key
  5. Rename the ".bak" named key to remove the ".bak" extension
  6. Restart your machine

If you do not have administrative privileges, you will need to first sign on with a user ID that does.
This will allow you to preserve all of the customization you "lost" without having to recreate everything. I have to do this at home all of the time.

Full credit goes to Michael Paxton for his post that can be found here.

Tuesday, October 15, 2013

Exchange 2013 Attachment Size

So I had to increase an Exchange 2013 server the other day and could not find any definite "This is how you do this on Exchange 2013" but found plenty on Exchange 2010 and lower. Well I tried some commands and the following worked for my situation where a recipient of the specific domain needed to receive a larger file attachment and those who were sending the client attachments were getting the message:

Delivery has failed to these recipients or groups:

<User>
This message is too large to send. To be able to send it, make the message smaller, for example, by removing attachments.




The fix to get this to work is to execute the following commands in Exchange command:

Set-TransportConfig -MaxReceiveSize (X)MB -MaxSendSize (X)MB

IE: Set-TransportConfig -MaxReceiveSize 30MB -MaxSendSize 30MB

In my situation I did not have to restart any services, just simply resent the previously denied email and the client received it.


My reference site:
https://www.simple-talk.com/sysadmin/exchange/increasing-email-size-limits-for-your-high-profile-users-in-exchange-2010/




I am in no way responsible for the actions you take with the information provided. Please note that this worked on my Exchange 2013 server but not necessarily with all servers. I provide this information on an educational basis and from educated experience only. If you are unsure about if this will work in your situation please continue researching it.