Unable to connect to the Veeam ONE Monitor database ?

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby albertwt » Mon Dec 08, 2014 1:14 am

Hi people,

Can anyone here please assist me in troubleshooting the problem to access the Veeam ONE Monitor database and also to get the email alerts which was suddenly stopped overnight ?

From the Veeam ONE window application, the bottom of the application (status bar) says that Monitor Server Database: \ (disconnected) while the Service: Servername.domain.com (connected) ?

The top of the application displays Configuration Issue (1 detected) [-] SQL Server connection failure.

The following pop up error message was displayed:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed: SQLState: '01000' SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed: SQLState: '08001' SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
---------------------------
OK
---------------------------
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby albertwt » Mon Dec 08, 2014 1:25 am

I have verified thatthere were no SQL Server Express 2005 service that was stopped, all up and running as expected with no error logged in the Event viewer apart from the following log:

Log Name: Application
Source: Veeam ONE Reporter Server
Date: 8/12/2014 10:52:51 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: PRODMON1.domain.com
Description:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)


The SQL Server isin the same Windows server 2008 R2 itself, I havechecked that the disk space used by the SQL Server is not above 4 GB.
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby albertwt » Mon Dec 08, 2014 1:27 am

Accessing the Veeam ONE monitor page locally from within the server RDP connection also gives me the error below:

Code: Select all

2014-12-08 11:04:44,954 [310] ERROR ResourceLibraryHandler [(null)] - System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DBReporter.DataAdapters.SqlConnectionExt.OpenConnection()
   at DBReporter.DBClasses.DBProviderRS.GetParameterTypes(SqlConnection sqlConn, SqlTransaction transaction)
   at UserContext.get_ParameterTypes()
   at ResourceLibraryHandler.ProcessRequest(HttpContext context)
   
2014-12-08 11:04:44,959 [310] ERROR ResourceLibraryHandler [(null)] - System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DBReporter.DataAdapters.SqlConnectionExt.OpenConnection()
   at DBReporter.DBClasses.DBProviderRS.GetReportDefinitionWidgets(Nullable`1 reportDefinition, SqlConnection sqlConn, SqlTransaction transaction)
   at DBReporter.DBClasses.DBProviderRS.GetReportDefinitionWidgets()
   at ResourceLibraryHandler.ProcessRequest(HttpContext context)
   
2014-12-08 11:04:44,964 [310] ERROR ResourceLibraryHandler [(null)] - System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DBReporter.DataAdapters.SqlConnectionExt.OpenConnection()
   at DBReporter.DBClasses.DBProviderRS.GetResourceLibraryHotFixes(Byte resourceType)
   at ResourceLibraryHandler.ProcessRequest(HttpContext context)
2014-12-08 11:04:44,966 [310] DEBUG Global [(null)] - url=/ResourceLibraryHandler.ashx?proxy&javascript=1, status = 200 OK, requestTime=00:00:00.0700084



Can anyone here please share your knowledge in troubleshooting the problem above ?

Thanks,
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby Shestakov » Mon Dec 08, 2014 9:02 am

Hello Albert,
Have you contacted Veeam technical support?
Please provide support case # as required by forum`s rules when posting a question about errors.
Thanks.
Shestakov
Veeam Software
 
Posts: 4863
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby Vitaliy S. » Mon Dec 08, 2014 9:18 am

Can you connect to the SQL Server with Veeam ONE credentials from the Windows server hosting Veeam ONE service?
Vitaliy S.
Veeam Software
 
Posts: 19566
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby albertwt » Mon Dec 08, 2014 9:27 am

Shestakov wrote:Hello Albert,
Have you contacted Veeam technical support?
Please provide support case # as required by forum`s rules when posting a question about errors.
Thanks.


Yes I have, Case # 00697419
but I cannot send the logs through email attachment due to the attachment size 12 MB restrictions
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Unable to connect to the Veeam ONE Monitor database ?

Veeam Logoby Shestakov » Mon Dec 08, 2014 9:43 am

Thanks Albert.
Support engineers can create FTP server for you to send the attachments.
Shestakov
Veeam Software
 
Posts: 4863
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 4 guests