Archive for Tony Maddin

Microsoft releases SharePoint 2013 patches

SharePoint 2013 Logo

 

Microsoft has now released the first round of patches for SharePoint 2013 Foundation and Server.  Click here for the IT Pro Updates area.

Starting with March of 2013.

Office365 Password Character

Office365

While I was helping out a co-worker; we could not get Lync to properly work on the desktop.  So during the course of troubleshooting; we reset the password for the Office365 account.

After the password reset, with a different symbol, the Lync client was now happy.

While looking at the original password; it had a \ in the password.

It appears you can change your password in Office365 with a \ symbol.  But the Lync client will not log in with a \ symbol in the password string.

Summary:  It appears you cannot have the \ symbol in your password if you plan on using Lync with Office365.

 

 

Forms Based Authentication SharePoint 2013 Foundation can be done

SharePoint 2013 LogoAfter further investigation, it was found on TechNet’s website for SharePoint 2013 (as of March 8, 2013) that forms based authentication can be done in SharePoint 2013.

http://technet.microsoft.com/en-us/library/ee806890.aspx

However, I did find Forms Based Applications is not supported within SharePoint 2013.

http://technet.microsoft.com/en-us/library/jj819267.aspx#bkmk_FeaturesOnPremise

I misread the feature list as Forms Based Authentication.

Special thank you to Mike Smith, MCT/SharePoint MVP, for his further research.

Please adhere to Microsoft’s license agreement with regard proper server license that supports your SharePoint 2013 Foundation platform.

Trello – Fantastic, free web-based project management tool

 

Trello-Free-Organization-Tool-Easy-to-Use

A former colleague, Jason Coffey (click here to view his LinkedIn profile), showed me a great, free project management tool set called Trello.  Trello has a fresh approach to organizing tasks in a visual manner so you can quickly put your arms around a project.

The company has stated the tool set will always be free. So I have assurance that I can use it without the fear that I may get the hammer of going pay for use route with other great products I have used in the past.

They have a great demo/tutorial that I highly encourage you to look at to understand this new concept. But once you start building your project plan; you will understand why this tool set is popular.  It’s easy.  You can visually see and understand the stages of tasks in the entire project.  I love it!

www.trello.com – It’s now listed under my RESOURCES section.

FIX for Hyper-V Windows 8 Error “Failed while adding virtual Ethernet switch connections”

Hyper-v_logoAs I am building my Windows 8 – Hyper V environment to support my various SharePoint servers, I ran into an issue while creating an External switch in my Hyper-V Switch Manager.  I ran into an issue while creating an External Switch and attaching it to my WiFi adapter on my laptop.

**Please note: I take no responsiblity for your computer/laptop if it breaks. I did this scenario on my work laptop to support my project work. Please follow my steps with caution.

Failed while adding virtual Ethernet switch connections.

So here was my work around:

  • Go to Control Panel
  • Go to Hardware and Sound
  • Go to Device Manager (Under Devices and Printers Tab) – Run as Administrator
  • Go to Network Adapters – Look for your WiFi adapter/device.
  • Next, right click on it and click uninstall. (Keep the driver.)
  • Next, right click on Network Adapters – Click SCAN FOR CHANGES

(Your WiFi adapter should reappear.)
Reboot your machine.

Next, when I rebooted my laptop; I had to resupply the WiFi password for my connection. I got back on the network.

Then when I create the External Network Switch; I did not receive an error.

If you want to follow a great guide on how to build a SharePoint Farm on Windows 8, please go to my good friend’s blog, SharePoint Ryan!

http://sharepointryan.com/2013/01/23/creating-an-awesome-development-environment-on-windows-8/

My current activity in the HeartLand Information Technology Community

What a great year!  I have been very active in the region getting to watch/learn from fellow professionals in my industry.  I seen various topics such as systems administration, development, database administration, networking engineering, and proven project management.

I have gotten to meet first hand with a lot of people that I have read about on the Internet or read their published books.  The social aspect of the these types of events are what I cherish the most.

Below is my list of past presentation schedules:

[box type=”info”]Presenter: November 3, 2011 – Cincy SPUG, Cincinnati, Ohio – Topic: SPDiag 3.0 toolset and all the possible uses with it.

Presenter: October 29, 2011 – SharePoint Saturday, Cincinnati, Ohio – Topic: How to Landscape, Baseline, and Performance Tune a SharePoint 2010 environment.

Presenter: October 6, 2011 – DANPA, , Dayton, Ohio – Topic: SharePoint 2010 Overview – How small business can leverage the SharePoint 2010 platform to meet small business needs.

