SharePoint etc.

This post is a follow up on the issues that I have got setting up External Content Type (ECT) on SharePoint 2010 Foundation that was going to connect to remote SQL Server database for information. I cannot use my SharePoint user accounts to access SQL Server. According to the information I have discovered ECT and Business Connectivity Services are available in the SharePoint 2010 Foundation, but there are some issues if you want to use authentication methods in your external connections that are different from Windows Identity or Current User Identity. This is because there is no Secure Store Service in SharePoint 2010 Foundation which serves as an impersonation hub and is only available in SharePoint 2010 Server edition. The issues are coming from the fact that you can actually create ECT in SharePoint Designer 2010 providing just Secure Store ID and system would ask you for credentials and here you go, but when you try to use your ECT in External Lists or as a lookup columns you w...

Have found an article about configuring a BDC model to connect to SQL Server database using SQL Authentication: BDC LobSystemInstance for SQL database with SQL Authentication

There are some issues when working with External Content Types in SharePoint 2010 Foundation - http://bit.ly/aWYlHn You cannot use ECT that was created using Secure Store ID, though the ECT will be created. :) Stay tuned.

Yesterday I got an invitation to start using Docs for Facebook in BETA. I was really excited and rushed to edit and upload documents into the system to try how that works. Ok, let's see what I have got. First of all I entered the system and hit Create a new Word Document menu command: Here it is: I quickly ran through the menu tabs: For me it was enough from the Web document editor and I started editing a document: I work on iMac and use Firefox as my main browser. When I tried to copy something using context menu the system told me this: That is not a big issue for me, because hot keys worked alright as I expected and didn't stop me from comfortable authoring. I inserted a couple of images: Played a little with fonts. By the way it's not a huge range of fonts that are available at the moment: Changed document title: And here you go: Freshly baked Word document online. :) Now I want to change security on this document. I want some of ...

Situation On a Publishing site user tries to create a page: But gets an Access Denied error: Solution The cause of this error is that user has permissions to the Web site, but doesn't have access to Master Page gallery. So we need to go to Master Page gallery settings: and give users access to this library. At least Read access. I, in my case simply inherited permissions from the parent: That helps. And of course some more books and movies for you:

Now we can manage Microsoft Office documents online with Docs for Facebook Docs are built using Microsoft Office 2010 and I think is a very interesting solution. I used Google Docs  for a while and I suppose Docs for Facebook will be a good alternative to Google Docs takeing to account that Microsoft's application will have full compatibility with MS Office document formats. :) Stay tuned.

Scenario There is a solution for SharePoint created in Visual Studio 2008 for SharePoint 2007. The task is to transfer this application to Visual Studio 2010 in order to deploy the same functionality on SharePoint 2010. Initial solution structure 1. List Event Handler 2. Feature that on activating: creates a sub-site, content types, lists and initial data, registers list event handler for the list and sets up permissions for the sub-site 3. Web Part 4. Application page which is deployed to _LAYOUTS folder and where the Web Part is displayed. Ok girls and boys, the process 1. Create a new project of type Empty SharePoint Project in Visual Studio 2010: 2. When the project is being created select a "Deploy as farm solution" option: 3. Empty project created! Now we will add List Event Handler: We choose Custom List as a list type and "An item is being updated" as an event type to handle: The full list of available event types is as follows: ...