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 2016 SP1 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

Birthday Greeting to Ms. Shannon

Dear Shannon,

Wishing you a happy birthday.

May you be like a pansy flower that survives and blooms in the winter.

While others are hibernating, you are still working hard.

While other beauties had withered, you are still blooming.

 

Looking for STK API Sample Codes or STK Engine to Run Reload Transaction?

Looking for MOBITEK® STK API  Sample Codes?

We have uploaded sample codes in VB.net and Java for MOBITEK® STK API version 6.5. You may download from here …

Don’t Want to Write Code? Then Use Engine

You can reduce development time by using  MOBITEK® STK Engine version 4.5. Refer to user’s guide here …

MOBITEK® STK API version 5.0 End-Of-Life

We no longer support version 5, for more information, please read this …

 

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 3.3 of Control Panel has been released.

 

Features of Control Panel

  • 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

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:-

How to Solve “The user name or password is incorrect” Error in Windows 8

Problem: when assessing Windows XP PC from Windows 8 PC, Windows 8 PC always receive an error message “The username or password is incorrect” even though the user name and password is correct and previously Windows 8 PC can access or connect to the Windows XP PC.

Solution: the date and time of Windows XP PC is incorrect, change them to the current date and time.

Managing Your Innovation Portfolio

Innovation Ambition Matrix

  • 3 levels
  • investment ratio: 70%, 20%, 10%

    • core, 70%: optimizing existing products for existing customers
    • adjacent, 20%: expanding from existing business into ‘new to the company’ business
    • transformational, 10%: developing breakthroughs and inventing things for markets that don’t yet exist

 

Source: HBR, May 2012, p.g. 69; https://hbr.org/2012/05/managing-your-innovation-portfolio

Five Components of Emotional Intelligence at Work

  1. Self-Awareness – ability to recognise and understand your moods, emotions, drives as well as their effects on others
  2. Self-Regulation – ability to control or redirect disruptive impulses and moods; the propensity to think before acting
  3. Motivation – passion to work for reasons that go beyond money or status; a propensity to pursue goal with energy and persistence
  4. Empathy – ability to understand the emotional makeup of other people; skill in treating people according to their emotional reactions
  5. Social Skill – proficiency in managing relationships and building networks; ability to find common ground and build rapport

 

Source: Daniel Goleman, What Makes a Leader, Leadership Insights pg. 37