- 48 -
Migrate SharePoint to SQL Server 2005
NOTE:
Migrating SharePoint’s MSDE database to SQL 2005 allows the business to take advantage of SQL
Server 2005’s better performance and scalability. SQL Server 2005 won’t upgrade directly the existing
MSDE database of SharePoint 2.0. You have to remove the current MSDE of SharePoint and create a new
instance during install SQL Server, and then attach the current SharePoint database to SQL Server 2005.
Stopping http://companyweb website and SharePoint Services
1.
Stopping the http://companyweb: Click
Start -> Server Management
. At the Server
Management, double-click on
Advanced Management
under the
Home Page
2.
Double-click on
Internet Information Services
on the right pane, and then double-click
on
<your server name>
3.
Double-click on
Web Sites
, right-click on
companyweb
and click
Stop
4.
Stopping the SharePoint Timer Service: Click
Start -> Administrative Tools
and click on
Services
.
5.
At the
Services
right-click on
SharePoint Timer Service
and click
Properties
, change
Startup type:
to
Manual
. Click the
Stop
button and click
OK
.
6.
Stopping the MSSQL&SHAREPOINT Service: Still in Services, right-click
MSSQL$SHAREPOINT
and click
Stop
7.
Removing the Desktop Engine (Sharepoint): Click
Start -> Control Panel
, click
Add or
Remove Programs
, select program
Microsoft SQL Server Desktop Engine
(Sharepoint)
, and click
Remove
. Click
Yes
to remove.
8.
Restart the system before continue next steps.
Create new SHAREPOINT instance of SQL Server 2005
Содержание SMALL BUSINESS SERVER
Страница 17: ... 17 ...
Страница 46: ... 46 11 At the Instance Name screen select Default instance and click Next ...
Страница 68: ... 68 ...