The instructions on this page are for the School’s SQL Server (hostname: sql-server.gre.ac.uk).<\/p>\n\n\n\n
If you do not have a SQL Server database you will need to visit the support counter in lab KW116 or email\u00a0cms-support@gre.ac.uk<\/a>\u00a0to get a database created.<\/p>\n\n\n\n Each database is named by user name, so for example if ‘rk902’ is your user name then ‘rk902’ will be the name of your database. If for any reason you can’t access your database please email\u00a0cms-support@gre.ac.uk<\/a>. Using SQL Server Management Studio<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":" The instructions on this page are for the School’s SQL Server (hostname: sql-server.gre.ac.uk). If you do not have a SQL Server database you will need to visit the support counter in lab KW116 or email\u00a0cms-support@gre.ac.uk\u00a0to …<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":43,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-130","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/130","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=130"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/130\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Each student is given db_owner role for the database which means you are able to create and delete tables, views, diagrams and stored procedures and grant and deny object permissions.
For examples of connect strings for PHP, ASP and ASP.NET etc please see the relevant pages in the\u00a0programming<\/a>\u00a0section.<\/p>\n\n\n\nHelpful links<\/h2>\n\n\n\n
Changing your SQL Server password<\/a>
<\/a>Microsoft SQL Server help<\/a> <\/p>\n\n\n\n