如何配置报表服务器数据库配置?

How to configuring Reporting Server Database Configuration?

提问人:Olaleye Cosby Olorunsomo 提问时间:9/14/2023 最后编辑:Dale KOlaleye Cosby Olorunsomo 更新时间:9/14/2023 访问量:28

问:

System.Data.SqlClient.SqlException (0x80131904): The file "C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\ReportServer3.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
ClientConnectionId:66ed706c-8c3e-4f92-878e-c5a6ce4f68bc
Error Number:5118,State:1,Class:16

我尝试创建一个新的报表服务器数据库,该错误发布在问题详细信息中

SQL-Server Reporting-Services 配置 报告 ConfigurationManager

评论

2赞 Dale K 9/14/2023
错误怎么办,你不明白吗?
3赞 Charlieface 9/14/2023
来自文档“警告:NTFS 压缩文件系统不支持读/写数据文件组和日志文件。 learn.microsoft.com/en-us/sql/relational-databases/databases/......

答: 暂无答案