MS SQL 2005 DATABASE SERVER CONFIGURATION SETTINGS & PREPARING MS SQL 2005 DATABASE SERVER
Summary of Steps
Database Ports and Connection Protocols
Database authentication mode
Create the Intra.Net Database
Create a Login
1. Database Ports and Connection Protocols
You must manually verify the database server and client enabled protocols and connection portOpen the SQL Server 2005 Management Studio
Open SQL Server Configuration Manager located in Startup menu under MS SQL program group.
Expand SQL Server 2005 Network Configuration group and select Protocols
Double Click on TCP/IP and select YES for Enabled option under Protocol tab
Select IP Addresses tab and type 1433 for TCP Port option for IP1, IP2 and IP All.
Select YES for Enabled option (if not already)
Click Apply and OK.
Expand SQL Native Client Configuration group and select Client Protocols
Double Click on TCP/IP and select YES for Enabled option and type 1433 for Default Protocol under Protocol tab.
Click Apply and OK
Click SQL Server 2005 Service.
Select SQL Server service and restart to apply the changes made in above steps.
2. Database authentication mode
Open SQL Server Management Studio installed with SQL server package and located in Startup menu under MS SQL program group.
Connect to the database server and right-click on the database server name and select Properties
Select Security group and check SQL and Windows authentication mode as Server authentication mode
Click OK and restart the SQL server one more time.
3. 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.
Open the SQL Server 2005 Management Studio
Navigate down the tree to the Databases folder on your SQL server
Right click on Databases and select New Database
Type the database name (ex: intranet) in the Database Name field
5. Click OK
4. Creating a Login for intraNET
Navigate in the tree to the Security folder
Right click on Logins and select New Login
Enter a Login name (ex: intranet)
Under Authentication select SQL Server Authentication
In the Password field type a password (ex: planet)
NOTE: Remove the check for “Enforce password policy”
In the Default Database, select the database created earlier (ex: intranet)
Go to the User Mappings page
Check the Map checkbox on the intranet database
Select Database Roles minimum public and
db_owner
Select
OK