Tuesday, 29 May 2007

Upgrading your Windows SharePoint from SQL 2000 or MSDE to SQL Server 2005

Before we begin

There are eight steps, the three things you should know before you start are, one the name of your Sharepoint databases and two the SQL instance you are using

Step one

First stop the SharePoint sites in IIS if you’re not sure of them, then you can get a list from the SharePoint administration site before you begin.

Step two

Next you’ll need to stop the SharePoint Timer Service you can do this from the services MMC (I would suggest you put it on manual till you complete the upgrade)

Step three

Stop the SQL instance that your SharePoint is installed too (for most of you it will be MSSQL$SHAREPOINT) take the SQL database %SystemDrive%\Program Files\Microsoft\SQL Server\MSSQL$SHAREPOINT\data

If you are unsure of the system path you can get is by looking at the properties of the SQL service, inside the data directory your will find your SQL data copy these to a safe location the first database is normally STS_servername_1.mdf and STS_Config.mdf you’ll also need the log files STS_servername_1_log.LDF and STS_Config_log.LDF (Other database will only exist if you created them and hopefully you will not forget them when backing them up)

Step four

Now that you have your databases safely copied you can goto the add remove programs and remove the SQL instance the normal label “Microsoft SQL Server (Sharepoint)” remember whatever the name of the instance will have to use later when installing SQL 2005.

Step five

Install Microsoft SQL 2005 remembering that you need to do the following one install the “Management Tools” this option is not selected by default, two remember to select the instance name that matches the one you removed earlier. (Windows Authentication Mode and two use the SQL cluster account or the local system account if you have only one Sharepoint server)

Step six

After the install open the SQL Server Management Studio and connect to your instance, on the right hand side you’ll have the Object Explorer and under that the Security create a new login type the name NT Authority\Network Service if this name is wrong it will not work.

You also need to give the NT Authority\Network Service some roles right click on it and select the login properties click the Server Roles and select the dbcreator and securityadmin roles

Create another login DomainName\SBS SP Admins

Step seven

Your need to reattach the database so from Microsoft SQL Server Management Studio under the Object Explorer right click on the databases and select Attach then click add, you are adding the same databases you made copies of in step three remember to add the STS_servername_1.mdf first then the config database.

Step eight

Restart the SharePoint Timer Service you stopped in step two and then lastly restart the sites in IIS your upgraded is now complete.

No comments: