Hi,
I'm having a problem with Reporting Services report subscriptions.
I have a set of reports that need to be sent via email on a schedule. I need
to send them in Excel format, but the files sent to my email account are
unreadable in Excel. I am using Excel 2003 and can manually export reports
and open them in Excel without any problems, yet when I use a subscription to
email the Excel files they are not valid files. They have the .xls extension,
but Excel can't open them properly, it just opens them as a load of
unintelligible text.
The same thing happens when I set up a subscription to email a report in XML
format, I could export it manually and it worked fine, yet when I run the
subscription to email the XML report to me I get an invalid XML file.
Has anyone else had this problem or does anyone know how to fix it?
If it helps, the report server is stored on a network server, not my local PC.
The server is running Windows Server 2003 Pro, my PC is running Windows XP
Pro and has Office 2003. Office is not installed on the server, but I doubt
that makes any difference, since I can manually export to Excel without any
problems.
Thanks in advance
TabbyWhen you run them "locally" due you mean from VS.NET on your workstation?
If yes... I found that generating reports "locally" can have totally
different results than running them on the report server.
If this is the case...try loading the report via a browser from the report
server.
If this is not the case... try pdf/html or other output formats to narrow
down the problem. I found problems exporting to excel but not other formats
when report objects are overlapping.
Tabby Cool wrote:
>Hi,
>I'm having a problem with Reporting Services report subscriptions.
>I have a set of reports that need to be sent via email on a schedule. I need
>to send them in Excel format, but the files sent to my email account are
>unreadable in Excel. I am using Excel 2003 and can manually export reports
>and open them in Excel without any problems, yet when I use a subscription to
>email the Excel files they are not valid files. They have the .xls extension,
>but Excel can't open them properly, it just opens them as a load of
>unintelligible text.
>The same thing happens when I set up a subscription to email a report in XML
>format, I could export it manually and it worked fine, yet when I run the
>subscription to email the XML report to me I get an invalid XML file.
>Has anyone else had this problem or does anyone know how to fix it?
>If it helps, the report server is stored on a network server, not my local PC.
>The server is running Windows Server 2003 Pro, my PC is running Windows XP
>Pro and has Office 2003. Office is not installed on the server, but I doubt
>that makes any difference, since I can manually export to Excel without any
>problems.
>Thanks in advance
>Tabby
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||No, I am not running htem from Visual Studio, I am running them direct from
the Report Manager.
When you run reports in Visual Studio, can you actually export them? I
thought you could only preview them, there is no option to export a report
from the preview screen.
I have tried exporting them to both XML and Excel, I can do this perfectly
from the Report Manager, yet when I use a subscription to email the reports
to me in either of these formats the files are unusable.
William N wrote:
>When you run them "locally" due you mean from VS.NET on your workstation?
>If yes... I found that generating reports "locally" can have totally
>different results than running them on the report server.
>If this is the case...try loading the report via a browser from the report
>server.
>If this is not the case... try pdf/html or other output formats to narrow
>down the problem. I found problems exporting to excel but not other formats
>when report objects are overlapping.
>>Hi,
>[quoted text clipped - 23 lines]
>>Tabby|||I have tried exporting to PDF, again, this works fine when performed manually,
but the email attachments from the subscription are not valid PDFs and can't
be opened by Adobe Acrobat.
It seems there is something different with the export procedure when using a
subscription as opposed to exporting manually, I don't understand why it
would work perfectly one way and not the other.|||Seems like the report is not getting the the data?
Are you saving the credentials in your data connection?
Tabby Cool wrote:
>I have tried exporting to PDF, again, this works fine when performed manually,
>but the email attachments from the subscription are not valid PDFs and can't
>be opened by Adobe Acrobat.
>It seems there is something different with the export procedure when using a
>subscription as opposed to exporting manually, I don't understand why it
>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Yes, the credentials are stored in the data source.
William N wrote:
>Seems like the report is not getting the the data?
>Are you saving the credentials in your data connection?
>>I have tried exporting to PDF, again, this works fine when performed manually,
>>but the email attachments from the subscription are not valid PDFs and can't
>[quoted text clipped - 3 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Not sure what else to suggest.
I always try to simplify as much as possible first. Maybe try creating a
report with just a "Hello" text box and see if that works (no data sets or
anything else).
If it doesn't, then it's probably a server/install issue.
Good luck.
Tabby Cool wrote:
>Yes, the credentials are stored in the data source.
>>Seems like the report is not getting the the data?
>[quoted text clipped - 5 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1
Showing posts with label email. Show all posts
Showing posts with label email. Show all posts
Monday, March 26, 2012
Wednesday, March 7, 2012
problem with xp_smtp_sendmail
Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegro ups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegro ups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.
problem with xp_smtp_sendmail
Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegroups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegroups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.
problem with xp_smtp_sendmail
Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribió en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegroups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don´t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribió en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegroups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don´t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.
problem with xp_sendmail
Hi
I had the xp_sendmail working the other day, but when I now try to send an
email using the xp_sendmail proc, I get the following error message:
xp_sendmail: Procedure expects parameter @.user, which was not supplied.
What does that mean? I can't even see that there's a @.user parameter to set
for the xp_sendmail proc. Is it just me that are missing something here?
Regards
SteenHi
You may want to check the mail profiles, by logging in as the service
account and making sure it exists and is working.
John
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:ux9r1XCZEHA.2432@.tk2msftngp13.phx.gbl...
> Hi
> I had the xp_sendmail working the other day, but when I now try to send an
> email using the xp_sendmail proc, I get the following error message:
> xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> What does that mean? I can't even see that there's a @.user parameter to
set
> for the xp_sendmail proc. Is it just me that are missing something here?
> Regards
> Steen
>|||arghhh...stupid me... The account that runs the SQLServer service needs to
be the one that has the mailbox setup for it to work from TSql. In my case
it was still the local system account on some servers but the SQLServer
Agent service is all set to the mailbox user - that was why it worked when
testing an operator setup but not when running the xp_sendmail.
Steen
"John Bell" <jbellnewsposts@.hotmail.com> skrev i en meddelelse
news:%23ofKcfCZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> Hi
> You may want to check the mail profiles, by logging in as the service
> account and making sure it exists and is working.
> John
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:ux9r1XCZEHA.2432@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > I had the xp_sendmail working the other day, but when I now try to send
an
> > email using the xp_sendmail proc, I get the following error message:
> >
> > xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> >
> > What does that mean? I can't even see that there's a @.user parameter to
> set
> > for the xp_sendmail proc. Is it just me that are missing something here?
> >
> > Regards
> > Steen
> >
> >
>
I had the xp_sendmail working the other day, but when I now try to send an
email using the xp_sendmail proc, I get the following error message:
xp_sendmail: Procedure expects parameter @.user, which was not supplied.
What does that mean? I can't even see that there's a @.user parameter to set
for the xp_sendmail proc. Is it just me that are missing something here?
Regards
SteenHi
You may want to check the mail profiles, by logging in as the service
account and making sure it exists and is working.
John
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:ux9r1XCZEHA.2432@.tk2msftngp13.phx.gbl...
> Hi
> I had the xp_sendmail working the other day, but when I now try to send an
> email using the xp_sendmail proc, I get the following error message:
> xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> What does that mean? I can't even see that there's a @.user parameter to
set
> for the xp_sendmail proc. Is it just me that are missing something here?
> Regards
> Steen
>|||arghhh...stupid me... The account that runs the SQLServer service needs to
be the one that has the mailbox setup for it to work from TSql. In my case
it was still the local system account on some servers but the SQLServer
Agent service is all set to the mailbox user - that was why it worked when
testing an operator setup but not when running the xp_sendmail.
Steen
"John Bell" <jbellnewsposts@.hotmail.com> skrev i en meddelelse
news:%23ofKcfCZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> Hi
> You may want to check the mail profiles, by logging in as the service
> account and making sure it exists and is working.
> John
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:ux9r1XCZEHA.2432@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > I had the xp_sendmail working the other day, but when I now try to send
an
> > email using the xp_sendmail proc, I get the following error message:
> >
> > xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> >
> > What does that mean? I can't even see that there's a @.user parameter to
> set
> > for the xp_sendmail proc. Is it just me that are missing something here?
> >
> > Regards
> > Steen
> >
> >
>
Subscribe to:
Posts (Atom)