A public update for the Service Pack 2 expiration date issue is now available

Over on the SharePoint Team blog they have published details of an update that resolves the product expiration issue with SP2. A quick quote from their blog:

The update can be applied before or after Service Pack 2 installation.  If the update is applied prior to installing Service Pack 2 it will prevent the expiration date from being improperly activated during installation of Service Pack 2, if it is applied after Service Pack 2 it will remove the expiration date incorrectly set during installation of Service Pack 2.

Also they plan on releasing an updated SP2 package that doesn't exhibit this problem, time to update my slipstreamed install sources...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SharePoint service Pack 2 bug

SharePoint SP2 will expire 180 after implementation of the service pack.

Taken from the SharePoint team blog ....

"During the installation of SP2, a product expiration date is improperly activated. This means SharePoint will expire as though it was a trial installation 180 days after SP2 is deployed. The activation of the expiration date will not affect the normal function of SharePoint up until the expiration date passes. Furthermore, product expiration 180 days after SP2 installation will not affect customer’s data, configuration or application code but will render SharePoint inaccessible for end-users"

A KB article has been released on this and a fix is being worked on quickly!

We all make mistakes ... Embarassed

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Add the BIN folder to the path environment variable with powershell

I often go to execute a stsadm command and find it is not in the path on the server I am working on, so I looked for a while of a way of adding it permanently through powershell and then realised it's a straightforward task with .NET code. The following will add the BIN folder within the program files structure to the PATH environment variable at local machine level so that all users will benefit.

   1:  $envpath = [environment]::GetEnvironmentVariable("Path","Machine")
   2:  $binpath = $env:Programfiles + "\Common Files\Microsoft Shared\web server extensions\12\BIN"
   3:  if ($envpath.contains($binpath) -ne $true ) {
   4:  $envpath = $envpath + ";" + $binpath
   5:  [environment]::SetEnvironmentVariable("Path",$envpath,"Machine")
   6:  Write-output "BIN Path added."
   7:  }
   8:  else
   9:  {
  10:  Write-output "BIN Path already added."
  11:  }

I have added a check to not add it if it is already present as the traditional method of using

SET PATH=%PATH%;C:\Program files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN

ends up with multiple copies of the BIN path in the variable and only applies for the current session.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SharePoint SP2

Announced, and sure to be a popular download.

Firstly, there is a ton of information released on this service pack and the SharePoint team have done well to list it.

the packs...

WSS Specific Download Locations
•  Windows SharePoint Services 3.0 Service Pack 2 (x86)
http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B 
•  Windows SharePoint Services 3.0 Service Pack 2 (x64)
http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B Windows SharePoint Services 3.0 Language Pack Service Pack 2 (x86)
•  http://www.microsoft.com/downloads/details.aspx?FamilyId=085E5AC8-58F6-4CF9-8012-33B95EE36C0F
•  Windows SharePoint Services 3.0 Language Pack Service Pack 2 (x64)
http://www.microsoft.com/downloads/details.aspx?FamilyId=2C2B6CAF-B46D-45EB-AC4D-DEAAA48C3A2C
MOSS Specific download locations are here:
2007 Microsoft Office servers Service Pack 2 (x86)
•  http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082
•  2007 Microsoft Office servers Service Pack 2 (x64)
http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082
•  2007 Microsoft Office servers Language Pack Service Pack 2 (x86)
http://www.microsoft.com/downloads/details.aspx?FamilyId=01C6A3E8-E110-4956-903A-AD16284BF223 
•  2007 Microsoft Office servers Language Pack Service Pack 2 (x64)
http://www.microsoft.com/downloads/details.aspx?FamilyId=66C5026F-9F47-4642-8378-2526918009FA

Part of the pack is a tool to check for upgrade issues ready for SharePoint 2010.

For a slightly more in depth post, read Joel's Post on the Service Packs

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Multihomed IIS Servers

 

I was setting up a staging server this week to demo some our projects and products to clients, and ran into a situation where the external address seemed to stop responding. Initially I thought it was a firewall issue, but that all checked out ok and locally the server would supply pages to the url I was testing but not remotely. I wondered if I had misconfigured the networking somehow and searched for some articles on IIS & multihomed scenarios, I have one NIC set facing the internet and another facing  the local subnet. Anyhow turned out I had set the default gateway on the external NIC and the internal NIC was given it's IP via DHCP and so also gets a default gateway. D'Oh!... I found the following article gave not only a good explanation but also instructions on how to resolve it.

 http://www.shudnow.net/2009/02/01/default-gateways-and-multihomed-boxes/

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SP2 for WSS 3.0 and Moss 2007

 

Details are up on the Microsoft Update Product Team blog about SP2 for the Microsoft Office System which includes WSS and MOSS. You'll have to scroll past the desktop appllications info to get to the server info though. More info expected both on this and the Office Sustained Engineering blog. No doubt the SharePoint Team blog will have something too Smile.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Forms Server Caching

A client raised an interesting problem recently. InfoPath forms rendered using Forms Server were being cached in the browser (or rather IE)

