Connecting to Database - MS SQL

From Hostek.com Wiki
Revision as of 07:18, 14 August 2012 by Carlb (Talk | contribs) (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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQL Management Studio

  • Use the following steps to log into your MS SQL database using SQL 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"

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"