Managed Services for Windows - Shared MS SQL Database Server
Information Technology Services (ITS) offers MS SQL Database Server access to departments via a dedicated, ITS's-hosted SQL Server.
Getting Started
Eligibility:
- To participate in the MS SQL database service, clients must participate in the Windows Application Server program.
- To get started, please contact the IT Support Centre by calling 613.533.6666 or by filling out the online help form.
Applications which require system administrative rights on the SQL server will not be permitted, in order to preserve the security and reliability of other hosted databases.
Additional Information
Information Technology Services (ITS) will:
- House, maintain, and administer the server (create databases, user accounts and database permissions);
- Install, configure, and maintain the server operating system and database server with patches and virus detection;
- Provide power conditioning, cooling, humidity control, fire protection, and physical security protection;
- Backup and restore client databases to/from the server (7 daily versions stored);
- Administer database user accounts;
- Respond to and resolve questions about, problems with, and requests for enhancements to the service from designated client contacts; and
- Provide emergency and after hours service for server level failures. Emergency repair outside of weekday business hours is limited to:
- Coarse level diagnosis of problem to determine cause;
- Reboot server, clear temporary files, etc. to resolve resource shortage or deadlock;
- Substitute locally available spare parts if available;
- Correct minor configuration errors if applicable; and
- Place repair calls with hardware suppliers for next business day.
Cost:
- Please refer to the MS SQL Database entry on the Service Fees page for details.
Service Agreement:
- The Master Service Agreement governs all of the Managed Services for Windows; Appendix D provides additional information specific to Shared MS SQL Database Server.
Related Links:
- Windows Application Server
- Unix Shared Application Server
- Naming Conventions
- Acceptable Use of Information Technology Resources Policy
- ITS's Network and Systems Policies
Help & Support
- Please contact the IT Support Centre by calling 613.533.6666 or by filling out the online help form.