SQL Connection with OSM show: run-time error 2147217843 login failed

Question

Hi MS SQL Support:

This is AHAsoft engineer, Johnson.

I installed latest OSMonitor, V10.3.20 to user's PC today on 6/10.
OSMonitor official site:
https://www.os-monitor.com/

Because the OS of PC is Win 7 Pro, I download SQL 2014, link as below:
https://www.microsoft.com/zh-tw/download/details.aspx?id=42299

And I installed the below programs of SQL 2014:

1. Express 64BIT\SQLEXPR_x64_CHT.exe
2. LocalDB 64BIT\SQLLocalDB.msi
3. MgmtStudio 64BIT\SQLManagementStudio_x64_CHT.exe

I selected "Mixed Mode Authentication" during install SQL 2014 express, and user type in her password.
Finally the three programs installed successfully, and then user reboot the PC.

I open SQL Server Initial app of OSMonitor as the system administrator for create SQL server database.
Enter the Server name of SQL 2014 Management Studio, and user type the password (the customer confirms that the password is completely correct), but an error message will appear when create SQL server database !!

Run-time error '.2147217843 (80040e4d)'

Beside, user have been installed SQL 2005 in the PC.

User's supervisor hopes to install the OSM connect SQL server successfully at 6/11 17:00 Taiwan time zone.
So I create this case, and hope MS SQL experts could quickly troubleshoot & provide fix solutions.

Really thank you very much in advanced.

Answer 1

First of all, I'm entirely unacquainted with OSMonitor.

Enter the Server name of SQL 2014 Management Studio, and user type the password (the customer confirms that the password is completely correct), but an error message will appear when create SQL server database !!

There is no server name listed in the screen shot?

You say that the user types her password, but in the screenshot, sa given as the user. sa is the special superuser in SQL Server with all the powers.

Or did you mean to say that she also entered her password when you installed SQL Server, so this her password would be the same as for sa? Maybe she typed in wrong on one of the occasions?

A better choice anyway, would be to use Windows authentication. You should have entered her as the admin user when running Setup. With Windows authentication, you don't need any passwords.

Also make sure that you are connecting to the correct instance and not that old SQL 2005 instance.

Answer 2

Hi Erland

Sorry for update loate.

I already solve this problem by removed old SQL 2005 & 2014, and then reinstall SQL 2012 express SP4.
However I installed the version of SQL 2012 was "Express with Tools", which contains all tools, includes localDB & Management Studio.
So I didn't installed localDB & Management Studio again.

I think that's the reason why it occurred login fail in SQL 2014, because I installed three programs of SQL 2014 separately.
But I don't know how to combined them together, and Management Studio could not recognized the ID/PW of SQL 2014 express database,

Anyway, the problem have been solved.
Share the experience for all user who have this same problem in the future.

Really appreciate for Erland's reply & handling sincerely.