Presenter: August 20, 2011 – SharePoint Saturday, Columbus, Ohio – Topic: SharePoint Diagnostic Studio 3.0 in action.

Presenter, January 11, 2011 – Dayton SharePoint User Group – Topic: Using PowerShell to create a SharePoint environment.

Presenter, June 3, 2010 Cincinnati SharePoint User Group. Topic: SharePoint 2007 Disaster Recovery Proven Tests[/box]

I cannot wait for the 2012 year to meet new IT professionals in the community and continue hanging out with the ones I have now established with in these groups.

Cincy SPUG Presentation – November 3, 2011

SP 2010 admin tool to add to your toolbox

While working on a client project, I was refreshing SharePoint 2010 environments to support our various QA and Development teams.

I implemented the SharePoint 2010 content hub for this project.  While detaching/attaching content databases to the staging environment; the Metadata Term Store data did not transfer.

This term set was a key feature in our project.

I searched the internet and came across this tool on CodePlex.  This tool was easy to use and fixed my issue.

I was able to export the term set from the source SharePoint 2010 farm.  Then transfer the CSV file to the destination.  Installed the tool again and the term set uploaded with no issues.

[box type=”info”]This is a must have tool to add to your Admin toolbox.

The tool is called the termsetimorter.exe but it also exports the term set as well.

 http://termsetimporter.codeplex.com/ [/box]

My Presentation – SharePoint Saturday Columbus, Ohio – August 20, 2011

SharePoint 2010 Service Pack 1 Finally Released!

Finally, finally, and finally!  SharePoint 2010 SP1 has now been officially released to the public.  Why does this excite me?  You know the length and process of getting SharePoint systems up-t0-speed with patches?  Believe me; they take time.   The good news is that all the cumulative updates are now including so now I can clear off 2.5 gigabytes of drive space to keep the other patches around. 

But please review these white papers located in the list below.   There is a required SQL Server patch associated to the Service Pack.

http://www.microsoft.com/download/en/details.aspx?id=26573

Office365 Launched Today

It’s official.  Microsoft launched Office 365 today.  In my humble opinion, its going to change the IT game with regard to fundamental change in infrastructure support.

Click here to visit the official website.

 

SharePoint 2010 In Plain English Video

Another must have SharePoint admin tool – ULS Viewer

As many of you are aware, reviewing log files are a necessary practice in our information technology industry.  But your standard NotePad on a Windows Server just cannot keep up when it comes to reviewing log files.

This tool has been around since 2009.   However, I when diagnosing a SharePoint 2010 farm, it was the tool of choice to help find the problem.  Here is the link.

Must have command for your system admin toolbox – GPRESULT

I was in need of getting detailed network information in a development/DMZ environment with heightened security.   In particular, Domain Controller information.   I did a lot of NSLOOKUP’s and PING’s to the gateway and dns servers to see what name(s) returned.  I got zero results.  (Very tight security.  🙂 )

 

 

[box type=”info”]My buddy pointed me to the command GPRESULT.exe. It’s a built-in executable for Windows operating systems.

I was able to get a detailed report of the NIC card and the network settings.  A great tool to use![/box]

[box type=”info”]Click here for the Technet article on how to use it. [/box]

[box type=”bio”]Another special thanks to John Chism on his advice.[/box]

Tip: How to speed up a slow Virtual Server

If you have virtual servers (VMWare, Hyper-V, Virtual Box, etc.) running Windows operating system that does not have Internet connectivity; you will see the operating system services run slow. An example is opening up PowerShell command prompt. This could take up to 30 seconds at times. Open Internet Explorer. Then open an internal website. This could take some time.

Want to know why?

[box type=”info”]Here is the answer:

It’s a known issue with Windows. It’s trying to check certificates to see if they have been revoked. However, it slows down the operations within the operating system until the check times out. [/box]

To avoid this issue, you can fix the issue a couple of ways. Manual or script it with PowerShell.
[box]

Internet Explorer:

Go to Tools => Internet Options =>Advanced tab =>  Under Security: uncheck  “Check for Server Certificate Revocation(requires restart)[/box]

PowerShell Script:

[box]Set-ItemProperty -Path HKCU\software\microsoft\windows\currentversion\internet settings\ -Name “CertificateRevocation” -Value =”0″[/box]

[box type=”bio”]A special thank you to John Chism and his team for coming up with this solution.[/box]

Poll – How do you prefer to read books in the 2011 year and beyond?

