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.