S10000 Cannot open database

Last Modified

Mon Dec 05 13:35 GMT 2022

Description

After a migration or reattaching databases, you may receive the following error when running "Test Connectivity" via the N-able Report Manager Admin Console > N-able N-central Configuration. This will prevent Export/ETL and data from reaching your reports.

Test connectivity results:

s1: State : S1000 Message : Cannot open database "ods_ncentral_ds1" requested by the login. The login failed. Error : 4060State : 28000 Message : Login failed for user 'login_nmwsjghs'. Error : 18456

You would also see this error in the export.log. This is found by logging into N-central's UI with the product admin account or system level account and from the System level go to - Administration Utilities - View logs. Search for the export.log and download it.

ERROR - 2013-06-17 04:57:52,008 [main ] nable.export - setupExportDB SQLException

java.sql.SQLException: Cannot open database "ods_ncentral_ds1" requested by the login. The login failed.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

Environment

N-able Report Manager 4.x

Solution

This can be resolved by updating the login_nmwsjghs (ExportUser used by N-able N-central) to 'sysadmin' permission.

Open MS SQL Management Studio > Click "Security" > "Logins" > Right-Click the username from the error message (e.g. "login_nmwsjghs") > Choose "Server Roles" > checkmark "sysadmin" > OK. Then, restest and all will be well!

Test Connectivity Results:

n-central.examplecompany.com - ods_ncentral_ds1: OK