May 2009 - Posts
Body:
You've probably heard about BDC feature in MOSS 2007 Enterprise Edition, but you have never tried it in practice. There is good walkthrough that describes everything you need to setup the BDC example.
http://dotnetdreamer.com/2008/09/26/business-data-catalog-in-moss-2007/
I have only couple things to add:
- If you don't manage to connect to BDC data in site collection, but you are able to connect to data via BDC template page, go to Permissions in BDC application and click "Copy Permissions to descendants"
- If you have configured Sharepoint via NTLM instead Kerberos, you need to modify Application Definition File in section
<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">
PassThrough
</Property>
Instead of "PassThrough" you should use "RevertToSelf"
Category: Sharepoint
Published: 29.5.2009 22:18
Category: Sharepoint
Published: 25.5.2009 18:21
Body:
This article is sequel to Install & upgrade localized SharePoint farm to SP2 - part 1 article in which we prepared installation resources to most recent SP.
Application role
After you have prepared slipstreamed contents, we can proceed with installation. On application server start MOSS-2007-x64-with-SP2 installation and when it comes to configuration wizard choose:
- New farm,
- Connect it to SQL server with proper account or simply use domain admin account (not recommended),
- Wait for configuration to end,
- Start installation from folder WSS-30-x64-LP-with-SP2 and run configuration wizard after installation finishes,
- Start installation from folder MOSS-2007-x64-with-SP2 and run configuration wizard after installation finishes.
This concludes installation steps necessary for application role server and brings us to configuration. You need to start services and configure SharedService provider on this server before adding any new server to farm. So from central administration start following:
- Document Conversions Load Balancer Service,
- Document Conversions Launcher Service,
- Windows SharePoint Services Search,
- Office SharePoint Server Search,
- Excel Calculation Services.
And after that in Shared Services Administration create new SSP. General recommendation is to create two web applications inside SSP one for SSP site and other for Mysite.
Web Front-End role
On front end server start MOSS-2007-x64-with-SP2 installation and when it comes to configuration wizard choose
- Yes, I want to connect to an existing server farm,
- Specify SQL server name and click Retrieve Database Names,
- Provide same account you used while configuring Application role,
- Wait for configuration to end,
- Start installation from folder WSS-30-x64-LP-with-SP2 and run configuration wizard after installation finishes,
- Start installation from folder MOSS-2007-x64-with-SP2 and run configuration wizard after installation finishes.
That's all. Go to Central administration and verify Servers in farm with their version.
Category: Sharepoint
Published: 16.5.2009 9:21
Body: Yesterday, I went in a SharePoint rampage in a Lab environment with localized SP2 environment. After couple of hours I've managed to install the all required SP2's on two servers.
Scenario
- One DC and two member servers, all of them Windows 2008 x64
- One member server has SQL 2008 x64, and he is now MOSS 2007 Application role server
- Other member server will be MOSS 2007 Web Front-End role server
Preparation
- Download MOSS 2007 x64 with SP1 (currently there is no Slipstreamed SP2)
- Download SP2 for MOSS 2007 x64
- Download SP2 for WSS 3.0 x64 EN
- Download localized WSS 3.0 x64 language pack
- Download SP2 for localized WSS 3.0 x64
- Download localized Office Server 2007 language pack
- Download SP2 for localized Office Server 2007
Nice isn't it
Slipstreaming
Create three folders
- 1. Folder - MOSS-2007-x64-with-SP2
- 2. Folder - WSS-30-x64-LP-with-SP2
- 3. Folder - MOSS-2007-x64-with-SP2
- Copy installation files from MOSS 2007 x64 with SP1 to first folder, and delete all SP1 files in Update folder
- Extract SP2 for MOSS 2007 x64 files to the same Update folder using extract command (SP2_filename /extract:<path>)
- Extract localized WSS 3.0 x64 language pack to second folder,
- Extract SP2 for localized WSS 3.0 x64 to Update folder in the same folder,
- Extract localized Office Server 2007 language pack to third folder,
- Extract SP2 for localized Office Server 2007 to Update folder in the same folder,
- And of course, don't forget SP2 for WSS 3.0 x64 EN
Next article will address MOSS installation and upgrade procedure for two servers.
Category: Sharepoint
Published: 10.5.2009 22:45
Body: Recently I've been asked to provide answer is there a solution that is able to store specific email messages or email conversations to Sharepoint. I've started some digging around and found that there is Out of the Box ability of Sharepoint and Outlook 2007 that provides solution.
Probably, you know about Sharepoint lists ability to connect them to Outlook.
- When you open almost any type of library, click Actions and then Connect to Outlook
After that you will be able to have online/offline content in your Outlook. If you connect Sharepoint Calendar or Contacts to Outlook 2007 you WILL BE ABLE to add Calendar and Contact in Outlook and they will be synched to Sharepoint.
But, what about emails? There is specific type of library called Discussion List that is being able to provide same ability to email as Calendar and Contacts to their Item types. Process is pretty straight forward.
- On Sharepoint create new Discussion list called "Business correspondences"
- Connect it to Outlook (Action > Connect to Outlook)
- In Outlook drag and drop specific emails into Sharepoint library, or create rule for important contacts that copies/moves messages to Sharepoint list
Email fields like Sender, Subject and attachment will be automatically parsed and you will be able to track them in Sharepoint. One of good things is ability of discussion list that it can recognize replies to subject and store them hierarchically with removing the prefix "RE: ". This gives you the option to create specific views against list, that groups items by unique subject.
Category: Sharepoint
Published: 2.5.2009 9:42