You can install Management by Statistics on a single computer. Install the client and server software on the same computer. The server software should be installed first, then the Management by Statistics software.

1. Use the following settings in the Management by Statistics Software:
   
   

   Server: ComputerName\MBSDATAEXPRESS
   Port: <Blank>
   Authentication: Windows Authentication
   Database: MBSData

2. If the above doesn't resolve the connection problem, check that the database software is running (SQL Server).
   
   To check if it is currently running do:
   
   
   1. Open the Windows Services Utility.
      Windows XP/Windows Server 2003: Click Start > Administrator Tools > Services.
      Windows Vista: Click Start > Administrator Tools > Services or it can be found in the Control Panel.
      Windows 7/Windows Server 2008: Click Start > Administrator Tools > Services or it can be found in the Control Panel.
      
      
   2. Scroll down and find SQL Server (MBSDATAEXPRESS). It should say Started. If not do the following:
         i. Right click on SQL Server (MBSDATAEXPRESS) and select Properties. Set the Startup type: to Automatic. This instructs the computer to run this service automatically every time the computer is started.
         ii. Right click on SQL Server (MBSDATAEXPRESS) and select Start.
      
      

Because of the number of security measures existing in computers, any of which can prevent connections from correctly occurring, there are significantly more trouble shooting options to check.

Connection Settings

1. Use the connection settings as they are displayed in the Database Manager. These will look like the settings below:
   
   Server: ServerComputerName\MBSDATAEXPRESS
   Port: <Blank> (NOTE: This can be a number specified on the server)
   Authentication: Database Authentication
   Database Password: <Password you entered into the Mastertech Database Manager>
   Database: MBSData
   

If you have forgotten the Database Password, you can reset it in the Mastertech Database Manager under the Connections tab.

If you still cannot connect from the client to the server, there is a list of error messages below with common causes of each.

Error Messages - Symptoms

• Login failed for user 'MBSUser'.
  
  
  1. Ensure the server portion of the Management by Statistic software has been installed and the Mastertech Database Manager has been run. This creates the data files (database) on the server where your data is stored.
     
     
  2. The database password entered is incorrect. You can reset this password if you are an administrator user on the server computer. Run the Mastertech Database Manager on the server. Go to the Connections tab and click on the Reset Database Password button to change the database password. The database password is the same for all computers.
     
     
  3. The database has been taken off-line and will need to be brought back online before it will allow connections. To check this, run the Mastertech Database Manager and go to the Database tab.
     
     
  4. The database has been placed in Restricted Mode so that it can be restored from a backup. The database needs to be placed in Multi User Mode before it will allow connections. To check this, run the Mastertech Database Manager and go to the Database tab.
     
     
• A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
  
  
  1. The database may be Offline. On the server, run the Mastertech Database Manager. Under the Database tab check the status of the database. If it is offline, bring it online by clicking the Bring Online button.
     
     
  2. The database software, SQL Server (MBSDATAEXPRESS), is not running on the server.
     
     To check if it is currently running, open the Windows Services Utility.
     
     Windows XP/Windows Server 2003: Click Start > Administrator Tools > Services.
     Windows Vista: Click Start > Administrator Tools > Services or it can be found in the Control Panel.
     Windows 7/Windows Server 2008: Click Start > Administrator Tools > Services or it can be found in the Control Panel.
     
     Scroll down and find SQL Server (MBSDATAEXPRESS). It should say Started. If not, right click on SQL Server (MBSDATAEXPRESS) and select Properties. Set the Startup type: to Automatic. This instructs the computer to run this service automatically every time the computer is started. Next, right click on SQL Server (MBSDATAEXPRESS) and select Start.
     
     
  
  
• Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
  
  
  1. Windows Authentication uses your Windows User and Password to verify that you have access rights. However, if the client computer and the server computer are not part the same domain controlled by a Windows Server (such as, Windows Server 2003 or 2008), then the Windows User and Password you use on the client computer have no validity on the server computer.
     
     The solution is to use Database Authentication and enter the Database Password. If you have forgotten the Database Password, click the following link: Resetting the Database Password.
     
     
  
  
• Login failed for user 'MBSUser'. Reason: The account is disabled.
  
  
  1. The database user 'MBSUser' has been disabled on the server.

  The Mastertech Database Manager does not provide a means of disabling this user, however, you can enable it by resetting its password. Use the following link for instructions: Resetting the Database Password.

  
  
• Cannot open database 'MBSData' requested by login. The login failed.
  Login failed for user 'Windows User Name'.
  
  

  The windows user shown in the error message does not have permission to access the database on the server.

  1. A Windows server needs to grant access to it for users on the network. Each server controls which network users can gain access.

     If a Windows user does not have permission to access the server, the above error message is generated.

     The solution for this is to grant permission to access the server for the appropriate group of users. Do the following:

     1. On the server go to “Administrative Tools”, then open “Local Security Settings”, then open “Local Policy”. Next open “Access this computer from the network”.
     2. This displays which users and groups of users are authorized to access the server from the network. Click on “Add User or Group” to grant access to the server.
  
  
• A network-related or instance-related error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
  
  
  1. Is server computer turned on?
     
     
  2. Is server computer connected to your network?
     
     

  3. Is the server computer's firewall preventing connections to SQL Server or the computer?

     Firewalls are designed to limit computer connections and if they are not setup to allow connections to the database software (SQL Server) on the server, then the connection attempt will fail.

     The Mastertech Database Manager automatically enables connections to SQL Server in the Windows Firewall. However, if your server is using another brand of firewall you should follow the procedure at the end of this article, How Computer Connections Work.

  
  
• You are able to connect successfully to the server when you click the Test Connection button, but there is no database listed after you click on the Get List button.
  
  
  1. The database is Offline for some reason. On the server run the Mastertech Database Manager. Go to the Database tab and check the status of the database. Click the Bring Online button if it is Offline. You need to be an administrator of the server to do this.
     
     
  2. The database may have been detached from the server, which is normally done when it is being moved.