Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mkel
Regular Visitor

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

 

mkel_0-1697439412231.png

 

1 ACCEPTED SOLUTION
mkel
Regular Visitor

I just "fixed" the issue...

Turns out that I had two different Versions of SQLEXPRESS installed on my machine and I accidentally choose the older version in order to create a new database for the reporting server...

View solution in original post

1 REPLY 1
mkel
Regular Visitor

I just "fixed" the issue...

Turns out that I had two different Versions of SQLEXPRESS installed on my machine and I accidentally choose the older version in order to create a new database for the reporting server...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.