The problem:
When opening an Excel 2007 spreadsheet in Office 2003 w/ converter pack you receive stranger errors. The first error may say something like “C:\Documents.xls could not be found”. That would be great if that was the spreadsheet you were trying to open but it doesn’t matter what spreadsheet you open, It always says that exact same error. Then it will give an error for each word in the file name it self. For example, if you open a spreadsheet named “Bobs numbers.xlsx”...
Archive for the ‘Microsoft’ Category
Posted in 
Tags: 
Windows Deployment Services – My thoughts
Posted by John Sorensen on June 19th, 2009
Several months ago I retired an old helpdesk server that hosted a ghost cast server which our helpdesk department used to deploy desktops. Even though I was a big fan of ghost I knew that it was out-dated and I heard that Microsoft’s WDS was much better than its predecessor (RIS). I decided to try it out. At first I was a little overwhelmed by the setup which was probably due to fact I was use to ghost and not a WDS.
One thing that got me at first is that WDS is kind of like a framework which...
Volume Shadow Error 12292 Causing SQL Backups to Fail
Posted by John Sorensen on April 13th, 2009
When I reviewed our server backups that take place over the weekend I noticed that one of our SQL servers failed which was odd. In the servers event log it showed two errors relating to VSS… Event ID 12292 and 11. Seeing that SQL relies on VSS for backups I went to check the snapshots under the disk properties. Instead of seeing the shadow copy volumes and properties I saw an error:
“Volume Shadow Copy Service information: The COM Server with CLSID {65ee1dba-8ff4-4a58-ac1c-3470ee2f376a}...
Wuauclt.exe switches (old)
Posted by John Sorensen on March 25th, 2009
Some of the switches below are used with older versions of wuaclt.exe and may not work any more.
These switches for “wuauclt.exe” are good for troubleshooting WSUS client problems and Windows Updates. Some of the switches below are used with older versions of wuaclt.exe and may not work any more. Check your “windowsupdate.log” file in the “C:\Windows” to check the output of a command if any output exists.
The following feartures/switches are needed.
1. /? –...
Exchange 2007- Who’s logged in to what mailbox… when?
Posted by John Sorensen on February 27th, 2009
One thing I missed about Exchange 2003 was being able to easily go into the mmc and view the user and logon/logoff for every mailbox.
Get-MailboxStatistics | format-table DisplayName,LastLogoffTime,LastLogonTime,LastLoggedonUserAccount
Exchange 2007- Public Folder Permissions Example
Posted by John Sorensen on February 27th, 2009
Seeing that Microsoft is attemping to move away from public folders and stopped providing easy GUI managment tools I found that this is the easiest way to modify permissions for a nested PF and change all child objects. Its simple and it works…
1Get-PublicFolder -Identity "\(folder)\(folder)\" -recurse | Add-PublicFolderClientPermission -AccessRights owner (our desrired permission)
Export List of Exchange 2007 mailbox sizes – Powershell script
Posted by John Sorensen on February 26th, 2009
I have this script set as a sceduled task and runs daily on my companies Exchange 2007 servers. It helps to see not only the current sizes but to see if any mailboxes are getting out of control.
12345678910111213141516171819202122232425##############################################################
# Creates a file with all exchange 2007 mailboxes and sort by size
#
#
#
# Command, scheduled task or shortct (all one line of course)
# C:\WINDOWS\system32\WindowsPowerShell\v1.0\PowerShell.exe -PSConsoleFile...
Setup Exchange 2007 Firewall Headers
Posted by John Sorensen on February 6th, 2009
A few months ago email being sent from my company were being rejected by some spam filters. After looking into it I found that exchange 2007 places the internal IP address in the header, which is a private address. Exchange 2007 does this by default.
Each time an SMTP email is passed from one server to another, the receiving server records the hand-off in the SMTP headers of the email. This is usually recorded like this:
Customers often do not like their internal email infrastructure exposed in the...
