AvailSuite - Service Management Software
SERVICES  |  ORDER  |  SUPPORT  |  CONTACTS  |  WHAT'S NEW  |  IN THE PRESS  |  TESTIMONIALS  |  PARTNERS  |  ABOUT
 
Click to expand or collapse folderFolderKnown Issues
This page is the part of the AvailSuite online help.

AvailSuite is a software solution for managing a small or medium service business. It covers all critical activities of small companies, like customer and work order management, invoices and account receivables, employee scheduling, and task management.
How to find out the name of MS SQL instance installed on your computer?

Advanced users may decide to install AvailSuite into existing SQL Server (or MSDE) instance for some reasons. To see the instances installed on your computer, do the following

  1. Check the list of Windows Services
    1. Open the Control Panel (Start->Control Panel).
    2. Open Administrative Tools and then Services.
    3. Review the list of services, sort them by name if necessary.
    4. Find the service MSSQLSERVER, check that it is started
    5. If you have no services with the name but have a service called like MSSQL$SOMETHING with some word instead of 'SOMETHING', you have MS SQL/MSDE installed not as a local instance, but as instance named 'local/something'. In the case, if you want to use this instance, you can't use AvailSuite default installation but should use the Custom Setup option and should provide the name of your server (like 'local/something') where AvailSuite Setup will ask for this.
    6. If your MSSQLSERVER instance (or similar instance from Step e) is not started, try to start it using an appropriate button on the toolbar or a popup menu appearing by the right-click on the service name. If the start fails, the service is corrupted. Contact your administrator to safely re-install or repair MS SQL/MSDE.
    7. If your MSSQLSERVER instance (or similar instance from Step e) was not started but you successfully started it, check properties of the service. Properties of MSSQLSERVER service (or another service, see Step e) can be viewed by clicking on a corresponding button on the toolbar or using or a popup menu appearing by the right-click on the service name. On the form displayed, see the tab General and check that the startup type is set as Automatic. If not, change the startup type to Automatic.
  2. Check Windows folders named like “C:\Program Files\Microsoft SQL Server\”, “D:\Program Files\Microsoft SQL Server\” or another folder where MS SQL/MSDE could be installed
    1. One of these folders must contain a subfolder called MSSQL.
    2. If so, you have a default MS SQL/MSDE instance.
    3. If not, it must contains something like MSSQL$SOMETHING with some word instead of 'SOMETHING'. In the case, you have a non-default instance of MS SQL/MSDE. See Step 1e.