OWSUG.ca

Welcome to Ottawa's Windows Server User Group Community!
Welcome to OWSUG.ca Sign in | Join | Help
in Search

Canadian IT Pro Blog

Browse by Tags

All Tags » Microsoft Office   (RSS)

  • Getting serious about OS Deployment with MDT 2010 Update 1

    Over at the Windows team blog – Stephen Rose wrote about the new RTM update of Microsoft Deployment Toolkit 2010 to what’s known as Update 1. For those of you familiar with MDT already – this shouldn’t be a surprise to you – it’s an incremental update that has been in the works for a while. For those of you who are NOT familiar with MDT – it’s our FREE (as in beer) solution accelerator that anyone can use working for any company (including independent consultants) of any size (yup – a few PCs to 100’s of thousands) to make their lives SO MUCH EASIER when undertaking the task of deploying and maintaining “builds / images” of workstations.

    Newbies note below: the basic flow of using MDT for Light Touch and Zero Touch. (more info at Microsoft Deployment Toolkit Home)

    image

    You can use MDT to create and manage your deployment medium: anything from a simple bootable USB stick all the way up to an integrated mass deployment System Center Configuration Manager or PXE boot process.  Microsoft Deployment Toolkit 2010 Update 1 supports deployment of Windows 7, Office 2010, and Windows Server 2008 R2 in addition to deployment of Windows Vista, Windows Server 2008, Windows Server 2003, and Windows XP.

    Existing MDT users note: you will need to update your deployment shares. Make sure they are not currently in use or the upgrade will fail. Earlier reports of wrong files for download links have been resolved. You will need to uninstall Beta Update 1 before installing the final RTM of update 1. Check out Michael Neihaus’s blog for details and READ RELEASE NOTES.

    If you use MDT with SCCM -

    • new User Driven Installation deployment method. Gives target users more guided control over their deployment.

    If you are a Light Touch user (USB stick, DVD or other)

    • Office 2010 integration (still supporting older versions of office)
    • Improved Driver importing to more accurately determine what OS version they are targeting.

    Common for Both SCCM and Light Touch users of MDT 2010

    • lots of fixes and improvements from Beta and feedback process
    • continued support for older OS and apps (XP, Server 2003, Server 2008, Vista, Office 2007)

    If MDT is new to you or if you are about to start looking into deployment of new desktops / managed desktops – you really owe it to yourself to refresh your skills with deployment tools. MDT is LIGHTYEARS ahead of what I used to do as an administrator rolling out Sysprep’ed images of Windows 2000 Pro way back when. I’d give my right arm to be able to have MDT available when I was in charge of that customer rollout.

    Download for MDT 2010 Update 1 (including Print Ready Documentation)

    Rick
    IT Pro Team Blog | IT Managers Blog |Twitter | Facebook | LinkedIn

  • Automated Install of Office 2010

    With Office 2010 out the door more and more people are adding it to their deployment plans.  Sean Kearney, aka the Energized Tech, put together this post on how to customize a silent install of Office 2010.  Check it out and bookmark the page for when you are tasked with this job :)

    ------------------------

    I Learned a neat trick I’d like to share with you all.  It’s called “How to do a basic silent install of Office 2010”

    This works on Project 2010, Visio 2010 and Office Professional 2010.   But the technique is not unique to them.  Just the particular commands.

    In truth, this is nothing new.  You could ALWAYS automate the install of Microsoft Office.  If you had a Volume license version, you could setup a copy of the Network (Administrative Install).  Your other choice was the Office Customization Utility.

    But again, those were targeted to the Volume licenses.

    YOU can take advantage of those same techniques, if only to simply the install for your technicians and Customers.  Make life simpler.

    Shhhhhh… don’t tell.  It’s actually quite easy.

    First off, if you have the installer that is a Single file executable you’re going to need to produce the Install folder we all know and love.   It’s an easy task to pull off.

    I cheated.

    I typed on the command prompt

    en_office_professional_plus_2010_x86_515486.exe /?

    and it produced this lovely bit of info!

    image

    So I created a little folder on C: called “Office” (Did I mention I’m not very creative with my folder names?) and ran

    en_office_professional_plus_2010_x86_515486.exe /extract:C:\Office

    Giving me after a few seconds of a progress bar my familiar old friend the install folder.  Please note, if you have the DVD, you can just go ahead and copy the Files but presently we Technet/MSDN users have a giant executable

    Next you need to create a file at the root of that folder called “Custom.XML”.   Now you can get a SAMPLE of it online at Technet’s Config.XML Technical Reference . It’s right near the bottom.  But if you look in the mail folder under the root ending .WW like this picture here

    image image

     

    You’ll find there is copy sitting right inside there.  Just to save you some time I found a few things about that file (and why It didn’t work for me the first time)

    Lines beginning with “<! -–“ and ending with “ ––>” are comments.  Everything in between is just eye Candy until you get rid of the comments.

    Don’t just uncomment everything.  Doesn’t work.  You’ll have a silent install launching and caching data and doing nothing.   Well nothing except eat up CPU cycles.

    Simplicity is best.  Start with some SMALL automating (like the Company Name / User Name) and work your way up.   Makes troubleshooting the first time easier.

    But here’s what I found, I only needed about 6 lines to make it all work. Best of all?  It’s takes NOTHING (I mean NOTHING) to carry that Config.XML file to another Office Product and change it for that Product. 

    All you need are two pieces of info, The Product Name and the Product Key.  One is easy to find, it’s stuck on the box or with the OEM pack.   The other is found by looking into that magic .WW folder.   Inside there is another .XML file called “SETUP.XML”.  Open that with Notepad or your choice of editor for Text Based file and look for the line marked <Setup Id=”ProPlusr” Type (yadda yadda yadda doo dah)

    image

    That part between the quotes is your ProductID (Professional Plus Retail, Visio etc)

    So with THIS simple XML file (Yes, I’m going to save you the nasty work)

    ------- Begin Custom.XML ------

    <Configuration Product="VisioR">
    <Display Level="Basic" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" />
    <USERNAME Value="MyUserName" />
    <COMPANYNAME Value="MyCompanyName" />
    <OptionState Id="ProductFiles" State="local" Children="force" />
    <PIDKEY Value="AAAAABBBBBCCCCCDDDDDEEEEE" />
    </Configuration>

    -------- End Custom.XML -------

    This is for Visio (as can be seen by the first line

    “<Configuration Product=”VisioR”>

    This is the line you need to edit for whichever Office Product you are installing

    The line marked

    <Display Level="Basic" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" />

     

    Controls just how much information gets thrown at the user. In this case it’s Basic (Status Bar), No completion Notice with the EULA Accepted and Errors hidden away

    These Two fields are pretty self explanatory and no, you don’t need to have them in.

    <USERNAME Value="MyUserName" />
    <COMPANYNAME Value="MyCompanyName" />

     

    This line marked “OptionState”

    <OptionState Id="ProductFiles" State="local" Children="force" />

     

    Will identify the options you’re going to install.  You can find several examples of these “OptionID” inside SETUP.XML But I found this one (the Root) the most useful.  In a nutshell I have selected “Install ALL of it”.  I like to keep this simple.

    Of course this is the most important line, the Product Key.

    <PIDKEY Value="AAAAABBBBBCCCCCDDDDDEEEEE" />

    Replace the part between the quotes with your 25 digit product key WITHOUT the “-“ (Hyphens)

    If you choose to NOT have the Product key entered, I recommend changing the “Basic” to “Full” under <Display Level="Basic"

    It won’t be a true “silent install” but it’s only Two clicks of a mouse which isn’t bad.

    If you’re running an OEM or RETAIL key on the install and WANT a silent install you’ll have to delete the subkeys BELOW this registry key on each workstation to prompt the user for the Key upon startup

    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\Registration\

    That should prompt for a new Key upon startup of Office

    But honestly?  Look into a Volume License copy of Office and Windows anyhow.  There are some great advantages with it (Like the ability to just have ONE deploy point and image and the Office 2010 Customization tool.   That Tool can take your Silent deploys to a whole Nudda level!)

    But there you have it.   Office 2010.  East to deploy with just one file.

    The Power is in YOU

    Sean
    The Energized Tech

  • RunAs Radio – Nick Simons Puts Office on the Web

    As part of EnergizeIT 2010 we have partnered with RunAs Radio to produce some podcasts on Office 2010.  In this episode Richard and Greg talk to Nick Simons about the upcoming Microsoft office Web Apps. Web Apps are lightweight versions of Word, Excel, PowerPoint and OneNote available through Sharepoint 2010 or soon via Windows Live SkyDrive. The conversation digs into how users can interoperate between regular Office 2010 and Web Apps as well as the ability to collaborate (simultaneously edit) a document with multiple users using both Office 2010 and Web Apps.

    MP3

    itunes

  • RunAs Radio – Robert Manages SharePoint 2010

    As part of EnergizeIT 2010 we have partnered with RunAs Radio to produce some podcasts on Office 2010.  The first podcast of this 4 part series was posted yesterday.  If you don’t already subscribe to RunAs Radio I encourage you to do so.  It is a great podcast aimed directly at IT professionals.

    -------------------------

    In this episode Richard and Greg talk to Robert Crane from the Computer Information Agency in Sydney Australia about SharePoint 2010. The show digs into the issues that companies face when using SharePoint without careful governance to manage their data well. Check out Microsoft's Sharepoint Governance Resource Center for more information.

    MP3

    itunes

  • RunAs Radio – Rolly Talks about Project Server 2010

    As part of EnergizeIT 2010 we have partnered with RunAs Radio to produce some podcasts on Office 2010.  The first podcast of this 4 part series was posted yesterday.  If you don’t already subscribe to RunAs Radio I encourage you to do so.  It is a great podcast aimed directly at IT professionals.

    -------------------------

    In this episode Richard and Greg talk to Rolly Perreaux about Microsoft Project 2010 and Project Server 2010. Project moves into the 64 bit world in 2010 and a host of other features. Rolly digs into Project Server to take project management to an even higher level.

    MP3

    itunes

  • RunAs Radio – Rodney Talks about Office 2010

    As part of EnergizeIT 2010 we have partnered with RunAs Radio to produce some podcasts on Office 2010.  The first podcast of this 4 part series was posted yesterday.  If you don’t already subscribe to RunAs Radio I encourage you to do so.  It is a great podcast aimed directly at IT professionals.

    -------------------------

    Richard and Greg talk to Rodney Buike about the upcoming Office 2010. While he couldn't commit to a launch date (go search online, there's lots of rumors), it is safe to say that Office 2010 will ship in 2010. Rodney digs into the relevant changes in the suite, including the focus on Microsoft's "three screens" strategy, providing equal access online, on the desktop and on mobile devices. Check out the Office Product team blog at http://blogs.technet.com/office2010 and the Outlook 2010 Beta at http://www.microsoft.com/office/2010/.

    MP3

    itunes

  • Office 2010 Beta is here!

    Office_main Woke up this morning and as is my usual custom I started reading my RSS feeds before starting the day.  And what do I see?  Office 2010 Beta, SharePoint 2010 Beta and more is available for TechNet and MSDN subscribers!

    That’s right, if you have a TechNet and/or MSDN subscription you can head on over and download the first public beta of Office 2010!  Have you been to TechDays?  Yes?  Then fire up that subscription and get downloading!

    If you don’t have a subscription, have no fear!  The beta will be available at the TechNet Eval Centre later this week!

    What a way to start a week!

  • Office 2007 SP2 – What You Need to Know

    Office 2007 generic brand h Office 2007 Service Pack 2 was released today and aside from rolling up all the hotfixes released since SP1 there are some additional changes provided by this update.  There are three key changes in Office 2007 with SP2.

    1. Interoperability – Office 2007 SP2 adds support for read, write and save capabilities for the ODF 1.1 file format.  There is a great blog post on Working with ODF in Office 2007 SP2 you should check out, as well as these resources for more specific information on what Word, Excel and PowerPoint support.

    Performance – Office 2007 SP2 also adds increased performance and reliability to Office client applications and servers.  Outlook 2007 SP2 as an example, includes improved calendaring reliability and performance enhancements which has been a pain for users and administrators.  I’ve noticed a significant improvement in performance since I installed SP2.

    Converter API – Office 2007 SP2 adds a new API, called the Converter API, which will allow Office developers to include support and conversion options for the ODF 1.1 file format in their Office add-ons and applications.

    The Office Sustained Engineering blog has a list of all the changes to the Office client applications and servers posted on their blog but I pulled out a few I think will be of interest to most..

    • Save as PDF or XPS add-in has been built in to SP2
    • Outlook startup, shutdown, view rendering, and folder switching performance has been improved
    • WSS and SharePoint add support for FireFox 2.x and 3.x

    Office 2007 SP2 will support Vista SP2, Windows Server 2008 SP2, Windows 7 and Windows Server 2008 R2 once they are released as well.

    For more information on Office 2007 SP2 please see the following links:

  • Green IT for the Home?

    Typically when you hear about Green IT it is all about virtualization, power and cooling savings, reducing the carbon footprint etc…  But did you know that there is a lot more you can do everyday to be more green?  Since it is Earth Day I thought I’d share some of these tips I found on the http://www.microsoft.com/athome/default.mspx newsletter.

    One planet, OneNote

    addthis_pub = 'CDNDPE';

  • IgniteIT Awards Finalist - Outcrypt

    205x115_IgniteITAwards_banner_01

    Project: Outcrypt: Email Encryption as an Add-In for Outlook 2003 & 2007

     

    The Challenge

    Describe the situation, challenge or problem you or your team faced.

     

    Email is not thought of as a secure method of sending confidential information. Servers can be made secure, firewalls can be put up front, but once the email is received, it can sit on a laptop, BlackBerry, cell phone, or PDA, for anyone to see. The emails can be grabbed en-route as well. Formula1 teams have endured major fines from leaked information. Public companies incur insider trading risks when information is leaked to the wrong party. Insurance and financial companies have had losses of private information sent to the wrong party.

     

    The Solution

    Describe how your solution helped overcome the challenge. Tell us about the innovative ways you used technology to create this solution.


    What obstacles or roadblocks were overcome? Is the solution reusable elsewhere? Be specific!

    The solution is to encrypt the email at the source. We created an Outlook Add-in to encrypt email so that the only people who can read your email are the intended recipients. This Outlook 2003/2007 Add-in uses highly secure AES-256 CBC encryption technology. The key is not saved in your, or the email recipient's, computers or servers, or embedded in the software. There is a unique key for every recipient, so one recipient can not read another's email. The key is not available to any administration staff. Key retrieval is done inside an AES-256-CBC tunnel, and never stored. Notification or account usage, if appropriate, is on your Outlook 207 Email toolbar.

     

    The Results

    What positive impact did your solution have in the workplace, the community, or at home?

     

    The email remains encrypted until the intended recipient decrypts it, and it can be re-encrypted to protect its information, but it is never stored on some other intermediate server. This add-in negates the need for awkward VPNs, unruly hardware requirements, or any interruption in your daily business flow. The encryption process is very quick. You can set up the entire service within your environment, or simply ‘subscribe’ to the service from our environment. There simply is not a more secure way of sending & receiving email, to or from anyone, anywhere, in the world. For a quick demo, see: http://www.devantec.com/demo/

     

    Other Information

    Feel free to let the community know about any interesting or humorous tidbits you feel will add to your submission.

     

    This was difficult. haha. What isn't, when the end result seems so simple?

     

    Products Used

    To help the community understand the scope of your project, please select the technologies utilized.

     

    Windows/Web Client, Development Platform/Tools

    Web Technologies, Office Productivity

    Security Systems, MS Office 2003 Primary Interop Assemblies, MS VSTO 2005 SE, Outlook 2007 Primary Interop Assemblies, Visual Studio Tools for the Office system 3.0, MS VSTO Office Interop Extension Libraries 1.0

     

    Submission Hyperlink

    http://www.microsoft.com/canada/igniteit-awards/view_submissiondetails.aspx?id=339

  • A Few Sleepless Nights

    A while back Ruth did an interview with Cameron McKay about an upcoming infrastructure project he was in the planning stages on.  While the planning is done and the implementation also complete, I thought it was time to revisit with Cameron and talk about how things went.  Turns out Cam was one step ahead and posted an entry on his blog which we are cross posting here.

    -------------------------

    And here we are.... it's March 15th, I'm now 25 Years old, and the largest infrastructure project of my career to date is wrapping up. Now, I originally planned to have all work completed in a weekend... I may have been off by a week or two. Not a result of unknown factors, but delays in setting up systems and the occasional hour or two of sleep.

    February 27th at 10PM my Team and I started by redirecting all web facing sites to the ubiquitous "planned downtime" graphic to alert clients that the geeks are hard at work somewhere... :)

    First up on the task list was to modify our Cisco switches and firewalls and setup 10 new VLAN's. The tricky part here is that the Cisco VOIP servers also need to be re-IP addressed and this is where we had to take our time. While our contractors were busy checking everything with the telephony systems, our team was busy setting up the base AD Infrastructure (DNS, DHCP) and getting ready to deploy all our new servers.

    What servers exactly?

    • Windows Server 2008 /w Hyper-V
    • Exchange Server 2007 SP1
    • SQL Server 2008
    • IIS7
    • Team Foundation Server 2008
    • Office Communications Server 2008 R2
    • Groove Server
    • ForeFront Client Security
    • SharePoint Office Server 2007

    Not to mention:

    • WSUS
    • NAP
    • Certificate Services
    • Rights Management
    • File Screening

    And if that wasn't enough... We rolled out Vista Enterprise and Office 2007 to 100 workstations and also deployed the latest Blackberry Enterprise Server. I also felt the need to deploy the latest version of GFI Faxmaker to handle our some 300 faxes a day at the office.

    And of course, it's all managed by System Center.

    So around 2am on Saturday morning all the network changes were completed and the base AD deployment completed. At this point, we have taken a flat network and diced it up into 10 VLAN's, a DMZ, and 4 Windows domains. I'm still pretty excited and pushing through the night.

    Next up was taking all our existing physical and virtual servers and switching the IP's. This took us until around 6am...

    We took a coffee break and then moved onto deploying Exchange Server 2007. About this time I realized that I haven't slept yet and shrugged it off... I'm an IT Pro. At 9am we brought our SQL Servers online and IIS 7 web farm. My network team was working on all the ACL's and settings for the DMZ to make sure that we were ultra secure, as this is a Fortune 18 we work for and information security is paramount.

    Our developers came in around 10am to start migrating content from the old network and get the business up and running again. One challenge here is that there was no connectivity from the old LAN to the new network, so terabyte hard drives were used to move all the files.

    This took the better part of the day to get all the files over and onto the new servers. Once this was done, the Dev's could start configuring all the new database servers and IIS sites. I had our network team leave the edge network accessible from the internal LAN to make it as easy as possible for the development team to get access and complete the migration.

    Around 6pm on Saturday evening the Boss realized that I hadn't been to sleep yet and "suggested" that I go over to the hotel and get a few hours sleep. I slept from 7 until 11 and then showed back up at the office to continue working on the deployment.

    Sunday morning we started our LT deployment of Vista and Office 2007 to all the desktops. I was left configuring Exchange 2007 and the Blackberry Server and a half dozen other servers. We were having some issues with migrating the data. As it turns out, moving everything onto SQL 2008 and IIS7 is a big deal. Who would have thought? At this point, the comment of "backing out" came up. I didn't like the sound of that... and the discussion became a pow-wow a couple hours later.

    I'll spare everyone the discussion, but we decided to push forward and not roll back. Forgetting that all the workstations were already converted to Vista and on the new network, it would of been about 6 hours work to bring the old LAN back up.

    Around 2am on Monday morning I had my first real challenge of the deployment. The Exchange Hub Transport and Edge Servers suddenly stopped working. The EdgeSync connectors were all there and all the settings were correct and by-the-book.... but still, I couldn't send or receive email. So, 6 hours from the start of business, email was down. This was my worse nightmare. After a couple hours of troubleshooting and rebuilding the EdgeSync, I had email working again.

    Come Monday morning, we had core systems online and our CRM application was functional but none of the file shares or printers were up. Throughout the day we were busy assisting the developers, as their apps are all client facing and most of my Infrastructure changes were completed.

    Again, sent over to the hotel late Monday afternoon for a few hours sleep. Back at the office come 2AM. At this period, I'm feeling like the biggest geek in the world... and loving it.

    Tuesday I had the file shares and printers online. The task for the next couple days was to import all the old email from our 5.5 server and load it into each users new mailbox. This was a tedious task that took us until Friday to complete. Why? Lot's of old email...

    Over the weekend we brought ForeFront Client Security online. This is probably my most favorite piece of the new Infrastructure. All workstations and servers were now protected.

    The following week we were tweaking group policies and completing the configuration of all our web portals and databases.

    Fast forward to today. It's Sunday March 15th... and we have the most modern network in the company. Built for High Availability and Security from the ground up using the latest Microsoft technologies. I am very proud to say that I was apart of this great project and it has definitely been a fun and exciting ride.

    The best part is that 90% of the Datacenter is virtualized on Hyper-V. I'm a huge fan of the technology, and the benefits it provides our business in the DR / BC areas.

    It was interesting to see the entire IT Team, all 9 of us, pull together and stand unified behind this project. Sure, it's difficult and I've only had 20 hours total sleep in two weeks, but this is what I live for. We now have a platform to work off of that will drive the business for the next 6 Years.

    Was it as easy as I thought? NO. Would I do it again knowing what I know now? YES. Why? Because it had to be done. Our business is very competitive and we were working off technology that was 10 to 15 years old. More time was spent on maintenance and workarounds, then innovation.

    And how do I feel? Great. I slept in this morning and looking forward to getting back into the office tomorrow to work on my new state-of-the-art Infrastructure. All 100% Microsoft software based.

    ------------------------------

    You can read more about the project at Cameron’s blog!

  • Office Tip of the Day

    clippy Remember Clippy?  That (not so) loveable little feature in all versions of Office previous to Office 2007?  How it would appear with helpful little hints on how to get more out of Office?  My impression is that this is the most often turned off feature in older versions of Office, mostly because of the poor timing.  Nothing is worse than having something appear on screen in the midst of the final rush to get a proposal out the door.

    With Office 2007 Clippy was laid to rest, much to the relief of a lot of Office users out there.  Clippy was gone and I could go about my work without worry of having him (or her?) interrupt at an inopportune time.  But alas where can we go to get tips on the new Office?  I recorded a short video to help with the transition from the old UI to the new UI but how does one go about learning about the new (and not so new) features of Office 2007?  Bring back Clippy?  No, but what about a sidebar gadget?

    Constructive Media, a Canadian web solutions provider, has created an Office Tip of the Day gadget for your Vista sidebar.  Add the gadget to your sidebar and off you go with tips ready for you to absorb and start using the entire set of Office tools to the maximum!

    Now if I could just find the person responsible for killing off Search Puppy and get them to resurrect him (or her?)

This Blog

Syndication

Powered by Community Server, by Telligent Systems