MSSQL Server

On our Faculty Microsoft SQL Server is available in versions 2016 Enterprise and 2008 R2 SP2.

Microsoft SQL Server Management Studio is a good tool for interactive work with both of those versions, and it is installed on every computer in the laboratories.

Microsoft SQL Server 2016 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

To connect, into Server name: field enter localhost and set Authentication: to 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 2016 R2 SP2 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 server

To connect you have to choose File, then Open and then Analysis Services Database.... Next, into Server name: field enter mssql-2016.labs.wmi.amu.edu.pl and choose your database. Access to server is possible only from faculty's network. Outside of a Faculty access may be gained using 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.