Home > SharePoint Development > Windows 2008 & SQL Server 2008 Development Environment Tips

Windows 2008 & SQL Server 2008 Development Environment Tips

Given the requirements for SharePoint 2010, I suspect it will be increasingly common for SharePoint development environments to move to 64-bit Windows 2008 and SQL Server 2008.

Here are a few tips to help get your favourite development working as they should:

Turn off User Access Control
Most developers log into their development environment using an account with local administrator privileges. User Access Control (UAC) however means that the account can only perform administrative operations when applications are explicitly run as an administrator and doesn’t permit spawned applications to inherit the administrator permission.

This is especially important for WSPBuilder which executes a command-line tool to build and deploy the WSP file. With UAC turned on you may encounter the following “pre-flight” errors:

  • SharePoint is not installed on [host]
  • Microsoft Office Server is not installed on [host]
  • Microsoft SharePoint Services Administration is not running on [host]
  • Microsoft SharePoint Services Timer is not running on [host]

Check permissions within SQL Server 2008
Basic I know, but it is worth reviewing the security settings on the SQL Server 2008 instance to make sure that the account used to deploy solutions has sufficient permission. In the development environment you are master of your own domain, so go wild and give it sysadmin privileges.

Some symptoms of not having sufficient permission include:

  • WSPBuilder
    User [account] does not have installation permissions on [host]
  • VSeWSS
    VSeWSS Service Error: No SharePoint Site exists at the specified URL.
Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: