skip to main content

SQL Server Access

What is the SQL server?

We have a server running Microsoft's Terminal Server Software that allows you to access COBA Resources from anywhere there is an internet connection and Windows XP or Internet Explorer. The terminal server has Microsoft SQL Server 2012 installed to allow IS 475/675 and IS 482/682 students access from anywhere. Microsoft Office 2010 is also installed on the server. Students are also able to save files to the "U drive" and access those files from anywhere.

How do I access it?

From Windows XP, Vista, 7 - Navigate to the following program:

Click Start -> All Programs -> Accessories -> Remote Desktop Connection
In the computer box put: sts.coba.unr.edu

You will just need your NetID and Password to logon to the server. Be sure to choose to log into the University domain. Once there, you get a clean desktop that you can customize to your needs.

How do I access SQL Server?

Once you have successfully logged onto the server:

Click Start -> All Programs -> Microsoft SQL Server 2012 -> SQL Server Management Studio

Leave all of the default options on the Connect to Server screen and connect to the ISSQL\STUDENTS server.

Note that you may need to choose Browse for more and choose the correct server under Database Engine.

Choose Connect.

SQL Server uses your Windows credentials (your NetID) to allow you access.

Once you are logged into SQL Server, on the left side under the databases option you will see all of the available databases. The one that you have access to is the one that has your NetID for the database name.

You can also connect to SQL Server using MS Access.

Take the next step...