Ulysses Ludwig's SharePoint blog

SharePoint 2010 Installation Part 3 – Install SharePoint

This article is part 3 in a 4 part series that shows how I build my SharePoint 2010 development environment from the ground up.  In the previous series I built a Windows 2008 R2, configured the Active Directory Domain Services role, provisioned SharePoint service accounts, configured the IIS role, installed and configured SQL 2008, updated SQL, and configured a SQL Server alias. Now that you've diligently followed all of the steps in Part 1 and Part 2 of this series, and taken snapshots al...

SharePoint 2010 Installation Part 2 – Install SQL

This article describes the installation process for a SQL server on an all-in-one SharePoint 2010 development server. If you didn't follow Part 1 of the SharePoint 2010 Installation series you'll need to create a SQL service account to support the SQL Server 2008.  While there are many ways to configure SQL and many possible features that you can activate, the steps below demonstrate a “least” features approach allowing you to simply install and run a dumb SQL Server. Let’s start by mount...

Configure a SQL Server Alias for Sharepoint (SQL Server 2008)

A SQL Server alias is a tidy way to protect yourself from configuration changes in a SharePoint farm. Anybody who works with SharePoint on a regular basis knows that it is very difficult to move SharePoint to a different SQL Server. When disaster strikes wouldn't it be nice if you could simply change SQL Server that SharePoint references? To do so, install the SQL client access tools on each server and create a SQL Alias in SQL Server Configuration Manager, from there your SharePoint Server can ...

Unable to delete a job from SQL Server 2005

Problem SQL Server has a broken reference somewhere preventing you from deleting a maintenance job, presumably a job that you created as a maintenance plan. OR (worse yet SQL claims that it isn't "aware" of this job) Solution So the ultimate solution to this problem is to delete the job and all of its references/dependencies/children using a stored procedure (don't worry, I provided the stored procedure below). Step 1 Backup your msdb database. Step 2 Select the sysjobs from ...