Overcome Test-SPContentDatabase “Database too old error message”

Ok, I was thinking that I could quickly take a SharePoint 2007 content database, apply the minimum Service Pack 2 for WSS 3.0 and MOSS 2007, and then perform a database attachment within SharePoint 2010 in minutes while basking in the glory of the easy process.   I should have known this is SharePoint and everything is earned in this world.  🙂

I rebooted all the web front end servers and application servers just to make sure my little SharePoint 2007 world had the right build number of 12.0.0.6421 within Central Admin.   So I did a backup of the database and then moved the BAK file to the SharePoint 2010 Database instance and performed a simple restore.  For extra incentive and I was the DBO in the environment, I placed the SP Farm Account DBO to make sure the attachment goes ok.

I ran the PowerShell commandlet Test-SPContentDatabase to verify the database.  Then I got the error.

[box type=”warning”]Category: DatabaseValidation Error: True UpgradeBlocking: False Message: This database [SSPBeta] is too old and cannot be upgraded. Remedy: Upgrade this database to Windows SharePoint Services Version 3, SP2 or later. [/box]

[box type=”info”]So after I read multiple blogs, forums, etc.; I wanted to think outside-of-the-box. I tried an idea. “Maybe the commandlet needed a build number newer than 12.0.0.6421?”

So I got the April/2009 Cumulative update for WSS 3.0 and MOSS 2007. So I applied these two CU’s to the SharePoint 2007 Environment.

I verified I was on build number 12.0.0.6504. [/box]

Just like washing your hair.  Rinse and Repeat. 

So I did a backup of the database and then moved the BAK file to the SharePoint 2010 Database instance and performed a simple restore.  For extra incentive and I was the DBO in the environment, I placed the SP Farm Account DBO to make sure the attachment goes ok.

I ran the PowerShell commandlet Test-SPContentDatabase to verify the database.

 [box type=”shadow”]Then Poof!!!   The Test-SPContentDatabase command liked this minor build update.[/box] 

 Resources for review:

I welcome any feedback.

Internet Explorer 9 Compatibility View

There are times where I need to view a website but the website is not ready for Internet Explorer 9.  But how can I change Internet Explorer 9 so that I can view it in compatibility mode?

Well in Internet Explorer 9, the location is buried.  So I am writing this blog post so I can reference it.  I am sure there are other fellow technologists out there that need the same information.  I hope this helps people out.

[box]1. Right Click on the sprocket on the top-right hand side.

2. Checkmark Command bar. (You should now see the command bar.)

3. Choose Tools ==> Then Compatibility View Settings.

4. Then Kapow! You are now view it in other IE settings. [/box]

SharePoint 2010 Attach Content Database – Alerts not working now FIXED

So I took a SharePoint 2007 SP2 compliant and tested content database and placed it into a SharePoint 2010 enviornment.  All the content was there.  The permissions were fine.  However, by database attachment went to a new SharePoint 2010 web application that had a different URL name.

Example:  intranet.company.com SP 2007 content database was attached to sp2010dev.company.com

This URL change throws off alerts.  You can delete the alerts and add them back in but that is just crazy to think about that scenario.  And guess what…..there is a PowerShell commandlet to fix this issue. But unfortately, this answer is buried on search engines.

Anyway, there is the PowerShell commandlet.

[box]Invoke-AlertFixup -site <NewURL> -oldurl <OldURL> [/box]

Here is the exact Technet article to reference.

Paint.net – A free, open source image and photo editing sofware

I recently recieved a new laptop.  And with any new computer you try to put as many tools on it as you can to do your job.  However, image/photo editing is one of those tools I usually forget about until I need to do something quick.  Then I go to Program Files and scan for PhotoShop….then I think, “Uh oh….I don’t have it.”    I have used Gimp but there is a major learning curve.  My co-worker Tavis Lovell mentioned, “Hey get Paint.net.  Its free and does a good job.”   I downloaded it; and within 10 minutes I accomplished my task of changing an image.  Paint.net is easy to use and similar to PhotoShop/Fireworks if you are familiar with these toolsets.    So feel free to go the website to try it out yourself.   http://www.getpaint.net/ 

I have also placed this tool under my Resources webpage on this blog.

Open Source eMail Server

 

I found on a discussion thread on a great, open source email server to install in a development enviornment.  This is nice to have so you do not have to become a Microsoft Exchange guru.

http://hmailserver.com/

 

DAYSPUG at SharePoint Cincy

DAYSPUG’s first booth and event.

Another great open source tool – Greenshot

Greenshot
Greenshot

Greenshot is a great alternative for SnagIt.  SnagIt is a great screen capture tool and I highly recommend it for a commercial enviornment.  But it’s one of those tools that is nice having it on a home system that you are doing sidework.  Greenshot is open source and has an executable that installs on any Windows platform.  Its a basic set of tools similar to SnagIt to perform screen capture operations; but if you are looking for pretty advance features stick to the commercial leader SnagIt.

I have listed this tool under the RESOURCES web page on my blog.

How to connect Access to SharePoint 2010 if the feature within a view and/or list is missing.

Anyway, when I went to list view; the button to “Open with Access” was greyed out. I went into my settings and tried to create a new view with Access. It wasn’t there either.

Steps below:

  • So I opened up Access 2010.
  • Then chose the OPEN feature.
  • What is cool is in the drop down area; there was a item called, “SharePoint Foundation Services.”
  • I copied and pasted the URL to the SharePoint calendar that I needed to update…….

And then *POOF!* *MAGIC!* I can then update data via Access.

Happy SharePoint-ing!

Tony

SharePoint 2007 Error Message and Fix

Exception from HRESULT: 0x80040E14 error appeared on my SharePoint 2007 environment this weekend.

There are a variety of blogs I have found that fixes this issue.  Each one stating the same thing.

[box type=”info”]1. Check the drive space for the SQL server logs for SharePoint. Clean out the space.

2. Check the drive space for the SQL server data files for SharePoint. Clean out the space.[/box]

This fixed my issue.  I just wanted to pass along to my SharePoint community.  🙂

A must have PowerShell statement inside your PowerShell Script for SharePoint 2010

The past few weeks, I have been writting a lot of PowerShell scripts so I can automate as many SharePoint administrative tasks that I can so I can enjoy other aspects of SharePoint during the business day.  🙂

I found a must have statement from the book, “PowerShell for Microsoft SharePoint 2010 Administrators“, book.

Here is the statement.  This statement is important if you have a scheduled task or a program that kicks off programs.

I have a template now to make sure I have this statement right underneath my opening comments area. 

[box type=”info”]Example: If (-not(Get-PSSnapin | Where-Object { $_.Name -eq “Microsoft.SharePoint.PowerShell”})) {Add-PSSnapin Microsoft.SharePoint.PowerShell;}[/box]

TeamViewer – A free remote access tool

Another great tool I found with PortableApps.com. 

TeamViewer (http://www.teamviewer.com/)   This tool is free with non-commerical use.  Like most IT professionals, you are one of the family chosen PC support specialist.  This tool will allow you to quickly connect to a end user’s computer without guiding them through the process of turning on RDP.  (If their version of Windows even have it.  Most copies do not.)

I will be adding this tool to my resource page.

Happy Holidays!   Tony Maddin

Extending your Windows 2008 Activiation in a virtual environment

I live and die with my virtual servers on my local computers to test proof-of-concepts; PowerShell scripts, backup/recovery scenarios, and many other important aspects to my job as a Web and SharePoint Administrator.

But one aggrevating thing is the Windows 2008 Activation feature that creeps up if you do not manage it.

I found a great TechNet article on how to extended the grace period in Virtual Environments.  This will work with VMWare Workstation, VirtualBox, Virtual Server, and Hyper-V.  In theory, it should work in other virtual enviornments.

Here is a link to the entire article. 

Prezi – A great presentation tool

At the December/2010 Cincinnati SharePoint User Group meeting, Sean P. McDonough was the presenter for the night.  Fantastic Topic:  SharePoint 2010 Backup/Recovery

Sean is a fantastic presenter.  I was even more impressed with the tool he used for the presentation called, “Prezi.”  www.prezi.com

The tool is free with limits. 

I had a big presentation at my current employment that I needed to walk my audience through a new process of moving SharePoint team sites from various SharePoint versions onto our new SharePoint 2010 environment.

The tool was a big hit and it inspired great conversations during and after the meeting. 

Big thanks to Sean!   You can visit Sean’s website at http://sharepointinterface.com/

Great Tool – 2xClient alternative to RDP

The 2X Client that is part of the PortalableApps.com collection is a fantastic tool that is an alternative to the standard Windows based Remote Desktop Program.

It appears to be faster, you get more display options, and no pesky mouse issues.  (I get these issues with my wireless laptop and RDP sessions.

Again, this is my personal experience working in an enterprise environment.  Please feel free to agree or disagree.  🙂