Bij het aanmelden vanuit SQL Server Management Studio naar AccountView op Invantive UniversalSQL Server blijft het programma hangen bij het aanmelden. Het gaat om een on-premises installatie.
Configuration file appsettings.json:
{
"Logging": {
"LogLevel": {
"Default": "Warning"
}
},
//
// Group to configure Invantive UniversalSQL Server.
//
"Server": {
//
// ID.
//
"Id": "d2i-big",
//
// Description.
//
"Description": "appsettings.Production.json on BI gateway server",
//
// Name of the node.
//
"NodeName": "big",
//
// Server host name.
//
"HostName": "big.acme.nl",
//
// Listen IP address (use "*" to listen on all IP-addresses).
//
"TdsListenIpAddress": "*",
//
// Listen port.
//
"TdsListenIpPort": 1433,
//
// Whether the monitor is active.
//
"IsMonitorActive": true,
//
// Monitor IP address (use "*" to listen on all IP-addresses).
//
"MonitorListenIpAddress": "127.0.0.1",
//
// Monitor IP port.
//
"MonitorListenIpPort": 5933,
//
// SSL certificate file name/path.
//
"SslCertificateFileNamePath": "C:\\acme\\acme.pfx",
//
// SSL certificate password.
//
"SslCertificatePassword": "super-secret",
//
// Folder to use for HTTP disk cache for the current user.
//
"UserHttpDiskCacheRootDirectory": "C:\\data\\invantive\\big.acme.nl\\cache\\cache",
//
// Folder to use for HTTP disk cache for publicly available data.
//
"PublicHttpDiskCacheRootDirectory": "C:\\data\\invantive\big.acme.nl\\cache\\public",
//
// Incremental data root directory.
//
"IncDataCacheRootDirectory": "C:\\data\\invantive\\big.acme.nl\\cache\\incdata",
//
// Permanent cache root directory.
//
"PermanentDataCacheRootDirectory": "C:\\data\\invantive\\big.acme.nl\\cache\\permanent",
//
// Maximum age in seconds to allow use data from disk cache.
//
"RetrieveFromDiskCacheMaxAgeSec": 57600,
//
// Maximum age in seconds to allow use data from memory cache.
//
"RetrieveFromHttpMemoryCacheMaxAgeSec": 57600,
//
// Maximum age in seconds to allow storage of data in disk cache.
//
"StoreAnswerInDiskCacheMaxAgeSec": 57600,
//
// Whether to store data in disk cache.
//
"StoreInHttpMemoryCache": false,
//
// Whether to store data in memory cache.
//
"StoreInDiskCache": true,
//
// Whether to run in demo mode.
//
"IsDemoMode": false,
//
// Whether to run in Invantive Cloud mode.
//
"IsCloudMode": false,
//
// Configuration independent from Invantive Cloud.
//
"Local":
{ //
// List of full names of databases to be made available. Before the backslash is the group name, after the backslash the database name.
//
"AvailableDatabases":
[ "USS-acme\\acme-database.acme.nl"
, "USS-acme\\acmetest-database.acme.nl"
, "USS-acme\\dummy-database.acme.nl"
, "USS-acme\\eol-database.acme.nl"
]
//
// Users for non-demo mode.
//
, "TdsUsers":
{ "List":
[ { "LogOnCode": "acme"
, "Password": "secret"
}
]
}
},
//
// Trace and logging options.
//
"TdsTrace": {
//
// Whether to trace TDS as NDJSON.
//
"TdsTraceAsNdJson": false,
//
// Maximum length of TDS trace contents.
//
"MaxTdsTraceContentsLength": 2000,
//
// Whether to log TDS trace text to console.
//
"ConsoleText": true,
//
// Whether to log TDS trace errors to console.
//
"ConsoleError": true,
//
// Whether to log TDS trace protocol to console.
//
"ConsoleProtocol": true,
//
// Whether to log TDS trace row data to console.
//
"ConsoleRowData": true,
//
// Whether to log TDS trace row metadata to console.
//
"ConsoleRowMetadata": true,
//
// Whether to log TDS trace wire messages to console.
//
"ConsoleWire": false,
"ConsolePacketTypeUnknown": true,
"ConsolePacketTypeSqlBatch": false,
"ConsolePacketTypeRpcRequest": false,
"ConsolePacketTypeTabularResult": false,
"ConsolePacketTypeAttention": false,
"ConsolePacketTypeBulkLoad": false,
"ConsolePacketTypeFedAuthToken": false,
"ConsolePacketTypeTransactionManager": false,
"ConsolePacketTypeLogin7": false,
"ConsolePacketTypeSSPI": false,
"ConsolePacketTypePreLogin": false,
//
// Whether to log TDS trace text to Invantive trace.
//
"TraceText": true,
//
// Whether to log TDS trace errors to Invantive trace.
//
"TraceError": true,
//
// Whether to log TDS trace protocol to Invantive trace.
//
"TraceProtocol": true,
//
// Whether to log TDS trace row data to Invantive trace.
//
"TraceRowData": true,
//
// Whether to log TDS trace row metadata to Invantive trace.
//
"TraceRowMetadata": true,
//
// Whether to log TDS trace wire messages to Invantive trace.
//
"TraceWire": false,
"TracePacketTypeUnknown": false,
"TracePacketTypeSqlBatch": false,
"TracePacketTypeRpcRequest": false,
"TracePacketTypeTabularResult": false,
"TracePacketTypeAttention": false,
"TracePacketTypeBulkLoad": false,
"TracePacketTypeFedAuthToken": false,
"TracePacketTypeTransactionManager": false,
"TracePacketTypeLogin7": false,
"TracePacketTypeSSPI": false,
"TracePacketTypePreLogin": false
},
//
// Monitor server users.
//
"MonitorUsers": {
"List": [
{
"LogOnCode": "john",
"Password": "secret"
}
]
},
//
// Elastic APM
//
"ElasticApm": {
"MinLogLevelWriteToTrace": "Warning",
"MinLogLevelFail": "Error",
"Enabled": false,
"ApiKey": null,
"ApplicationNamespaces": [],
"BaggageToAttach": null,
"CaptureBody": "off",
"CaptureBodyContentTypes": [
"application/x-www-form-urlencoded*, text/*",
"application/json*",
"application/xml*"
],
"CaptureHeaders": true,
"CentralConfig": false,
"CloudProvider": "aws",
"DisableMetrics": [],
"OpenTelemetryBridgeEnabled": false,
"Environment": "Development",
"ExcludedNamespaces": [
"System.",
"Microsoft.",
"MS.",
"FSharp.",
"Newtonsoft.Json",
"Serilog",
"NLog",
"Giraffe."
],
"ExitSpanMinDuration": 0.0,
"FlushInterval": "00:00:05",
"GlobalLabels": {},
"HostName": null,
"IgnoreMessageQueues": [],
"LogLevel": 3,
"MaxBatchEventCount": 10,
"MaxQueueEventCount": 1000,
"MetricsIntervalInMilliseconds": 5000.0,
"Recording": true,
"SanitizeFieldNames": [],
"SecretToken": "",
"ServerCert": null,
"ServerUrl": "",
"ServerUrls": null,
"UseWindowsCredentials": false,
"ServiceName": "Invantive UniversalSQL Server",
"ServiceNodeName": null,
"ServiceVersion": "24.1.0-DEFAULT",
"SpanCompressionEnabled": true,
"SpanCompressionExactMatchMaxDuration": 50.0,
"SpanCompressionSameKindMaxDuration": 0.0,
"SpanStackTraceMinDurationInMilliseconds": 5.0,
"SpanFramesMinDurationInMilliseconds": 5.0,
"StackTraceLimit": 50,
"TraceContextIgnoreSampledFalse": false,
"TraceContinuationStrategy": "continue",
"TransactionIgnoreUrls": [],
"TransactionNameGroups": [],
"TransactionMaxSpans": 500,
"TransactionSampleRate": 1.0,
"UseElasticTraceparentHeader": false,
"UsePathAsTransactionName": true,
"VerifyServerCert": true,
"Description": "Invantive UniversalSQL Server Development appsettings configuration"
}
}
}