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.
Report server on premise - how to change size of max dataset in SSMS
Hi everybody, I have a problem with some datasets that need to be available in reporting server. Unfortunately we passed the limit of 1GB. From the change logs i can see that there is an option to change the dataset size from default 1GB to 2 GB but i cannot find in the config. Have someone did it and can pass me a screen where the option is ? Thanks in advance!
