Connecting to il-server-02 – Web Server Revised 8/25/2020 This document explains how to connect from off-campus to the on-campus SQL Server that is used for IT 3060C and IT 2060C. Follow these steps...

i can give login, will also need "Anyconnect vpn" to connect to sql database.I just need queries for the questions asked at bottom of file


Connecting to il-server-02 – Web Server Revised 8/25/2020 This document explains how to connect from off-campus to the on-campus SQL Server that is used for IT 3060C and IT 2060C. Follow these steps at your own risk: any changes that you make to your personal devices are your responsibility. There are two parts to getting connected: 1. The UC VPN (Virtual Private Network) 2. SSMS/SQL Server. I am responsible for SSMS/SQL Server, UC IT is responsible for the VPN. You can use this information to access our SQL Server instances from off-campus so you can do your homework at home. It is your responsibility to have your homework complete and submitted on-time. If you need help with the VPN: start with UC IT. Be patient with them and help them to understand what you are doing. Help them to understand that you are using their VPN and that they do support that product. I cannot support every possible home computer, laptop, tablet, smart phone, and windows-enabled Fitbit. Please don’t email me and simply say “I can’t connect.” You must provide more information! If you need more help, try Stack Overflow, then Google, then Bing. The answers are out there. In this class, you are expected to operate as an IT professional: · Don’t wait until the last minute to get configured. · Read the system messages carefully. · Search for solutions online. · Try solutions one-at-a-time. · Be patient and persistent. Download and install (free!) SQL Server Management Studio Express. 18.x is the current version. It is here : https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms A list of possible downloads will appear. Pick what works for you. You can look at Control Panel / System to see if your O/S is 32 bit or 64 bit. You don’t need SQL Server, just SSMS. They are not the same thing. Do not install SQL Server: you will hate your life. You might need to install other things as well. After you start the process you will learn more. Don’t panic. Connecting to our SQL Server instance on IL-Server-002.uccc.uc.edu: 1. Download and install VPN software from UC. You can find it on the UC Library web site, https://ituc.service-now.com/kb?id=kb_article_view&sysparm_article=KB0010565&sys_kb_id=50798e871b97c410b4a776e1dd4bcb08 . I don’t know if there’s a Mac or Linux version: I have used Win XP and Win 7 and Win 10 successfully. 2. Log into the UC network by opening the VPN and providing your UC Central Login credentials. Refer to Figure 1. These are the same credentials you use for accessing One Stop and your UC email and Canvas. Figure 1 : UC VPN installed on your computer Note: After starting the VPN you are part of the UC network. All your Internet activity may be routed through UC servers. You may be logged, and you will not be anonymous. Don’t embarrass yourself. 3. Open SQL Server Management Studio. 4. In the Object Explorer, select Connect / Database Engine. A dialog box opens. In the server name box, type in IL-Server-002.uccc.uc.edu\MSSQLSERVER2019 Note: on campus you probably don’t need the FQDN: use IL-Server-002\MSSQLSERVER2019 instead. None of the server name is case-sensitive. 5. Choose SQL Server Authentication as the mode. 6. Type in the username (your UC 6+2) and password you were assigned for the SQL Server instance (I gave you this) and hit connect. You are not using your UC Central Login password. 7. The window will show the database server connection. 8. Note: if you forget your password to the database server and you get locked out from guessing, you must wait a few minutes to get automatically unlocked. The IP of IL-Server-002 on UC Clermont LAN is 10.230.253.44 or something similar. You probably won’t need this but here it is anyway. If you are having connectivity issues you might want to ping that IP address (while the VPN is running) as part of your diagnostic efforts. Refer to Figure 3. If you don’t know how to ping a host, look it up with the search engine of your choice. Figure 3 : Pinging the server to verify you are connected to the VPN Figure 4 If you encounter this error, you can download a fix at http://support.microsoft.com/kb/951608 . Do this at your own risk. Figure 5 Microsoft will install the security fix. They are so nice. Do this at your own risk. Bill Nicholson Clermont College, University of Cincinnati [email protected]