How to Configure Microsoft SQL Server Express for AYS

SQL Server Express can be used instead of larger deployments of SQL Server, depending on your company’s requirements.

Database configuration and setup described in this article can be followed, but by default, the server is not accessible over the network. Follow these steps to make the server visible so that you can connect to and configure the server from another workstation on the network.

Note: At Your Service Software, Inc. will not provide support for installing or administering SQL Server on your hardware and network. Please consult a local IT service provider and/or Microsoft for this service.

How to Configure Microsoft SQL Server 2012 R2 for AYS

Certain SQL Server permissions are necessary for AYS users to access the data and run reports.  This article will assist you in configuring the security on Microsoft SQL Server 2012 R2.

Note: At Your Service Software, Inc. will not provide support for installing or administering SQL Server on your hardware and network. Please consult a local IT service provider and/or Microsoft for this service.

How do I install the AYS Internet Utility as a service?

By default, the AYS Internet Utility runs as a stand-alone application, however it may also be installed as a Windows service running in the background. A service is advantageous in that it continues to run even if no user is logged in to the server or workstation.

If users are accessing the database by means of Remote Desktop services then it is recommended that the AYS Internet Utility be installed on the same server. Otherwise, if working with a Microsoft Access database, then it is recommended that the AYS Internet Utility be installed on the same physical machine that is hosting the AYS database.

There are two steps to installing the AYS Internet Utility as a service. First, the program must have sufficient rights to install, uninstall, and manage Windows services. Second, the service must be installed and then started.