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.

 

Both AirCard Watcher and SMS360-Email Can Run at The Same Time

Both AirCard Watcher and MOBITEK SMS360-Email were started from 2018-7-17, 3:51 pm until 2018-7-18, 3:51 pm

During this time, AirCard Watcher is connected to 3G network with mobile data enabled.

Result: MOBITEK SMS360 E-MAIL is working, able to convert e-mail to outgoing SMS. Both AirCard Watcher and MOBITEK SMS360-Email were able to run at the same time.

START:

END:

MOBITEK SMS360 E-MAIL is working, able to convert e-mail to outgoing SMS.                     SMS is received:-

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.