Steps to Deploy Report Model Into Production Server.

 Note :

1.First Deploy the .smdl File into Local Server(http://localhost/reportserver) and then download the .smdl file in to folder(send downloaded files as a deliverable).

2.All tables related with report model should be present  in the data base.

1.Create the DataSource inside the "data Source" folder

                1.1 Click On "New data Source" tab.

                1.2 Give the New data Source Name(.dsv)

                1.3 Data source type: microsoft sql server

                1.4 Connection String:Data Source=<machine name>;Initial Catalog=<db name>;

                Example:Data Source=A648;Initial Catalog=database_Name;

                1.5 check Windows integrated security.

                1.6 Test connection.

                1.7 Apply

2.GO to "Models" Folder

               2.1 Upload the .smdl file

               2.2 Right click-->Manage-->Data Source-->browse the data source.

              2.3 select the data source inside the "data source"Folder.

3.Upload the RDL File.

               3.1 Right click-->Manage-->Data Source-->browse the shared data source.

               3.2 select the data source inside the "Model"Folder.

Error,while restoring the database in MS SQLserver 2008R2

Error: “The file “C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf” is compressed but does not reside in a read-only database or file group. The file must be decompressed.”

solution1:Opened my mdf file properties dialog box, and in the advance tab the problem was revealed: the “compress content” checkbox was checked.

After unchecking and saving changes, SQL Server accepted the attach with no problem whatsoever.

solution2:Check the drive where data base is going to restore.Right click the Drive(C: Drive)--> Property-->General-->Compress this drive to save the disk space(it should be unchecked )