How to enable Office Web App in your Sharepoint 2010 sites (Beta 2)

Posted by on Comments (1)

Once you've installed Office Web App on your Sharepoint 2010 Beta 2 (on a single server farm in my case), you may encounter the message "an error has occurred" when you try to open an office document in Office Web App.

Don't forget to activate the Office Web App feature on your site collections if you want to avoid that :

  • Go into the "Site Actions" of your site collection

  • In the "Site Collection Administration", select the "Site collection features"

  • Activate the "Office Web Apps" Feature :

And have fun with this very nice feature!

Posted in: Sharepoint 2010   Tags:

Resolved issues when connecting Excel 2007 to a remote cube on a SSAS 2008 outside your domain

Posted by on Comments (0)

 

A few days ago, we had issues to connect to an Analysis Services 2008 cube from Excel 2007.

Imagine that you are in a Windows domain or workgroup and that you must connect to an Analysis Services on a remote server/server farm with its own workgroup or domain.

In our case, we are building something like software as a service (SAAS) platform for a client where the concerned cube is just one small part of all the services & software we've to build. To access the cube, we are currently using a VPN connection.

The first thing is that Analysis Services is relying on a Windows authentication to work, this is the only option we have:

http://msdn.microsoft.com/en-us/library/ms143708.aspx

It's not possible for us to create a trust between the remote environment and the consumer one. And one or two other data consumers may connect from other environments.

 

When trying to access the cube with XL 2007, we can thus forget the "Use Windows Authentication" as the user we are logged on with is not known by the remote environment.

But we can choose to enter the user name and password of a windows user on the remote platform:

For the user name, we tried the forms "User", "RemoteDomain\User", "User@RemoteDomain" when working with a domain, "RemoteServer\User", "User@RemoteServer", or with the IP replacing the remote server name when working in a workgroup.

The problem was always the same, XL shows this window :

Then, after choosing a cube or perspective, it takes very long time before showing the message "Initialization of the data source failed" :

No choice, you click the ok button and then a new dialog window (Multidimensional Connection 9.0) appears:

And only then you are ready to work.

This is of course really annoying.

So, after unsuccessfully playing with and without domain users, what did we do?

  1. We saved the connected workbook to reopen it later. We still had the very long waiting time and the "Initialization of the data source failed".
  2. We saved the XL connection to reuse it. We still had the very long waiting time and the "Initialization of the data source failed".
  3. We configure the HTTP Access to SSAS (http://msdn.microsoft.com/en-us/library/cc917711.aspx). This time, we didn't have to wait a long time to receive the "Initialization of the data source failed".
  4. To avoid the multiple windows and warning messages, we added the user and password to the Windows Vault of the Credential Manager of Windows 7 : http://windows.microsoft.com/en-us/windows7/What-is-Credential-Manager

About the Credential Manager, it's easy to find it in Windows 7 and Vista. In Windows XP, you can type the command: control userpasswords2

With the credentials managed by the credential manager, the user only has to type the URL of the SSAS and check the Windows authentication option.

Perhaps there are other ways to deal with these issues but we're happy to find this quick setup answer to deal with these.

Posted in: Excel 2007 | SSAS 2008   Tags:

Meet Silverlight in Sharepoint 2010 (public beta)

Posted by on Comments (1)

Good news for RIA lovers : Silverlight is now really present in Sharepoint 2010!

Here is the message you may read if you go to the menu "More Options" of the Site Actions menu if you don't have Silverlight installed.

That doesn't mean that you can't do anything but here is how the options dialog looks like :

If you install the Silverlight plug-in, here is the new look of this dialog :

It's hard to show with a snapshot but this new presentation is really nice, with small animations and fluent navigation.

More than that, Microsoft added a new Silverlight Web Part. It has never been so easy to run a Silverlight application inside Sharepoint.

To use this Web Part, simply edit a Web Part page and add a new Web Part.

In the categories, choose Media and Content and then the Silverlight Web Part :

A new dialog will then appear asking for the silverlight XAP URL :

Enter the URL of a XAP (hosted in a document library, in the 14\TEMPLATE\LAYOUTS folder or anywhere else). In my case, I'll reuse a Silverlight XAP hosted in the IIS hosting my blog.

Here is the result :

Of course, you can modify the URL, appearance, layout and other stuffs in the editor part.

If time permits, I'll write another post about the new Client Object Model an how to use it in a Silverlight application.

First look at the document library of Sharepoint Server 2010 (public beta)

Posted by on Comments (1)

During my holidays, I installed the Sharepoint Server 2010 public beta.

It's quite heavy to run it in a VM. I finally installed it using VirtualBox on a W7 64 bits computer with 4 GB RAM. It's far from the ideal speed but it's usable.

I won't go through the Central Administration here. I just created a Web Application, a site collection and a site. This is more comfortable with the new Central Administration:

I then created a Team Site in this site collection. All of that is quite similar to what we do in WSS 3.0./Sharepoint 2007.

When your site is created, and if you've the right permissions to do it, the easier way to create a document library is to use the site actions menu:


In this list of actions, you'll find the action "New Document Library.

If you click on it, you'll not be lost if you already know Sharepoint 2007/WSS 3.0.

Once a document library is created, we can meet the new ribbon of Sharepoint 2010. This ribbon is, of course, contextual.

For a document library, we can observe 2 linked tabs : a Documents tab and a Library tab.

The Documents tab is used for all the features linked to documents : check out, check in, versions, permissions, workflows, …

The Library tab is used for all the features linked to the library itself : views, settings, connections, exports, permissions, …

As for WSS 3.0/Sharepoint 2007, a contextual menu is available on a file saved in a document library:

Posted in: Sharepoint 2010   Tags:

Silverlight coverflow of Sharepoint contacts : part II

Posted by on Comments (1)

Here is the second part for my Silverlight Sharepoint contacts coverflow!

In the first part, I created the Silverlight coverflow without any link to Sharepoint.

In this second part, I'll customize my Sharepoint to allow this link.

 

Here is my updated TOC :

In my previous post :

  1. Implement the Silverlight coverflow

In this post post :

  1. Customize a sharepoint contacts library

In a next post :

3.    Implement the Sharepoint contacts extraction

4.    Deploy the XAP in Sharepoint

5.    Add the Silverlight application to a Sharepoint page

 

Customize a sharepoint contacts library

 

To customize a contacts library, I need, of course, a contact list and a pictures library for the pictures of contacts.

Here is my contact library :

And here is my pictures library :


Now, I must create a column in my contacts list to add a picture to each contact item :


For each contact, I can then add a picture link to the picture library :


And finally, here is the result :

That's all for this time! I guess those steps were easily made if you've already played with Sharepoint!

See you later!

Posted in: MOSS 2007 | Silverlight 3.0   Tags: