Wednesday, January 04, 2006

SharePoint in a Stand Alone Server Gives Error On Being offline

Problem Description:

Well, this is an old one, but I always forget about it when I encounter it. When you use a stand alone SharePoint server (for example in a virtual machine like Microsoft VPC or VMware) to develop or test something, not all of the features work. For example:

  • DataSheet view will not update rows in a list or document library and will show you an error stating it is offline. "Cannot connect to the server at this time. Changes to your data cannot be saved."
  • Office task pane that is supposed to show you "document updates" and "Shared workspace", is also telling you you are offline. "You are currently working offline. Check your network connection and then click get updates."


The reason for this behavior is that the office objects that connects office to sharepoint are checking the network status and they see that you don't have a network (since you are on a standalone server).


Well, one way would be to setup another machine and connect the two, or maybe set up a loopback adapter.

But the easy way to solve this is to just stop the network sensing mechanism and fooling office! Here is how you do it:

  1. Close all office applications and internet explorer windows.
  2. Click Start>Run
  3. write in the text box "net stop sens" and press enter.

that's it! Now the datasheet view will update items and office-sharepoint integration will work smoothly!


Deon Smit said...

You are my HERO
Thank you thank you thank you

Ishai Sagi said...

Heros dont need thanks, we do our jobs with or without them!
but its much nicer with than without

Anonymous said...

This fix worked for me as well; I was having problems exporting data files. I kept getting a message "cannot connect to the server at this time; changes to your data cannot be saved". We tried several things, but nothing worked. So thanks for a simple solution that worked!

Anonymous said...

Kudos to you son - people like you make the internet so valuable!

Anonymous said...

Awesome dude, just what I needed!

Anonymous said...

It has been said already but..
A simple but effective solution.
Many thanks.

David Toyne said...

Thanks Ishai. Got me out of a frustrating problem with this tip.