I can configure a working subscription to e-mail through my SMTP server when
sending only the LINK to a report but not if I attach the report to the
e-mail in say excel or xml format.
Any suggestions?
Thanks
TravisSomeone must have an idea... please! :-)
I have tested using a command line SMTP utility and have been able to send
both a plain text message and a plain text message wth and attachment so I
know the Mail server will accept it.
Someone, Anyone?
Thanks
Travis
"REM7600" <rem7600@.hotmail.com> wrote in message
news:eumyP3OdEHA.1692@.tk2msftngp13.phx.gbl...
> I can configure a working subscription to e-mail through my SMTP server
when
> sending only the LINK to a report but not if I attach the report to the
> e-mail in say excel or xml format.
> Any suggestions?
> Thanks
> Travis
>|||Here's the error from the log... I can't make much of it... Other than the
part that says please see the log files...
ReportingServicesService!emailextension!728!07/29/2004-07:32:05:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext reportContext, String historyID, Boolean
forRendering, Guid& reportID, Int32& executionOption, String&
savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot&
snapshotData, Guid& linkID, DateTime& historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
Showing posts with label configure. Show all posts
Showing posts with label configure. Show all posts
Tuesday, March 20, 2012
Friday, March 9, 2012
quick question about replication in SQL2000 standard
Hi,
Can we configure the SQL 2000 database replication between two SQL server installed on win2k standalone servers(workgroup)? or must the servers be member server in the same domain?
regards,
Frank
You can, but you will need to be running in Mixed-Mode Authentication and
you will have to use SQL Server Logins.
Another option is to use Local Windows accounts, which you will have to
create on both servers, garauntee the same SIDs, names, and passwords, and
always keep these synchronized. This is a more complex strategy but can
work.
Sincerely,
Anthony Thomas
"Frank" <signup0702@.sina.com> wrote in message
news:uNQpao7HFHA.3196@.TK2MSFTNGP15.phx.gbl...
Hi,
Can we configure the SQL 2000 database replication between two SQL server
installed on win2k standalone servers(workgroup)? or must the servers be
member server in the same domain?
regards,
Frank
Can we configure the SQL 2000 database replication between two SQL server installed on win2k standalone servers(workgroup)? or must the servers be member server in the same domain?
regards,
Frank
You can, but you will need to be running in Mixed-Mode Authentication and
you will have to use SQL Server Logins.
Another option is to use Local Windows accounts, which you will have to
create on both servers, garauntee the same SIDs, names, and passwords, and
always keep these synchronized. This is a more complex strategy but can
work.
Sincerely,
Anthony Thomas
"Frank" <signup0702@.sina.com> wrote in message
news:uNQpao7HFHA.3196@.TK2MSFTNGP15.phx.gbl...
Hi,
Can we configure the SQL 2000 database replication between two SQL server
installed on win2k standalone servers(workgroup)? or must the servers be
member server in the same domain?
regards,
Frank
quick question about replication in SQL2000 standard
Hi,
Can we configure the SQL 2000 database replication between two SQL server in
stalled on win2k standalone servers(workgroup)? or must the servers be membe
r server in the same domain?
regards,
FrankYou can, but you will need to be running in Mixed-Mode Authentication and
you will have to use SQL Server Logins.
Another option is to use Local Windows accounts, which you will have to
create on both servers, garauntee the same SIDs, names, and passwords, and
always keep these synchronized. This is a more complex strategy but can
work.
Sincerely,
Anthony Thomas
"Frank" <signup0702@.sina.com> wrote in message
news:uNQpao7HFHA.3196@.TK2MSFTNGP15.phx.gbl...
Hi,
Can we configure the SQL 2000 database replication between two SQL server
installed on win2k standalone servers(workgroup)? or must the servers be
member server in the same domain?
regards,
Frank
Can we configure the SQL 2000 database replication between two SQL server in
stalled on win2k standalone servers(workgroup)? or must the servers be membe
r server in the same domain?
regards,
FrankYou can, but you will need to be running in Mixed-Mode Authentication and
you will have to use SQL Server Logins.
Another option is to use Local Windows accounts, which you will have to
create on both servers, garauntee the same SIDs, names, and passwords, and
always keep these synchronized. This is a more complex strategy but can
work.
Sincerely,
Anthony Thomas
"Frank" <signup0702@.sina.com> wrote in message
news:uNQpao7HFHA.3196@.TK2MSFTNGP15.phx.gbl...
Hi,
Can we configure the SQL 2000 database replication between two SQL server
installed on win2k standalone servers(workgroup)? or must the servers be
member server in the same domain?
regards,
Frank
Subscribe to:
Posts (Atom)