{"id":733,"date":"2019-10-04T13:56:21","date_gmt":"2019-10-04T12:56:21","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=733"},"modified":"2026-05-12T13:20:37","modified_gmt":"2026-05-12T12:20:37","slug":"using-sql-server-management-studio","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/sql-server\/using-sql-server-management-studio\/","title":{"rendered":"Using SQL Server Management Studio"},"content":{"rendered":"\n

Note that you need to be using a computer on the University network, or be connected to the virtual desktop<\/a> in order to access the SQL Server<\/p>\n\n\n\n

Connecting to your database<\/strong><\/p>\n\n\n\n

    \n
  1. Open up SQL Server Management Studio<\/li>\n<\/ol>\n\n\n\n
      \n
    • For ‘Server type’ ensure ‘Database Engine’ is selected.<\/li>\n\n\n\n
    • For ‘Server name’ select ‘sql-server’.<\/li>\n\n\n\n
    • For ‘Authentication’ select ‘SQL Server Authentication’ <\/li>\n\n\n\n
    • Enter your username and SQL Server password in the ‘Login’ and ‘Password’ boxes. Your SQL Server password will be issued to you at a support desk, or from your lecturer.<\/li>\n\n\n\n
    • Ensure the “Trust server certificate” tickbox is ticked<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Then press the “Connect” button to connect. If prompted to change your password then do this.<\/p>\n\n\n\n

      2. Once you have connected to the server expand the ‘Databases’ node to see a list of all the databases on that instance.<\/p>\n\n\n\n

      3. Scroll down until you find your database (your user ID). Expand this node and you will see a list of folders as shown in the image below.<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Creating a table<\/strong><\/p>\n\n\n\n

      1. To create a table expand the tables node, right-click ‘Tables’ and click ‘New Table’:<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      2. Enter the column names and data types you want in your table then under ‘Properties’ in the ‘Identity’ section, for the ‘(Name)’ value enter a name for your table, save the changes you have made to create the table, then close it.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Running queries<\/strong><\/p>\n\n\n\n

      1. To run queries against your database, right-click on your database (your username then click ‘New Query’.<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      2. This will bring up a window for writing SQL statements, write your SQL in the window then click the ‘Execute’ button. This will run the code and the results will be shown in the ‘Results’ window below. <\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"

      Note that you need to be using a computer on the University network, or be connected to the virtual desktop in order to access the SQL Server Connecting to your database Then press the “Connect” …<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":130,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-733","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=733"}],"version-history":[{"count":2,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/733\/revisions"}],"predecessor-version":[{"id":2509,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/733\/revisions\/2509"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/130"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}