On the development and test environments, the forms worked fine, but on pre-production, the caching started.
The caching represented itself by showing the dreaded 'The form has been closed' error when a user tried to open a form for a second time. verbose logging on the server showed that Forms Server itself was not appearing to do anything untoward.

The workaround at the moment is to open FormServer.aspx on in the LAYOUTS directory and add

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

into the head (stopping the browser from caching the page and form. (Important note - this is a shipped file and on production servers should not be modified.)

 

It is feasible to copy FormServer.aspx to somehting like ncFormServer.aspx and call your new url when opening a form, but I haven't yet tried this e.g. /_layouts/ncFormServer.aspx?XsnLocation=........&Source=....&OpenIn=Browser

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SharePoint Best Practices Conference UK - Day 3

The final day of the conference - today I focussed on the IT PRO track – all 5 sessions. So that’s Steve Smith, Spencer Harbar, Daniel Wessels, Spencer again, Bob Fox and Brian Wilson, covering Intranets, Extranets, internet sites, search, Kerberos and Virtualising SharePoint.

Steve Smith started the day with a redefinition of WWW, as the wild wild west. It’s an open world out there and as soon as you attach your servers to the internet they’re insecure, you really don’t know who will be accessing your content or trying to do things they shouldn’t.  You have layers of security at the edge, (that may be ISA), IIS and then again at the SharePoint level, with your content  in the database and that’s what you’re delivering or protecting. I suppose it’s obvious really, but the more complex you make things in these layers, the less likely they are to be secure because of mistakes. 

They continued with best practices for your Web applications and SSL scenarios – where Spencer Harbar put in the one liner – “host headers are evil” – but it transpires  that this is only in the context of SSL, where life really is a lot easier if you use fixed IPs and stick to standard port numbers.

Daniel Wessels took us through Search Infrastructure, Architecture, Setup and Management. It seems there are varying rules of thumb for the size of your search DB, depending on which whitepaper or documentation you read, going from 2x to 6x the size of your index, but you won’t really know what that figure will be for you until you run some tests on the mix of data your farm is indexing. Looking at the servers in the farm, the maximum ratios for Query, index and DB server are 7:1:1, above that the performance actually tails off... time for an extra index server and thus another SSP to scale the capacity and performance.

For your default search content access account this really should not be a farm administrator, in this scenario both minor versions and unpublished documents will be indexed and potentially visible to end users. So although if they have not got permissions to see these versions of the documents they won’t be able to see them when clicking on the search result link, they will see the words around the keyword matched in the search results page. Another interesting point was around the content access account used for external websites, here you need to be using an account that has no permissions on your network, because if challenged the indexer will give up the account’s username and password to the external site and you really don’t want that being used to access your network do you?

During the lunch session Andrew Woodward and Alex Pearce gave us a view on some of what is happening in the education space in the UK with SharePoint and showed us a great looking interface for a VLE built with Silverlight sitting on top of the SharePoint Learning Kit for a UK Learning Gateway.

After lunch, Spencer Harbar and Bob Fox took us through setting up Shared Services and Excel Calculation Services to use Kerberos and it went well, apart from the demo on shared services causing some problems, but hey nothing like a live demo to go wrong... but there was good discussion and questions while Spence battled with IIS & SP to get it to work.

Some key pointers from the session – case matters when you are setting your SPNs, and all the SSPs in your farm must be either all NTM or all Kerberos, you can’t mix them.

Brian Wilson finished off the speaker sessions for the day covering virtualisation of SharePoint in a production farm. He addressed the issues of resource usage and how you need to look at this from both a physical and virtual perspective. A key point is that restoring snapshots of a server in the farm is not supported – you are likely to get all sorts of mess and probably database corruption as timer jobs are likely to go out of sync.

The conference was finished off with open mike sessions in all the tracks, it’s great to have the opportunity to ask the experts those questions you find really hard to get answers to. In the IT Pro track we had discussion around admin accounts, should you use a shared account among a team or assign the permissions to users  directly? Generally using a shared account is likely to end up being less secure as those details get shared around, and you would be better assigning the farm admin permissions to the users’ own accounts. This also gives you an audit trail as to who has made the changes. Large databases came up again and some of the issues around that, sometimes you have to remind people to ask the question whether data should really be in SharePoint in the first place.

A good question was how should you structure a support team? Well it depends... :) but a minimum would be one and a half people dedicated to it, so that when that one person is on holiday the half can still pick things up and know how to fix things if problems arise!

And so from SharePoint by day to SharePint by night, the guys at Syntergy gave us a pot for the beer, thanks guys! It was a good chance to chat to some more people and enjoy a beer or two or three... sadly I needed to be on the train home this evening so had to leave early.

And finally, thanks to Steve and co at Combined Knowledge, you have done a great job of this conference and we look forward to the next one...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SharePoint Best Practices Conference UK - Day 2

The conference continues to inform and inspire...  Today I started off with Eric Shupps’ session on Custom Site Definitions, very entertaining but also very informative, he took us through packaging up our site definitions, the pros and cons of SPD and even some places where it is good – rapid prototyping of a master page before building it for real into a solution, so often internally we tend to only use it for DVWPs.

