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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.