Sharepoint | Patrick’s Bytes

Took me a few hours to figure this out. I actually did a reinstall of my SharePoint 2007 after it got screwed up. I reinstall Windows Server, had it join domain, logged in as a domain (added as local admin earlier). The whole installation went fine until the point I have a create a Shared Service provider, I got hit by a Access Denied error when I create a web app for both SSP and My Site.

At first I tried to login with a domain admin account but I got the same error. In the end I realize the problem is caused by SQL Server. You see problem arise when I tried to delete all SharePoint database from the database server but I left the SharePoint service account there.

In the end I uninstall SharePoint, go into SQL Server delete all databases and the account and it went smoothly.

I managed to setup SharePoint 2010 Beta 2 on a Windows Server 2008 SP2 VM with SQL Server 2008 R2 Nov 09 CTP. SP2010 requires 64bit version of Windows Server and SQL Server . For the host I have an Intel C2Q machine on 4GB RAM running Windows Server 2008 R2 with Hyper-V installed.

For the VM environment, I have:

AD Domain Controller on Windows Server 2008 SP2 Server Core
Another VM running Windows Server 2008 SP2 enrolled in the AD domain. I have PowerShell feature (for SQL Server), IIS Web Server role and Application Server role (both for SharePoint) setup after I enrolled the VM in AD.

For part 1 of this, I will show how I setup SQL Server 2008 R2. Even though it’s in CTP, setting the database server is no brainer.

Below are my screenshots of the whole process. For detailed explanations, you can follow Microsoft UK MCS’s blog here.

This is the system properties of the VM. Note that I allocated 2.5Gb RAM for this VM.

Put in the SQL Server 2008 R2 DVD and it asked me to setup prerequisites i.e. .NET Framework 3.5 SP1 and an update to Windows Installer.

Prerequisites installer starting up

Accept the EULA for .NET Framework 3.5 SP1

.NET Framework installer running

.NET Framework 3.5 SP1 setup successfully.

SQL Server 2008 R2 installer will starts automatically.

Click on the Installation tab on the left. Then choose ‘New installation or add feature to an existing installation.’

Installer to inspect system and determine all setup rules passed.Click OK here

The SQL Server 2008 R2 setup files starting up. Following experience will be very similar to setting up SQL Server 2008. Hope it doesn’t change in the final release

Select that I want the Enterprise Edition

Accept the EULA

Setup files copying themselves

Setup support rules are scanned again. I ignore the warning on opening up the SQL Server port at the firewall.

This is new for R2, being not 100% sure, I choose the first logical option

Then select the SQL Server features I want. I chose:

Database engine with Full text search
Reporting Services
BI Development Studio (optional)
Management Tools – Complete

Installation rules are scanned to make sure all requirements fulfilled

Determined my SQL instance (in case you have more than 1 already installed)

Determine I have enough hard disk space

Now is the choose the user account(s) to be used for the services. I create a sqlservices account in my domain and I want all services to use the same account. So I clicked on ‘use the same account for all SQL Server services’