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.

 

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