| Setting up Microsoft SQL Server to work with the Projects Server This example allows you access to the Projects server where your Microsoft SQL database is stored. The Microsoft SQL Server software also has client software that allows you to create tables, read and write to the database, and edit the database as you find necessary. Here are the required steps that will allow you to appropriately connect to your Microsoft SQL database on the Projects server. 1. First, launch the Client Network Utility. You will find this under Start/Programs/Microsoft SQL Server: Click thumbnail to view >>> 2. Once the Client Network Utility is launched, the General Tab should be the default tab selected. You will see a list of disabled and enabled protocols. If the TCP/IP protocol is disabled, add it to the enabled protocols: Click thumbnail to view >>> 3. After TCP/IP is enabled, click the alias tab. Here you will create an alias for the Projects server. To add an alias, just click the 'Add' button: Click thumbnail to view >>> 4. On the right side, you will see 'Network Libraries'. Make sure TCP/IP is selected. In the Server Alias text box, type 'projects.' In the server name text box, type 'projects.coe.uga.edu.' Then click ok: Click thumbnail to view >>> 5. Now we are ready to connect to the projects server. Under Start / Programs/ Microsoft SQL Server, launch the Enterprise Manager: Click thumbnail to view >>> 6. On the left panel, you will see Microsoft SQL Servers. Expand the list, and you will see SQL Server Group. Right click the SQL Server Group and a menu item that says "SQL Server Registration" will appear. Click and you will begin to register Projects as your SQL Server: Click thumbnail to view >>> 7. Once you start the Registration wizard, you will be asked to select a server. The server 'projects' will be be one of the available servers. This is the same server that you set up with the Client Network Utility. Add projects to the 'Added Servers' section, then click Next: Click thumbnail to view >>> 8. The next screen will be the 'Server Authentication Mode' screen. Here you will select the option to use the SQL server account that was provide to you by the system administrator, then click Next: Click thumbnail to view >>> 9. The next screen will prompt for you to login to the database. This username and password will be different from the username and password for the Projects account. It should be provided for you when you come to create your database on the server. You can either enter your username here or ask to be prompted for login when you connect to the database: Click thumbnail to view >>> 10. The final step will be to select the server group. Select the appropriate server group from the drop down menu and click next: Click thumbnail to view >>> 11. After the server group is selected, you can then finish the wizard. You are now ready to connect to the database. In the right window, you should now see the Projects server. Right click the server and go to 'Connect' on the menu (assuming you selected the option to be prompted to enter your username and password): Click thumbnail to view >>> 12. Connect to the database using the username and password provide to you for the database. (this is not the same as your projects username and password): Click thumbnail to view >>> 13. After you have successfully logged in, you can now use the database as you wish. You will see a list of databases that are available, but the only one that you will have access to is your database: Click thumbnail to view >>> If you have any more questions, please feel free to contact us at OIT. Click here to return to the previous page. |
