|
| |
Installing SharePoint Team
Services “v2.0” Beta 1
with a Remote SQL Server
If you plan to host many Web sites (more than 1000)
using SharePoint Team Services “v2.0” Beta 1, it is recommended that you use SQL
Server on a separate server from your Web server. Using SQL Server on its own
server allows you to host all of your databases together and manage them with
SQL Server management tools. Using SQL Server on its own server also allows your
SharePoint Team Services “v2.0” Beta 1 server to devote its processor, memory,
and disk resources to serving up pages and files. For more information about SQL
Server and SharePoint Team Services “v2.0” Beta 1, see
SharePoint Team Services “v2.0” Beta 1 Architecture.
If you want to run SQL Server on a separate server from
SharePoint Team Services “v2.0” Beta 1, you must take specific steps to
configure both your Web server computer and your SQL Server computer before,
during, and after installing SharePoint Team Services “v2.0” Beta 1. For example,
to set up SharePoint Team Services "v2.0" Beta 1, you must run Setup from the
command line, using the remotesql=yes parameter. This topic describes the
steps needed to configure one server running SharePoint Team Services “v2.0”
Beta 1 and one server running SQL Server 2000 working together across a network
connection. This topic does not cover setting up a Web farm, with multiple
front-end and back-end servers. For more information about setting up a Web farm,
see
Installing and Configuring SharePoint Team Services “v2.0” Beta 1 for a Web Farm
Serving Multiple Host Names.
Before installing SharePoint Team Services “v2.0” Beta
1
Before you are ready to install SharePoint Team
Services “v2.0” Beta 1, you must be sure that your Web server computer meets
certain software and hardware requirements, and be able to connect to your SQL
Server computer. You must also configure your SQL Server computer to be ready to
host SharePoint Team Services “v2.0” Beta 1 data.
Preparing the Web server computer
Before you install and configure SharePoint Team
Services “v2.0” Beta 1, you should check to make sure you meet the hardware and
software requirements. The following sections help you review the requirements.
Hardware and software requirements
To be able to set up SharePoint Team Services “v2.0”
Beta 1 with remote SQL Server, you must meet the following criteria:
- One computer running Microsoft Windows .NET
Standard or Enterprise Server, configured as a Web server (running Internet
Information Services in Worker process isolation mode). Note that the
hardware requirements for SharePoint Team Services “v2.0” Beta 1 are the
same as the Windows .NET Standard or Enterprise Server installation
requirements. You must use the NTFS file system to use SharePoint Team
Services "v2.0" Beta 1. Microsoft Windows includes a conversion utility (Convert.exe)
that you can use to convert an existing file allocation table (FAT) volume
to NTFS — without losing data.
- Another computer with SQL Server 2000 installed
with the latest service packs. You can use SQL Server 2000 Standard or
Enterprise edition with SharePoint Team Services “v2.0” Beta 1. For more
information about installing SQL Server, see the SQL Server 2000
documentation.
- The client computers must be running Microsoft
Internet Explorer 5.0 or later or Netscape Navigator 6.2 or later to use
SharePoint Team Services “v2.0” Beta 1 team Web site features.
For a complete list of hardware and software
requirements, see
SharePoint Team Services “v2.0” Beta 1 Requirements.
Configuring the Intranet server as a Web server
IIS is not enabled by default in Windows .NET Server.
To make your front-end server into a Web server, you must enable IIS.
To enable IIS and configure it to use Worker process
isolation mode
- Click Start and then click Manage Your
Server.
- On the Manage Your Server page, click
Add or remove a role.
- On the Preliminary Steps pane, click
Next.
- On the Server Role pane, click Web
application server (IIS, ASP.NET), and then click Next.
- On the Summary of Selections pane, click
Next.
- Click Finish.
- Click Start, point to Administrative
Tools, and then click Internet Information Services (IIS).
- In Internet Information Services manager, click
the plus sign next to the server name, and then right-click the Web Sites
folder and select Properties.
- In the Properties dialog box, click the
Services tab.
- In the Isolation mode section, clear the
Run Web service in IIS 5.0 isolation mode check box, and then click
OK.
Preparing the SQL Server computer
Besides configuring the connection from your Web server
computer to the SQL Server computer, you must also configure your SQL Server
installation to work with SharePoint Team Services “v2.0” Beta 1. For SharePoint
Team Services “v2.0” Beta 1 to be able to connect to your SQL Server database
from the remote Web server computer, it is recommended that you configure the
SQL Server database to use Windows authentication.
To enable Windows authentication for SQL Server
- On your SQL Server computer, click Start,
point to Programs, point to Microsoft
SQL Server, and then click Enterprise
Manager.
- In Enterprise Manager, click the plus sign (+)
next to Microsoft SQL Servers.
- Click the plus sign next to
SQL Server Group.
- Right-click the SQL Server name, and then click
Properties.
- In the Properties dialog box, click the
Security tab.
- Under Authentication, select Windows
only, and then click OK.
Running Setup
By default, when you install SharePoint Team Services
“v2.0” Beta 1 to a computer without SQL Server installed, the Setup program
installs Microsoft Data Engine (MSDE). To use SharePoint Team Services “v2.0”
Beta 1 with a remote SQL Server, you must install SharePoint Team Services
“v2.0” Beta 1 without installing MSDE. To install SharePoint Team Services
“v2.0” Beta 1 without MSDE you run the SharePoint Team Services “v2.0” Beta 1
Setup program with the remotesql command-line option. For more
information about the remotesql option and other SharePoint Team Services
“v2.0” Beta 1 Setup options, see
Command-line Options for Setupsts.exe. If you prefer,
you can also install SharePoint Team Services “v2.0” Beta 1 without MSDE by
running a quiet, command-line installation, rather than running the full Setup
program. For more information about a quiet installation, see
Customizing SharePoint Team Services Installation.
To install SharePoint Team Services "v2.0" Beta 1
without installing MSDE
- Insert the SharePoint Team Services "v2.0" Beta 1
CD into your server computer's CD-ROM drive.
- Click Start, and then click Run.
- In the Open box, type d:\setupsts.exe
remotesql=yes (where "d:" is your computer's CD-ROM drive).
The SharePoint Team Services “v2.0” Beta 1 Setup
program opens.
- On the End-User License Agreement panel,
select the I accept the terms in the License Agreement check box, and
then click Next.
- On the Summary panel, verify that only
SharePoint Team Services “v2.0” Beta 1 will be installed, and then click
Install.
- Setup runs and installs SharePoint Team Services
“v2.0” Beta 1.
After installation
After the Setup process is complete, you can configure
your administrative virtual server (including specifying an
application pool to use for the virtual server
processes), connect to your SQL Server computer, and then provision your virtual
servers with SharePoint Team Services “v2.0” Beta 1. You perform these steps by
using HTML Administration pages.
To configure the administrative virtual server
- On the Configure Admin Virtual Server page,
in the Application Pool section, select Create a new application
pool.
Note You can also use an existing
application pool, but the account used for that application pool must be a
domain account (so that it can access the remote computer running SQL
Server), and must have rights to create new databases in SQL Server. In
other words, this account must be a member of the Security Administrators
and Database Creators roles in SQL Server.
- Type the name to use for the new application pool,
and then specify whether to use a predefined or configurable security
account for the application pool.
- If you selected Predefined, select the
security account to use.
- If you selected Configurable, type the
user name and password to use.
It is recommended that you use a predefined domain
account, so that the account has rights to both the Web front-end server and
the database back-end server. Again, the account you use must have rights to
create new database in SQL Server.
- Click Submit.
If you have used a domain account that does not already
have database creation rights in SQL Server, you can give the account this
access in SQL Server Enterprise Manager. This is a one-time only change. Once
you have granted database creation permissions to the account used by the
SharePoint Team Services administration virtual server, this account can create
databases for any subsequent virtual servers.
To grant database creation rights in SQL Server
- On your SQL Server computer, click Start,
point to Programs, point to Microsoft
SQL Server, and then click Enterprise
Manager.
- In Enterprise Manager, click the plus sign
next to Microsoft SQL Servers,
click the plus sign next to SQL Server Group,
and then click the plus sign next to your SQL Server.
- Click the plus sign next to Security, and
then right-click Logins, and click New Login.
- In the Name box, type the account in the
form DOMAIN\name.
- Click the Server Roles tab.
- In the Server Role list, select the
Security Administrators and Database Creators check boxes, and
then click OK.
After you configure the administrative virtual server (and
granted SQL Server rights to the new application pool account, if necessary),
you must restart Internet Information Services (IIS), by typing iisreset
on the command line. After IIS is reset, you can click the link on the
Application Pool Changed page to continue configuring SharePoint Team
Services "v2.0" Beta 1 to work with your remote SQL Server.
To connect to the remote SQL Server
- On the SharePoint Central Administration
page, under Server Configuration, click Set configuration database
server.
- On the Create Configuration Database page,
in the Configuration Database section, enter the server name and
database name to use.
- Select Use Windows integrated authentication
(more secure, recommended).
- Click Submit.
Extending a virtual server with SharePoint Team
Services “v2.0” Beta 1
After you set up the connection to your SQL Server
computer, you are ready to extend the virtual servers on your Web server
computer with SharePoint Team Services “v2.0” Beta 1. When you extend a virtual
server, SharePoint Team Services “v2.0” Beta 1 is applied to a virtual server
and a top-level Web site is created. To extend a virtual server, you use HTML
Administration pages.
Note If you had a previous version of
SharePoint Team Services or FrontPage Server Extensions, you will need to
upgrade the virtual server rather than extend it. For more information, see
Upgrade Considerations.
To extend a virtual server with SharePoint Team
Services “v2.0” Beta 1 and connect to a remote SQL Server
- On the SharePoint Central Administration
page click Extend or upgrade virtual server with SharePoint Team Services.
- On the Virtual Server List page, click the
name of the virtual server to extend.
- On the Extend Virtual Server with SharePoint
Team Services page, in the Provisioning Options section, select
Extend and create a content database.
- In the Application Pool section, select
either Use an existing application pool or Create a new
application pool.
Note It is recommended that you create a
new application pool for each virtual server, so that they run in separate
processes. This application pool should use a domain account, but it does
not need to have database creation rights in SQL Server - the administration
virtual server account will create any databases required.
If you selected Use an existing application pool,
select the application pool to use. If you selected Create a new
application pool, enter the new application pool name, account name, and
password to use.
- In the Site Owner section, in the
Account name box, type the user name for the site owner (in the format
DOMAIN\username if the username is part of a Windows domain group).
- In the E-mail address box, type the e-mail
address that corresponds to the account.
- In the Database Information section, select
the Use default content database server checkbox, or type the
database server name and database name to use for a new content database.
- If you want to specify a path for the URL, in the
Custom URL path box, type the path to use.
- If you are using quotas, select a template in the
Select a quota template box of the the Quota Settings section.
- In the Site Language section, select the
language to use.
- Click OK.
After a few moments, the virtual server is extended and
a confirmation page is displayed. You can open the home page for your
new SharePoint Team Services “v2.0” Beta 1 team Web site in your browser by
using a link on the confirmation page. You can continue to extend other virtual
servers or configure Self-service Site Creation so users can create their own
sites.
07/06/2003
|
