Topics Map > UWGB Help Desk > Home Use Software

SQL Server 2014 Management Studio Setup

The following information will provide you with the correct setup for students to access the server/database.

Before setup for SQL Server 2014 Management Studio, students need to configure there Remote Desktop correctly.

Part #1:

Remote Desktop Lab is the only way the students will be able to access the server.

Here is a knowledge document that provides information on Remote Desktop Setup:

UW-Green Bay Remote Lab

Important things to highlight from Remote Desktop Lab:

  • The student needs to verify that they are not using Microsoft Edge on Windows 10 for accessing remote lab.

  • Remote Desktop Lab ONLY works in Internet Explorer.

  • Java must be enabled.

Part #2:

After the student log’s in: Search for SQL Server 2014 Management Studio.  It looks like this.

sql server 2014 management studio

Once the program is open the box will appear like this: (INCORRECT Info.)

incorrect image

This is the correct information. Please fill in the correct information like the picture below. (CORRECT)

correct information


Server Type: Database Engine

Server Name (AS IS): icssql-1

Authentication: SQL Server Authentication

Login & Password: (Not your campus username or ID)

  • Login information is provided by your instructor on D2L.
  • Example: Class Name > Under Week #1 Intro > UWGB DATA BASE SERVER INSTANCE - STUDENT ACCOUNT INFO

Any other questions about setup or login issues please contact the Help Desk by email ( or phone call (920-465-2309).

  • Please tell us what account you are trying to sign in with, what error your are receiving (preferably a screenshot), and how we can contact you back.

See Also:

Keywords:SQL, Server, 2014, Management, Studio, Setup, database, engine, icssql-1   Doc ID:73659
Owner:Katelynn F.Group:UW Green Bay
Created:2017-05-30 15:41 CDTUpdated:2017-09-20 10:58 CDT
Sites:UW Green Bay
Feedback:  0   0