Difference between revisions of "Connecting to Database - MS SQL"

From Hostek.com Wiki
Jump to: navigation, search
(Created page with "==SQL Management Studio== *Use the following steps to log into your MS SQL database using SQL Management Studio #Log into the WCP and click '''"MS SQL"''' #Copy the server lis...")
 
(Where to get SQL Server Management Studio)
 
(5 intermediate revisions by 4 users not shown)
Line 1: Line 1:
==SQL Management Studio==
+
__FORCETOC__
*Use the following steps to log into your MS SQL database using SQL Management Studio
+
 
 +
==SQL Server Management Studio==
 +
*Use the following steps to log into your MS SQL database using SQL Server Management Studio
 
#Log into the WCP and click '''"MS SQL"'''
 
#Log into the WCP and click '''"MS SQL"'''
 
#Copy the server listed for your database. For example: '''"sql1.hostek.com"'''
 
#Copy the server listed for your database. For example: '''"sql1.hostek.com"'''
Line 7: Line 9:
 
#Set '''"Authentication"''' to '''"SQL Server Authentication"'''
 
#Set '''"Authentication"''' to '''"SQL Server Authentication"'''
 
#Enter the database username and password and click '''"Connect"'''
 
#Enter the database username and password and click '''"Connect"'''
 +
 +
*You can also hide the system objects in SQL Management Studio by using the following steps:
 +
#Click '''"Tools"'''
 +
#Select '''"Options"''' from the menu
 +
#Click '''"General"''' under '''"Environment"'''
 +
#Check the box for '''"Hide system objects in Object Explorer"''' and click '''"OK"'''
 +
#Restart SQL Management Studio and Reconnect to your database.
 +
 +
===Where to get SQL Server Management Studio===
 +
*With SQL 2016, the Management Studio application is now a completely separate stand-alone product from the SQL Server database engine.
 +
 +
*SQL Server Management Studio '''2016 is compatible with all versions''' of SQL Server and can be downloaded at the link below:
 +
**https://msdn.microsoft.com/en-us/library/mt238290.aspx
  
 
==MyLittleAdmin==
 
==MyLittleAdmin==

Latest revision as of 23:10, 16 December 2016


SQL Server Management Studio

  • Use the following steps to log into your MS SQL database using SQL Server Management Studio
  1. Log into the WCP and click "MS SQL"
  2. Copy the server listed for your database. For example: "sql1.hostek.com"
  3. Open SQL Management Studio
  4. Paste the server you copied from step 2 into the "Server name" field
  5. Set "Authentication" to "SQL Server Authentication"
  6. Enter the database username and password and click "Connect"
  • You can also hide the system objects in SQL Management Studio by using the following steps:
  1. Click "Tools"
  2. Select "Options" from the menu
  3. Click "General" under "Environment"
  4. Check the box for "Hide system objects in Object Explorer" and click "OK"
  5. Restart SQL Management Studio and Reconnect to your database.

Where to get SQL Server Management Studio

  • With SQL 2016, the Management Studio application is now a completely separate stand-alone product from the SQL Server database engine.

MyLittleAdmin

  • Use the following steps to log into your MS SQL database using MyLittleAdmin
  1. Log into the WCP and click "MS SQL Tools"
  2. Select your database and user
  3. Click "MyLittleAdmin"