Thursday, June 18, 2009

Teamworks for SharePoint 2007 Installer

I've been testing out Teamworks for SharePoint 2007 in my sandbox farm and wanted to make a quick note for future installs - when running the installer, it tries to connect to the content database of the SharePoint web site you chose using their install wizard. It does this to create Lombardi site templates, which are later required by the teamworks integration component.

Make sure that you run the installer as the account that has rights to access the content database in sql server. In most cases, you'll want to run the installer using the service account you created to manage SQL connections for the sharepoint farm. In my case, I was trying to run the installer as the "Moss Setup User" which is the account I use to access the central admin and to run the "SharePoint Products and Technologies Configuration Wizard", but that account has more restricted database access which lead me to this problem.

If you dont have the proper SQL server rights to the database, the installer silently fails to install the new site templates, and in turn the Teamworks SharePoint Integration features all fail. If you run into this problem, simply run the installer again and allow it to uninstall the Teamworks components from your SharePoint server, then login as the user with proper rights to access the content database you want to install to and run the installer again.

No comments: