PREPARING MS SQL 2000 DATABASE SERVER
Summary of Steps
1. Install Full Text Search 2. Create the Intra.Net Database 3. Create a Login
1. Installing Full Text Search
Full text search allows intraNET to search Microsoft Office documents such as Word, Excel and PowerPoint. However, Full Text Search is not installed by default with MS SQL. To install it or check if it is already installed, follow these steps:
1. Insert your SQL Server 2000 CD-ROM and launch the installation program
2. Select the "Upgrade, remove or add components to an existing instance of SQL server" when given the opportunity
3. Under Server Component check that the Full Text Search sub-component is checked. If it is, cancel out of the setup wizard. If not, check it and select next
4. After setup is complete, you will have to reapply any service packs that you previously installed.
2. Creating the intraNET Database
You must manually create the database for intraNET. These instructions explain the minimum amount of steps required to create a working intraNET database.
1. Open the SQL Server 2000 Enterprise Manage
2. Navigate down the tree to the Databases folder on your SQL server
3. Right click on Databases and select New Database
4. Type the name intranet in the Name field
5. Click OK
3. Creating a Login for intraNET
1. Navigate in the tree to the Security folder
2. Right click on Logins and select New Login
3 Select the name intranet
4. Under authentication select SQL Server Authentication
5. In the password field type planet
6. In the database list, select the intranet database created earlier
7. Goto the Database Access tab
8. Check the Permit checkbox on the intranet database
9. Under the Permit in Database Role check public and db_owner
10. Select OK