Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aalokitoaami
Starting Member
2 Posts |
 Posted - 2008-05-13 : 04:33:21
|
| Hi,I want to generate and publish report using c#. For that i am using xmlwriter to generate the rdl file. Now the problem is when i publish it through the web service it can't fectch data from my remote sql server. I want my report server to connect to remote server for filling datasource with sql authrntication. I have created the datasource xml as follows:::::::::::::::::::<DataSource Name="DynamicDataSource"><ConnectionProperties><DataProvider>SQL</DataProvider><ConnectString>Data Source=SIGMASQL;initial catalog=SOP;User Id=sa;Password=xyz</ConnectString></ConnectionProperties></DataSource></DataSources>::::::::::::::::::::::::::But when i open the report it shows mw password prompt. After googling i found that if you don't set IntegratedSecurity elment to true it shows the prompt. Otherway i can read the credential information from the stored credentials of the RS. When i edit the report generated by my c# code through ReportManager web interface, in the datasource tab under "Custom Data Source" radio button i changed the selection to SQL Server authentication and placed the desired authentication info. Then i saw the report is running. Now my problem is that how can i sent that sql authentication info for datasource so that it will be stored in my report server through the reporting service web service?I don't want to use shared datasource.Tarun Ghoshhttp://www.aspxdev.blogspot.com |
|
|
|
|
|
Set"Stored Credentials"of report server thru RS WS