Recently I had to make a SharePoint test farm at a customer site completely identical to the production farm. Therefore I backed up all production databases (including the Config and Admin databases) and restored them to the SQL server in the test environment.
Before I use the Configuration Wizard to disconnect the test servers from the farm and connect them to the new farm (the former production databases) I had to make a change in the restored Config database. This change is made to direct the Config database to the new (test) SQL server and therefore the new test farm.
This is the change:
- Open SQL Studio Manager
- Go to the instance > Databases > Config database
- In the Config database, open Tables > dbo.Objects > Triggers
- Here you find to triggers. Disable the trigger called “trigger_OnTouchObjects” (right click and choose disable)
- Right click dbo.Objects and choose Open Table
- In the middle pane the table opens and in the first row, fourth column (called “name”) you see the name of the SQL server in your production SharePoint farm. Replace this value with the name of the SQL server in your test SharePoint farm.
- Go back to Triggers and enable the disabled trigger.
- Close SQL Studio Manager and continue with the Configuration Wizard
Tags: backup & restore
On twitter and the site of Stefan Gossner I found the links to the hotfix for Service Pack 2 “bug”.
- 32-bit version: http://download.microsoft.com/download/2/F/5/2F51AB71-1325-49D2-9CB9-18DEC4780E99/office2007-kb971620-fullfile-x86-glb.exe
- 64-bit version: http://download.microsoft.com/download/5/B/B/5BBD34A9-C528-42B0-8A5F-9A8997B25C32/office2007-kb971620-fullfile-x64-glb.exe
Read more at the source.
Tags: hotfix, Service Pack 2
In this post I talked about user roles in browser-based forms. I’ve found a very extensive post on Clayton’s blog (here) about another way of using user roles in forms. Check it out, it is very good.
Also on the subject of webservice he has some interesting posts.
Tags: security, webservice
Planned 2 more exams today to complete my MCITP Enterprise Administrator certificate. 13th of July 070-620 Vista Configuring (unfortunately no Windows 7) and 27th of July 070-647 PRO Windows Server 2008.
I’ll keep you informed.
Tags: exam
Recently I was troubleshooting a SharePoint farm of a customer. The crawl of the content sources did not work and always ended with a “access denied” error in the crawl log. In the eventlog event ID 2436 appeared: “Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content.”
To solve this you have to make a DisableLoopbackCheck registry key. Follow these steps to do so:
- Click Start, click Run, type regedit, and then click OK.
- In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
- Right-click Lsa, point to New, and then click DWORD Value.
- Type DisableLoopbackCheck, and then press ENTER.
- Right-click DisableLoopbackCheck, and then click Modify.
- In the Value data box, type 1, and then click OK.
- Quit Registry Editor, and then restart your computer.
Tags: Best Practices, error
Something I am looking for for quite some time is setting permissions in Infopath forms (browser based). For example, I am building a kind of timesheet form in which several fields might not be accessible by the users but only someone from the financial services department.
I tried several things until I found this blogpost at the Infopath Team Blog. It is about user roles in a form.
[…] Without going much in detail, InfoPath roles is a functionality where you can define user tags like “Sales”, “Management” and utilize them in your form logic. This enables some very interesting scenarios in the forms space. For a detailed discussion on this topic, take a look at this MSDN lab. If you have worked with InfoPath 2003, you would notice that Roles have not changed much in 2007 […]
Read more in this blogpost about the three easy steps to configure this. One remark: in the post is said that you have to add an xml file as resource to the xsn file. At first I did not know how to add a file to a xsn file but I found out that it is possible by going to Tools > Resource Files > Add file.
Read more at the source.
Tags: browser based form, security
Very interesting article at Ian’s blog about some issues with SSRS 2008 and SharePoint.
When installing, think about:
- Integrated mode only works for SharePoint Web Applications on the Default Zone
- Integrated mode will not work on a Web Application that has Anonymous access enabled
Read more about SSRS 2008 installation at the source.
Tags: Report Server
At a customer SharePoint farm there was a “strange” situation. When clicking the My Site link on the top right of the portal home page there appeared a 404 error page. It seemed that the root site of the My Site collection had disappeared. The only thing I heard was that a administrator had tried to delete a users my site.
At first I thought that this could be solved by restoring the my site database. But restoring the problem still existed. After a mornings search on the internet I came across the blog of Jerry Orman. He described the same symptoms I saw at the customer SharePoint farm.
Look to his post for the symptoms and how to prevent this error. You can read there what the correct way is to delete a persons my site.
The solution to this errors is to recreate the my site root “/”:
- Browse Central Administration | Application Management
- Click Create Site Collection
- Select the My Site Web Application
- Set the Title to My Site
- For URL, select the “/” option for the root
- Select the My Site Host site template on the Enterprise tab
- Set the SharePoint System account as the owner.
- Click OK
Read more at the source.
At the moment I’m researching cookie expiration in combination with FBA at a clients SharePoint farm. Cookie expiration is set to one (1) day at that is not acceptable. In my search on the internet for information about this, I stumbled upon a MSDN article about FBA and though it is not relevant for the problems I’m working on, it is worthwhile blogging.
It is about the FBA integration in Office 2007. When SharePoint 2007 and Office 2007 were first released, the Office client applications such as Word and Excel could not directly open a document from a site that was secured with forms authentication. This is because a 302 HTTP response code is sent back to the client when it tries to open an item in a site using forms authentication. The Office clients were not able to respond to a 302 response code, and as a result would display the actual forms logon page in the application, instead of the requested document.
Now an update is available for Office 2007 client applications that allow the applications to process a 302 HTTP response code. Request the hotfix download here.
