Also change you connection string with this below and try.

dDefinition.ConnectString = "Data Source=" + DBServer + ";Initial Catalog=" + DBName + ";integrated security=SSPI"

Change the "DBName" with your database name and it should work all good. I used your code and i was successfull deploying my report. Thanks to you.

Thanks Markus, this is absolutely life saving, as i thought of the 1st option but didnt knew how to execute SP at startup.

Thank you very much.

Thanks Mr. Chris. I think that is where the profiler comes in action.

Thank you very much.