MSSQL Server relational databases

On our Faculty Microsoft SQL Server is available in version 2017.

Microsoft SQL Server Management Studio is a good tool for interactive work and it is installed on every computer in the laboratories.

Microsoft SQL Server 2017 Enterprise in laboratories

Every user has a possibility to use for testing purposes a local instance of SQL Server Enterprise, which is installed on every computer in the laboratories.

By default server is disconnected. During SQL Management Studio startup service is automatically launched. Beside that, located in a Start Menu are shortcuts serving for manual management of server's state.

Connecting to a server

  • Server name: localhost
  • Authentication: Windows Authentication

Remember that databases created on a given computer are located only there and are deleted everyday.

Database deletion

Databases on a local SQL sever are deleted by the end of a day.

Microsoft SQL Server 2017 as an independent server

Users have a possibility of obtaining a database on a faculty's MSSQL server.

Database can be obtained by any user or project group after submitting a ticket at helpdesk containing:

  • domain login of person responsible
  • proposed, non-trivial database name (example of a bad name: pro2010)
  • database access mode: SQL authentication (username/password) or Windows (only from computers in the LABS domain)
  • if database is to exist longer than one semester, proposed database's lifespan
  • possibly domain logins of remaining members of project team

Connecting to the relational database using Microsoft SQL Server Management Studio

  • Server type: Database Engine
  • Server name: mssql-2017.labs.wmi.amu.edu.pl
  • Authentication: Windows Authentication

Access to server is possible only from a computer in the LABS domain. Outside of a Faculty access may be gained using a terminal server or connecting via VPN.

Databases deletion

Databases will be deleted after expiration date. By default this term amounts to one semester. There is a possibility of extending it. Before deletion, person responsible for a databasse will be notified by mail.