Installing SharePoint Portal Server 2003 to Connect to an External SQL Database


This process is the same as installing SharePoint Portal Server 2003 with SQL Server, with the obvious difference that SQL Server does not need to be installed on the server, and after the step is reached where the SQL database is referenced (step 14 in the previous section), simply provide the information that corresponds to the existing database server.

As mentioned previously, the SQL database will need to be configured to connect to SharePoint Portal Server 2003. The steps required here can vary based on the configuration of SQL Server 2000, but initial steps to take are as follows:

1.

On the SQL Server computer, click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

2.

In Enterprise Manager, click the plus sign next to Microsoft SQL Servers.

3.

Click the plus sign next to SQL Server Group.

4.

Right-click the SQL Server name, and then click Properties.

5.

In the Properties dialog box, click the Security tab.

6.

Under Authentication, select Windows only, and then click OK. You can also select SQL Server and Windows but it is recommended that you use Windows authentication to connect to your SQL Server database.




Microsoft SharePoint 2003 Unleashed
Microsoft SharePoint 2003 Unleashed (2nd Edition) (Unleashed)
ISBN: 0672328038
EAN: 2147483647
Year: 2005
Pages: 288

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net