Instructions for establishing connection to your SQLSERVER database:
Visual Studio has been installed on IT sites. To open Visual Studio, go to start ->all programs ->Microsoft Visual Studio 2008 ->Microsoft Visual Studio 2008
To connect to your SQL Server database in Visual Studio, go to menu Tools ->Connect to Database, this will open a server explorer window. In server explorer, right click on Data Connections, choose add connection.
You need to provide the following information to make a new database connection:
- Server name: cs4354db.cs.ttu.edu
- To create tables Use Windows Authentication. This implies that you are logged on to a machine bound to the TTU network such as a TTU workstation, a Windows machine through VPN, or an emulated TTU workstation running on Parallels or VMWare Fusion. The example is running on the latter case through VMWare Fusion on OSX Leopard.
- Use SQL Server authentication for the option log on to the server. user name: <your eRaider name>_name , password: <your eRaider name>_name.
- If this is the first time logging in under SQL Server Authentication, then you will need log in through MS SQL Server Management Studio Express to change your password first.
- Note that under these conditions you will not be able to create tables.
- Choose select or enter a database name for the option connect to a database. In the combo box below, choose the database with a name the same as your eRaider.
- Under your Windows Authentication, you are the dbo for your own database so you have full permission. While under SQL Server authentication, you lack certain tickets required for table creation.
Click OK, you’ll see a new connection in the server explorer named as: acadiana.<your eraider name>.dbo. Unfold it, you’ll see subfolders for tables, views, stored procedures, etc.