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 |
|
terrence_chan99
Starting Member
12 Posts |
 Posted - 2006-03-30 : 00:12:57
|
| What I am trying to do is subscribe a report and send it as Excel.I created two users under my SQL Server 2005. They both got sysadmin privilege in SQL server.1) user12) mydomain\user1I have tried to use each of them and still getting different error messages.Test1====I setup the datasource in VS2005. option "Use a specific user name as password"Username: user1 Password:passwordAfter I deploy the reports and override the existing Data sources in Report Server. Here is the result1) Run Report (no issue!!)2) Subscribe report with "Include links" option(no issue!!!)3) Subscribe report with "Include Report", I select EXCEL format(got error message: Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.)Test 2======I set up the datasource in VS2005. option. "Use a specific user name as password"Username: mydomain\user1 Password:passwordAfter I deploy the reports and override the existing Data sources in Report Server. Here is the result1) Run Report (got error message:An error has occurred during report processing. Cannot create a connection to data source 'MydataSourceConnection'. Login failed for user 'mydomain\user1'. )2) Subscribe report with "Include links" option(no issue!!!)3) Subscribe report with "Include Report", I select EXCEL format(got error message: Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.) |
|
|
|
|
|
Subscription report with Include Reports get error