Next up was Maurice Prather with Secure Coding for The Administrator, it’s amazing the ongoing banter between dev’s and admins . We took a look at Secure Code, what does it mean?

·         The practice of writing code that can withstand malicious attacks

·         Secure code is Robust Code

Maurice expanded on this and then took us through the extra protection that SharePoint puts in place for us, stopping code from doing what it shouldn’t, but also the cases where Full trust can creep in and prevent these safeguards from working. Watch out for changes to PageParserPaths settings in your web.config files.

Neil Hodgkinson on Patching SharePoint – I thought I would know most of the content of this session, how wrong could I be? Neil gave us a really thorough tour of Hotfixes, Cumulative Updates and Service Packs. I hadn’t realised that the Revision number in a build number, e.g. the 1000 part of 12.0.6219.1000, had any meaning beyond just an arbitrary number, but it does:

1000 – Service Pack

30xx – Private build – you really should not be running these in production

5000 – Hotfix or CU

500x – COD Build

He also clarified the differences between Microsoft’s minimum supported build, recommended build and the latest and greatest build and how these affect the type of response you will get from PSS.

Building High Performance Solutions on Moss 2007 or should that be how do I cut down the bandwidth that Moss eats when we use it for Internet facing websites? Andrew Connell gave us some good solutions touching on your site topology for location of secured items, “customised” pages came up once again, reducing the page payload, how to speed up the CQWP and instant improvements with the art of IIS HTTP compression. A  slip on who should be in the kitchen, whilst explaining that you should just crank up the compression level to start with, will his wife hear about it though, did it make it to twitter?

The final session I sat in on was the IW Open mike session, and heard my favourite quote for the day, in answer to a question about the size of content DBs Rob Foster said “if you let content DBs grow bigger than 100GB then you run out of hours in the day to do the daily backups” to which the reply came “That’ll be a limitation of the solar system then!”.

I can’t believe it’s the final day tomorrow, it’s gone very quick and no sign of flagging. Just need to choose where to eat tonight...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SharePoint Best Practices Conference UK - Round up of My Day 1

Well, a fantastic first day at the conference. Steve Smith and the team at Combined Knowledge have done a sterling job of organising the event. A great line up of speakers and a plentiful supply of refreshments and delicious pastries to keep us awake during the day.  There’s 20 or more sessions each day, I can’t yet clone myself so here’s a taste of the sessions I attended.

Keynote

Joel Oleson kicked the speaking  off with a great Keynote giving us 10 steps to a successful deployment. He started out with the Killer bunnies from Monty Python, a very apt analogy for SharePoint. So many people rush in and deploy it without fully assessing the size of the task and planning it out. This led nicely into the first step being “overcome the denial to confront Reality”, and finishing with the one we are oft prone to forget “Keep it simple stupid”.  Spencer Harbar kindly demonstrated how to suggest to the speaker that he has overrun by putting his stuff in place on the platform as Joel was still speaking.

There’s 4 tracks to choose from throughout the day, IT Pro, Developer, Information Worker and Business Adoption.  Not deliberately, but just from choice of what was most interesting to me I managed to attend a session from each track today.

Collaboration vs. Publishing Sites. – IW Track

Interesting stuff from Mark Eichenberger on using Collaboration, Publishing or his suggestion of Hybrid Sites.  He highlighted a number of differences between collaboration and publishing at page, site and site collection levels, and then ably demonstrated an alternative approach that gives us quick launch navigation on the web part pages and removes the web part page icon without tweaking the files in the 12 hive. Very nice solution.

A Case study in Governance, Business Adoption Track - Natalya Voskresenskaya. ( I hope that’s spelt right!)

Natalya took us through her Best Practice for Governance –

·         Start with Thorough Discovery

·         Implement a Governance Plan

·         Define your growth strategy

She took us through the case study and gave us a really good understanding of Governance Plans and how to go about them. She took us clearly through all the parts she felt necessary to a governance plan, and the fact that it needs to be a living document  not just 40 pages that sit there and no on e reads. My favourite quote from the session was “Do not engage with a company until it is ready forSharePoint”.

How can I kill my file servers? IT Pro Track, Joel Oleson

I thought the title for this session sounded great. Joel shared some great examples for approaches to moving data from file servers, not just to SharePoint but also to nearline or off-line storage. Is all that data on your file servers really necessary to be instantly available? Ask yourself how knows the data best? IT or the Business Users? And so therefore who is best placed to move the data?

Test Driven SharePoint Development, Dev Track, Andrew Woodward

Whilst I had come across this I still hadn’t really grasped how it would work in practice, and this is exactly what Andy showed us, not only TDD but how we can achieve this with SharePoint using Typemock Isolator to “fake” SharePoint. Few slides and lots of code, just the way I like a dev session to be.

Andy had been concerned that we wouldn’t be able to see the screen from the back of the room, but it was fine, nice and clear, I think a nice touch was that the mike picked up the keyboard tapping...

Anyhow great stuff, the fog has cleared and I now understand better what he’s been talking about, or should that be evangelising?

Vendor night

Roulette and Blackjack, with free chips... great fun, loads of vendor prizes in the draw, but sadly my name was not called out.

More tomorrow...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

 

Dilbert of the day