How to Solve “Cannot open database (MS SQL Server) requested by login. The login failed”

Applies to:

  • MOBITEK SMS Engine version 5, 6, 7
  • SQL Server Express
  • Windows Server 2012 R2

Error Message: [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database “smseee6” requested by the login. The login failed.

Solution:

  1. Add “db_owner” to the user;
  2. If problem remains unsolved, then enable “TCP/IP” in SQL Server Configuration Manager.

How to Add “db_owner”

  1. select the user -> Properties
  2. goto “User Mapping”, select the database (smseee6) then check “db_owner”

Source: https://blog.sqlauthority.com/2009/08/20/sql-server-fix-error-cannot-open-database-requested-by-the-login-the-login-failed-login-failed-for-user-nt-authoritynetwork-service/

How to Enable “TCP/IP”

  1. Launch the SQL Server Configuration Manager. It should be in the Start -> Programs -> Microsoft SQL Server -> Configuration Tools, select “Protocols for SQLEXPRESS” and enabled “TCP/IP”.
  2. In “TCP/IP -> Properties”.
  3. In “TCP port”, ensure it is the correct port number 1433.
  4. Restart the servce.

Source: https://razorsql.com/docs/support_sqlserver_express.html

MobiGATE: Monitor Your SMS Gateway (Modems) on Your Desktop

MOBITEK MobiGATE is a SMS Gateway (also refer as a modem pool or SMS channel) used for SMS broadcast. It supports 8 modems (SIM cards) and more.

Problem arises when there are too many modems to monitor and no centralised tool to assist.

The solution is a tool called “Control Panel”.

“Green” when modem is running; “Orange” when modem is disabled

"Red" when modem is stopped or disconnected

We are pleased to announce version 2.5 of Control Panel.

 

Features of Control Panel version 2.5

  • GUI tool to edit the “config.xml”  (configuration file for MOBITEK SMS Engine — Enterprise Edition). Previously, notepad is being used to edit the configuration file;
  • supports SMS Engine — Enterprise Edition version 6 and 7 (version 5 is NOT supported);
  • to start and stop the service of SMS Engine;
  • to monitor up to 16 modems or more;
  • to view log file without the need of opening notepad

 

More Information

 

Download

Existing customer may write to customer support team for a copy of the installer.

 

Edit “config.xml” File Using Control Panel for SMS Engine — Enterprise Edition

Control Panel for SMS Engine — Enterprise Edition

We are pleased to announce the release of version 2.4.1 of Control Panel for SMS Engine — Enterprise Edition.

MOBITEK® SMS Engine — Enterprise Edition

The SMS Engine used by MOBITEK MobiGATE model SG-B series.

MOBITEK® MobiGATE SG-B-8 SMS Gateway

 

Benefits

  1. A GUI tool to edit the “config.xml”  (configuration file for MOBITEK SMS Engine — Enterprise Edition). Previously, notepad is being used to edit the configuration file.
  2. To monitor the status of each modem.

 

User’s Guide

Please refer to https://www.mobitek.my/main/software-development-kit/users-guide-for-control-panel-version-2-4-for-sms-engine-enterprise-edition/

 

Download

Existing customer Please download the installer from https://www.mobitek.my/main/software-development-kit/users-guide-for-control-panel-version-2-4-for-sms-engine-enterprise-edition/#DOWNLOAD_THE_INSTALLER

How to Solve the Problem of VCOM is Connected But SMS Engine Fails to Initialized

Applies To:

  • MOBITEK MobiGATE Model SG-B series
  • MOBITEK SMS Engine — Enterprise Edition version 5, 6 and 7

Problem:

  1. Despite blue LED of MobiGATE is blinking (connected to mobile network), the log file of SMS Engine shows “Modem ID 1 : failed to initialize” or Modem ID 1 has no response in the hyper terminal; and
  2. VCOM shows NET Status is “Connected” and COM Status is “Open”.

Solution:

Configure the baud rate of all modems in MobiGATE to “115200”.

  1. Open web browswer, key in the IP address of MobiGATE.
  2. Goto left side of navigation bar, select “Async”, to display “Port1”, “Port2”, … “Port8”.
  3. Goto “Port1”, set the “baudrate” to “115200”, check the box “Apply to all” and “Submit”. This will make all ports (modems) to have the same baud rate at “115200”.
  4. Next goto “Save Config” then click “Save” button.

 

 

 

MOBITEK MobiGATE is a SMS Gateway Having 8 Ports Modem Pool

MOBITEK MobiGATE SG-B-8

MOBITEK MobiGATE SG-B-8

MOBITEK® MobiGATETM is a SMS gateway having 8 ports modem and has these additional features and benefits:-

  1. allows your system (ERP, CRM, SCM) and software application (mobile commerce, e-commerce) to send and receive SMS;
  2. most reliable SMS gateway that is widely used in Malaysia, Philippines and Nigeria;
  3. reputable SMS gateway that is featured in Matrade’s Magazine “What’s New from Malaysia”.
  4. cost effective: there is no monthly charge
  5. broadcasting: all channels simultaneously sending out SMS;
  6. routing: use the lowest SMS rate to send out SMS;
  7. load balancing: speed-up the broadcast as work load is shared by all channels;
  8. fail-over: when 1st channel fails, 2nd channel will be used to send out SMS; reduce broadcast failure;
  9. data security: all messages and mobile numbers are stored in your local database and not with any 3rd party SMS gateway service provider;
  10. scalable: increase the units of MobiGATETM  without changing a single line of code.

MOBITEK® MobiGATE SG-B-8 SMS Gateway

 

How to Solve VCOM “Progressing” Problem

Applies to these models:

  • SG-B-8-L
  • SG-B-8-L-W
  • SG-B-4-L
  • SG-B-4-L-W

Problem: VCOM shows “Progressing” (pic) for more than 30 minutes after click on “add” button.

Solution: uninstall “VirtualBox Host-Only Ethernet Adapter”

Refer pictures below on how to uninstall “VirtualBox Host-Only Ethernet Adapter”.

  1. Right click on “VirtualBox Host-Only Ethernet Adapter”, then click uninstall
  2. Click OK

Note: after it is uninstalled, and VCOM is working, “VirtualBox Host-Only Ethernet Adapter” can be re-installed.

Refer pictures below on how to re-install “VirtualBox Host-Only Ethernet Adapter”.

  1. Run VirtualBox Installer as shown as “VirtualBox-5.1.28-117968-Win.exe”
  2. Click Run
  3. Click Next,
  4. Click Repair,
  5. Click Repair.
  6. After the installation finished, the “VirtualBox Host-Only Ethernet Adapter” will be appeared in Device Manager