I have version 2024.4.0 and Netflow
I need to create a report with a custom table or custom graph using SQL. Both methods fail when attempting to hit the Netflow Database
I'm trying to query my NetFlow database but keep getting a message that indicates the query is invalid.
A basic query to the Orion database works.
Select top (5) NodeID FROM dbo.nodes
A basic query to the FlowStorage data base fails.
Select top (5) NodeID FROM dbo.netflowflows
I have tried brackets on the dbo and table as well as including the database name in the query and nothing is working
The orionweblog indicates a permission issue but these queries all run fine when they are done through database manager. Database manager connects to the DB's with the same Orion account(my understanding at least).
Due to limitations with SWQL I am not able to utilize that method.
Does anyone know what could be blocking my query to the netflow database when building a report?
Information from the orionweb log
Parameters:
System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: Orion.Reporting.ExecuteSQL failed, check fault information.
Error executing SQL: The server principal "S-1-9-3-3800204312-1075515340-1938578833-2071681529" is not able to access the database "SolarWindsFlowStorage" under the current security context. (Fault Detail is equal to InfoServiceFaultContract, ErrorCode=00000032, UserMessage='Error executing SQL' [ SolarWinds.Data.Providers.Orion.Common.VerbException: Error executing SQL: The server principal "S-1-9-3-3800204312-1075515340-1938578833-2071681529" is not able to access the database "SolarWindsFlowStorage" under the current security context. ---> System.Data.SqlClient.SqlException: The server principal "S-1-9-3-3800204312-1075515340-1938578833-2071681529" is not able to access the database "SolarWindsFlowStorage" under the current security context.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataRe...).
2024-12-13 14:53:20,218 [579] (29) ERROR SolarWinds.Orion.Core.Reporting.DataTableQueryBase - (null) Errored query dataSource: Datasource 1/93f0292e-88c6-4456-a9eb-ff47b744afa2 Query:Command:SELECT TOP (5) NodeID FROM [SolarWindsFlowStorage].[dbo].[NetFlowFlows]
Last thing to mention. I have another SW instance on version 2020.2.6 and this all works fine there, no issues.
