DoC Computing Support Group


Connecting to Microsoft SQL Server databases

Email help@doc.ic.ac.uk to ask us to create you a Microsoft SQL Server database.

By the way, did you know that Microsoft SQL server is amazing similar (you even use the same Perl DBI module to connect) to Sybase?

To connect to MS SQL Server database from a DOC workstation you need to navigate to Programming > Microsoft SQL Server 2008R2 > SQL Server Management Studio Express and choose server DOWITCHER or SERIN (whichever has been specified for you) with SQL server authentication and the login provided. Once connected to the remote database server, you need to select your group's database or your own. You won't be able to access other databases.

For ASP associated website, the URL location is of the form: http://www-asp.doc.ic.ac.uk/databasename/.

In order to upload files to IIS or create a folder structure, you simply need to go to \\SERIN\databasename (case doesn't matter as it is Windows) and save them there; only you or your group has rights to the directory. From outside the campus, if you establish a secure channel via VPN, you can upload files and connect to SQL server on SERIN as if you were on campus. You ll need to install SQL Server Management Studio Express 2005, which is freely downloadable from Microsoft for personal usage, on your private computer.

 
 

guides/databases/mssql (last edited 2014-05-20 17:32:33 by cbosio)