Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

"Unsuccessful database operation" error appears when logging in to the Control Manager (TMCM) console

    • Updated:
    • 24 Mar 2014
    • Product/Version:
    • Control Manager 6.0
    • Platform:
    • Windows 2008 Standard 64-bit
Summary
The following error message appears when you log in to the TMCM console:
Unsuccessful database operation log in error
"Unsuccessful database operation. Please check the database status and try again."
The issue occurs in the following environment:
  • TMCM 6.0 Patch 4 EN
  • Windows 2012 R2
  • SQL Express 2012
When you check the debug logs, it shows the following errors:
provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol

=========================================================

2013-12-18 18:08:21,449 61351 [8] ERROR - Cannot validate the username(admin). [0]

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

2013-12-18 18:39:07,654 52505 [8] ERROR - Cannot validate the username(admin). [0]

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)

     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

=========================================================
Details
Public
To resolve the issue:
  1. Make sure that the server and instance name are spelled correctly.
  2. Configure the SQL Server Browser Service.
    1. Go to Start > All Programs > Configuration Tools > Microsoft SQL Server 2012 > SQL Server Configuration Manager > SQL Server Services.
    2. Right-click on SQL Server Browser and then select Properties.
    3. On the SQL Server Browser Properties window, go to the Service tab and set Start Mode to Automatic and then click Apply.
    4. Go back to the SQL Server Browser Properties window and go to the Log on tab.
    5. Under the Log on as section, select Built-in account and then choose Local Service from the drop-down menu.
    6. Click Start to start the service and click OKto close the SQL Server Browser Properties window.
      Note: You can also use another account for SQL Server Browser Service. To know more about service accounts, refer to the Microsoft article: Service Account (SQL Server Express).
  3. Enable TCP/IP Protocol to allow SQL Server Express to accept remote connection.
    1. Go back to the SQL Server Configuration Manager window and expand SQL Server Network Configuration.
    2. Select Protocols for SQLEXPRESS and under Protocol Name right-click TCP/IP then click Enable.
    3. Restart the SQL Server for the changes to take effect.
      1. On the SQL SQL Server Configuration Manager window click SQL Server Services.
      2. Under Name, right-click SQL Server (SQLEXPRESS) and then select Restart.
  4. Set the Windows Firewall to allow SQL Server remote connection.
    1. Note down the executable paths of the SQL Server and SQL Server Browser.
      1. On the SQL Server Configuration Manager window, right-click SQL Server (SQLEXPRESS) and choose Properties.
      2. Go to the Service tab and note down the Binary Path. You will use this later. By default, the binary path of the SQL Server is C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Binn\sqlservr.exe.
      3. Go back to the SQL Server Configuration Manager window and right-click SQL Server Browser.
      4. Note down and save the binary path of the SQL Server Browser. By default, the path is C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe.
    2. Open Windows Firewall by going to Start > Control Panel > Network and Internet > Network and Sharing Center.
    3. On the lower left corner of the screen, select Windows Firewall and click Allow a program or feature through Windows Firewall.
    4. Click Change Settings and then click Allow another program.
    5. On the Path field, enter the binary path of SQL Server Express that you saved earlier and click Open. The SQL Server is added to the program list. Click Add to save the SQL Server to the Windows Firewall Allowed List.
    6. On the Allowed Programs window, click again Allow another program to add the SQL Server Browser to the program list.
    7. On the Path field, enter the binary path of the SQL Server Browser that you saved in Step 4a and click Add. The SQL Server Browser is now added to the Windows Firewall Allowed List.
    8. Test the remote connection to SQL Server 2012 Express to check if it is working properly.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot
Solution Id:
1101710
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.