sql server reporting services: struggling with an e-mail subscription -- sql server reporting services

struggling with an e-mail subscription

locoytravieso
9/6/2007 11:35:52 AM

sql server reporting services:

Hi All-

I figured out how to configure the SMTP to work but now when I try to
subscribe to a report I'm getting credentials problem. So I went into the
data source and put in the following connection string:

Data Source=XXXXXX;Initial Catalog=SystemCenterReporting;Integrated
Security=False;Persist Security Info=True;User ID=XXX@labdm.lab

Then I specified Credentials stored securely in the report server and put in
this same user ID (XXX@labdm.lab) and it's password. I also checked Use as
Windows credentials when connecting .... and Impersonate ....

If I hit apply I get a password is not valid message and to retype the
password.

My questions -

What is the right syntax? Do I have to specify the user in the Connection
String? Do I also need to put the password in there?

I don't care a lick about security for this lab instance and would rather
turn it all off if possible.

Any help would be most appreciated!

Thanks!

--GREG--

RE: struggling with an e-mail subscription

Christopher Robin
9/10/2007 11:42:00 AM

There are 2 issues listed here. RS can only use an open SMTP relay. If your
SMTP Server requires authentication, it will not work with RS at this time.

I've also read that there are some additional hoops you must jump through to
get Windows Authentication to work for data sources. I don't use this,
however. Our data resides on a different domain and the 2 domains don't
really know about each other. So, I pull the data into a server that sits on
both domains, and then use a SQL Login to read the data for the reports.

I hope this helps.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.