SETTING UP THE CLIENT CONNECTION
StartàProgramsàMicrosoft SQL ServeràClient Network Utility
Click on the ALIAS tab
Click ADD. Enter Server Alias: CALHOUN
Select TCP/IP in Network Libraries. Specify Server name: CALHOUN
Deselect the check box on Dynamically Determine Port.
Enter port number: 5000
Click OK and exit.
Click APPLY and exit.
HOW TO CREATE A DATABASE USING A MS-SQL CLIENT
StartàProgramsàMicrosoft SQL ServeràEnterprise Manager
Right click on SQL Server Group
Select New SQL Server Registration
On the Welcome dialog box, click the next button
On the Register SQL Server Wizard dialog enter CALHOUN for
the available servers, click add, then click next
Select the SQL Login Information… radio button.
Enter login name and password.
Click next on the Select SQL Server Group dialog, then
click on the finish button in the next dialog window.
CREATING A TABLE
Expand the SQL Server Group tree by clicking on the + box-icon.
Expand the CALHOUN tree by clicking on the + box-icon.
Right click on Databases, select the New Database option
Provide a database name: Use whatever name you want (say,
CourseDBX)
Right click on database, CourseDBX. Select newàTable
Enter the table parameters:
StudID*, FName, LName, Address, Gender, GPA, Status.
*make sure that you don't allow nulls on the StudID attribute.
Right click on the StudID row and select Primary Key. This will
make the StudID as the primary key of the table.
Close the new table dialog box. The system will prompt you to
save the table, click yes and enter the table name, Student.
Right click on Student table, select Open TableàReturn all rows
Enter the data values for each row.
