Unable to create a database for the report server
Hello, currently I am trying to create a database using the configuration manager, but as soon as I reach the task for running the script (first screenshot) I get the following error: Unfortunately I couldn't find a way to change the language while setting up the reporting server, so the error log is in german. System.Data.SqlClient.SqlException (0x80131904): Ungültige Sortierung 'Latin1_General_100_CI_AS_KS_WS'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper) bei Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) bei ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) ClientConnectionId:7f8fbb1c-6012-428d-adbf-1e31e2eb89ec Fehlernummer (Error Number):448,Status (State):3,Klasse (Class):16
SSRS go to url with a field value
I am creating a SSRS report with an action to open a new window with the URL And I want to pass the filed value as a filter for the new pop-out window. Below is the code I am using ="javascript:void window.open('" & Globals!ReportServerUrl & "/reportserver?" & Globals!ReportFolder & "/MyReport&TYPE="&Fields!TYPE1.Value & "&AREA=" &Fields!AREA.Value & "&STATE=" &Fields!STATE.Value &"','_blank','width=1500,height=750,scrollbars=yes,resizable=yes,toolbar=no,status=no,menu=no,top=20,left=15')" And the table I am using is down below AREA Running Failed AREA 1 10 0 AREA 2 12 2 Both "Running"/"Failed" are the value from 'STATE', the idea is when i click for eg.10 it will only shows the AREA 1 with Running, when i clicked 2 it will shows AREA 2 with Failed (Please noted, i also add the similar code for AREA as well, (without the STATE) and it works perfectly, so im confused why the similar code failed this one. I have parameter for STATE as well, but i tried using &STATE = "¶meter!STATE.Value it still failed. And also, STATE only has 2 values ( "Running" & "Failed") there is no specific characters Any helps on this?
not getting updated dataset when downloading data from powerbi reporting server
I have a dashboard that is updated as of yesterday but when i download the dashboard pbix file the data in that pbix file is old not updated as of yesterday. does anyone know how to get the updated pbix file directly from the reporting server. here is a snapshot
Reporting Server pwerBi
i'm trying to save and app that i edited on powerbi desktop to reporting server. i keep on getting this error (check below) When i check RSP0werBI logs i get this error (check below) : 2021-05-19 00:00:10.9713|ERROR|107|Error Processing Data Model Refresh: SessionId: 29e1fd73-33da-441b-bfe9-62f4acd1821c, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'A user name wasn't specified. The exception was raised by the IDbConnection interface. A connection could not be made to the data source with the Name of 'ca2e0137-f92d-46e1-b457-0fbe860368a3'. The database operation was cancelled because of an earlier failure. May i please get some help.
