Showing posts with label files. Show all posts
Showing posts with label files. Show all posts

Thursday, March 29, 2012

Embedding SQL Server Express in the installer

Can we embed the SQL Server Express in the windows installer jsut like the XML files or the Ms access database?You are referring to the windows installer in VS 2005 I suppose ??
It is not possible in the installer of VS 2003, but I suppose it can be done with Whidbey ... I haven't tried it yet though ...|||The following information may provide clarification regarding the same;

Can I redistribute SQL Express?
http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172952.aspx

Embedding multiple .sql files

How do I write a .sql script that executes a number of other scripts in .sql
files? This has to be easy. I just can't find it.
Thanks,
JerryRYou can use oSql. See if this helps:
http://www.sql-server-performance.com/rd_osql.asp
Andrew J. Kelly SQL MVP
"JerryR" <JerryR@.discussions.microsoft.com> wrote in message
news:76549937-4F1E-41B5-B148-A548F0B8CA95@.microsoft.com...
> How do I write a .sql script that executes a number of other scripts in
> .sql
> files? This has to be easy. I just can't find it.
> Thanks,
> JerryR|||There is no such feature in SQL like this in Oracle @.Somefile.sql. You
have to put in in a OS batch to execute it via a cmdshell program like
SQLCMD or OSQL or ISQL.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Yes, that's what I was looking for.
Thanks
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1143927815.456011.236990@.v46g2000cwv.googlegroups.com...
> There is no such feature in SQL like this in Oracle @.Somefile.sql. You
> have to put in in a OS batch to execute it via a cmdshell program like
> SQLCMD or OSQL or ISQL.
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Embedded text qualifiers

We have text files that are comma delimited, use double quotes as text qualifiers and sometimes have embedded double quotes. The embedded double quotes are escaped with an additional double quote like: below.

"123","product q"

"124","product ""a"""

DTS 2000 had no problem with this- it correctly parsed the files. The 2005 SSIS file connection manager correctly parses this in preview mode. But when the task is executed the task fails with the message "The column delimiter for column X was not found".

What is the recommended approach for this - we have alot of files in this format.

thanks

Please search the forums.

This should get you started: (in a sense, it's not going to be easy) http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=80634&SiteID=1|||I've had to do this as the other post with a script component. I import the whole row as a single column, then run via a regular expression a split command and then use replace function as well. Thats the best solution I have come across to your issue.|||Another workaround that I used successfully was to simply change the source file format. I changed it to |~| delimeter and no text qualifier. In addition I configured the SSIS source file connection manager to recognize the |~| as the delimiter and did not set the text qualifer option. In the end, it proved less painful than the other methods.

Embedded text qualifiers

We have text files that are comma delimited, use double quotes as text qualifiers and sometimes have embedded double quotes. The embedded double quotes are escaped with an additional double quote like: below.

"123","product q"

"124","product ""a"""

DTS 2000 had no problem with this- it correctly parsed the files. The 2005 SSIS file connection manager correctly parses this in preview mode. But when the task is executed the task fails with the message "The column delimiter for column X was not found".

What is the recommended approach for this - we have alot of files in this format.

thanks

Please search the forums.

This should get you started: (in a sense, it's not going to be easy) http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=80634&SiteID=1|||I've had to do this as the other post with a script component. I import the whole row as a single column, then run via a regular expression a split command and then use replace function as well. Thats the best solution I have come across to your issue.|||Another workaround that I used successfully was to simply change the source file format. I changed it to |~| delimeter and no text qualifier. In addition I configured the SSIS source file connection manager to recognize the |~| as the delimiter and did not set the text qualifer option. In the end, it proved less painful than the other methods.

Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

Thursday, March 22, 2012

EMail Task Problem

I have a pretty simple process that copies some files from an AS400 to a directory on the same server where my sql 2005 instance lives. I then use an email task to send these files to a client.

However, the email task does not work. I get the following message:

[Send Mail Task] Error: Either the file "BYNSOSR1;BYNSOSR2;BYNSOSR3;BYNSOSR4;BYNSOSR5;BYNSOSR6;BYNSOSR7" does not exist or you do not have permissions to access the file.

Well, the files definitely exist where they are supposed to be so I guess it's a permissions error. However, I have no clue which user would need permissions on that directory. As a test, I gave everyone read permissions and still got this error.

Any suggestions about which user I need to allow read access to the directory where these files exist?

Thanks in advance for any info.

I should say the path info in the previous post was changed so as not to reveal path info. But, the files do indeed exist where the email task expects them to be. I wrote a vb.net app that can email the files from that location just fine using the SMTP client of the .net.mail object hierarchy.|||Well, I never could figure out why the send email task wasn't working. It must have been some sort of permissions issue. I solved the problem by writing a console app in vb.net that sends the email via the net.mail smtpclient. I then run the console app as a execute process task. That sent the email with no problems and was a perfectly adequate way to solve the problem.

Monday, March 19, 2012

email notificaiton when log files are getting large

Can SQL send me an email alert when log files are getting large?
Thanks,
JM
You can set up an alert that fires when the % used space in a log goes above
a certain threshold. Unfortunately, you'd need to set up one such alert per
database.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Joe Murphy" <spam@.spamthis.com> wrote in message
news:OdCtSbHPGHA.1832@.TK2MSFTNGP11.phx.gbl...
Can SQL send me an email alert when log files are getting large?
Thanks,
JM
|||How to?
_______________________________
http://boston.craigslist.org/about/b.../62974620.html
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uPDMueHPGHA.536@.TK2MSFTNGP09.phx.gbl...
> You can set up an alert that fires when the % used space in a log goes
> above
> a certain threshold. Unfortunately, you'd need to set up one such alert
> per
> database.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Joe Murphy" <spam@.spamthis.com> wrote in message
> news:OdCtSbHPGHA.1832@.TK2MSFTNGP11.phx.gbl...
> Can SQL send me an email alert when log files are getting large?
> Thanks,
> JM
>
|||What version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe Murphy" <spam@.spamthis.com> wrote in message news:%23soU6wHPGHA.3728@.tk2msftngp13.phx.gbl...
> How to?
> --
> _______________________________
> http://boston.craigslist.org/about/b.../62974620.html
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uPDMueHPGHA.536@.TK2MSFTNGP09.phx.gbl...
>
|||I'd be interested in SQL2000 (SP3)
Regards,
Hank Arnold
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23cPC6SIPGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> What version of SQL Server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Joe Murphy" <spam@.spamthis.com> wrote in message
> news:%23soU6wHPGHA.3728@.tk2msftngp13.phx.gbl...
|||Enterprise Manager, Management, SQL Server Agent, right-click Alerts, New Alert.
Specify a performance condition alert with the desired perf mon counter.
And first you create your operator and make sure that SQL Mail is functioning properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hank Arnold" <rasilon@.aol.com> wrote in message news:%23Y6DHDSPGHA.3408@.TK2MSFTNGP12.phx.gbl...
> I'd be interested in SQL2000 (SP3)
> --
> Regards,
> Hank Arnold
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23cPC6SIPGHA.3984@.TK2MSFTNGP14.phx.gbl...
>
|||OK, but that doesn't seem to work when trying to measure a threshold. Say
when the transaction log reaches N% of total allocated size.
That's the kind of thing I'm looking for.
Thanks,
JM
_______________________________
http://boston.craigslist.org/about/b.../62974620.html
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OPnG5UVPGHA.3264@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Enterprise Manager, Management, SQL Server Agent, right-click Alerts, New
> Alert.
> Specify a performance condition alert with the desired perf mon counter.
> And first you create your operator and make sure that SQL Mail is
> functioning properly.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Hank Arnold" <rasilon@.aol.com> wrote in message
> news:%23Y6DHDSPGHA.3408@.TK2MSFTNGP12.phx.gbl...
|||Did you specify *performance condition alert*? I'm not talking about the regular event alerts...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe Murphy" <spam@.spamthis.com> wrote in message news:%23Nw4iLuPGHA.3848@.TK2MSFTNGP12.phx.gbl...
> OK, but that doesn't seem to work when trying to measure a threshold. Say
> when the transaction log reaches N% of total allocated size.
> That's the kind of thing I'm looking for.
> Thanks,
> JM
> --
> _______________________________
> http://boston.craigslist.org/about/b.../62974620.html
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OPnG5UVPGHA.3264@.TK2MSFTNGP11.phx.gbl...
>
|||Here's a sample script:
-- Script generated on 3/3/2006 8:48 PM
-- By: BMCI04\Administrator
-- Server: BMCI04\SQL2000
BEGIN TRANSACTION
DECLARE @.JobID BINARY(16)
DECLARE @.ReturnCode INT
SELECT @.ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name =
N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @.name = N'[Uncategorized (Local)]'
-- Delete the job with the same name (if it exists)
SELECT @.JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Backup Northwind Log')
IF (@.JobID IS NOT NULL)
BEGIN
-- Check if the job is a multi-server job
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @.JobID) AND (server_id <> 0)))
BEGIN
-- There is, so abort the script
RAISERROR (N'Unable to import job ''Backup Northwind Log'' since there
is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
-- Delete the [local] job
EXECUTE msdb.dbo.sp_delete_job @.job_name = N'Backup Northwind Log'
SELECT @.JobID = NULL
END
BEGIN
-- Add the job
EXECUTE @.ReturnCode = msdb.dbo.sp_add_job @.job_id = @.JobID OUTPUT ,
@.job_name = N'Backup Northwind Log', @.owner_login_name = N'sa', @.description
= N'No description available.', @.category_name = N'[Uncategorized (Local)]',
@.enabled = 1, @.notify_level_email = 0, @.notify_level_page = 0,
@.notify_level_netsend = 0, @.notify_level_eventlog = 2, @.delete_level= 0
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job steps
EXECUTE @.ReturnCode = msdb.dbo.sp_add_jobstep @.job_id = @.JobID, @.step_id =
1, @.step_name = N'Backup', @.command = N'backup log Northwing to disk =
''C:\Temp\Northwind.trn''', @.database_name = N'master', @.server = N'',
@.database_user_name = N'', @.subsystem = N'TSQL', @.cmdexec_success_code = 0,
@.flags = 0, @.retry_attempts = 0, @.retry_interval = 1, @.output_file_name =
N'', @.on_success_step_id = 0, @.on_success_action = 1, @.on_fail_step_id = 0,
@.on_fail_action = 2
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @.ReturnCode = msdb.dbo.sp_update_job @.job_id = @.JobID,
@.start_step_id = 1
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
-- Add the Target Servers
EXECUTE @.ReturnCode = msdb.dbo.sp_add_jobserver @.job_id = @.JobID,
@.server_name = N'(local)'
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@.@.TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Backup
Northwind Log'))
-- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @.name = N'Backup Northwind Log'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @.name = N'Backup Northwind Log', @.message_id =
0, @.severity = 0, @.enabled = 1, @.delay_between_responses = 60,
@.performance_condition = N'MSSQL$SQL2000:Databases|Log File(s) Used Size
(KB)|Northwind|>|25', @.include_event_description_in = 5, @.job_name =
N'Backup Northwind Log', @.category_name = N'[Uncategorized]'
END
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Joe Murphy" <spam@.spamthis.com> wrote in message
news:%23Nw4iLuPGHA.3848@.TK2MSFTNGP12.phx.gbl...
OK, but that doesn't seem to work when trying to measure a threshold. Say
when the transaction log reaches N% of total allocated size.
That's the kind of thing I'm looking for.
Thanks,
JM
_______________________________
http://boston.craigslist.org/about/b.../62974620.html
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OPnG5UVPGHA.3264@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Enterprise Manager, Management, SQL Server Agent, right-click Alerts, New
> Alert.
> Specify a performance condition alert with the desired perf mon counter.
> And first you create your operator and make sure that SQL Mail is
> functioning properly.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Hank Arnold" <rasilon@.aol.com> wrote in message
> news:%23Y6DHDSPGHA.3408@.TK2MSFTNGP12.phx.gbl...

Sunday, March 11, 2012

EMAIL Coruption In attachments

OK, I am looking for help on how to break this problem up for debugging. I
am testing Email report schedules. We are working with files of type:
TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
successfully. I am able to email LINKS to reports successfully. When I
send files of these three types as Email ATTACHMENTS they arrive corupted.
The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to a
SMTP server is external to the RS server, which then passes the reports to
a NOTES server and then to me. The log file for RS shows nothing unusual.
How would you approach debuging this issue?
thanks.
dlrYou can now download a hotfix that addresses this problem. See
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> OK, I am looking for help on how to break this problem up for debugging.
> I
> am testing Email report schedules. We are working with files of type:
> TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> successfully. I am able to email LINKS to reports successfully. When I
> send files of these three types as Email ATTACHMENTS they arrive corupted.
> The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> a
> SMTP server is external to the RS server, which then passes the reports
> to
> a NOTES server and then to me. The log file for RS shows nothing unusual.
> How would you approach debuging this issue?
> thanks.
> dlr
>|||ok. thanks for the tip. HOTFix resolved all problems with a single
exception. WEB ARCHIVES are still not working in notes (works fine with
hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading NOTES
will resolve this last problem?....
dlr
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive
corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing
unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>|||I believe the Notes Viewer does not support MHTML. You may want to change
your RS configuration to always attach MHTML rather then embed it. You can
do this by removing this line for the RSReportServer.config file:
<RenderingExtension>MHTML</RenderingExtension>
which is under the EmbeddedRenderFormats element
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> ok. thanks for the tip. HOTFix resolved all problems with a single
> exception. WEB ARCHIVES are still not working in notes (works fine with
> hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> will resolve this last problem?....
> dlr
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > You can now download a hotfix that addresses this problem. See
> > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > OK, I am looking for help on how to break this problem up for
debugging.
> > > I
> > > am testing Email report schedules. We are working with files of type:
> > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> SHARE
> > > successfully. I am able to email LINKS to reports successfully. When
I
> > > send files of these three types as Email ATTACHMENTS they arrive
> corupted.
> > > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS
> to
> > > a
> > > SMTP server is external to the RS server, which then passes the
reports
> > > to
> > > a NOTES server and then to me. The log file for RS shows nothing
> unusual.
> > > How would you approach debuging this issue?
> > >
> > > thanks.
> > >
> > > dlr
> > >
> > >
> >
> >
>|||very nice Daniel. thank you!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:esmzQT7gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> I believe the Notes Viewer does not support MHTML. You may want to change
> your RS configuration to always attach MHTML rather then embed it. You
can
> do this by removing this line for the RSReportServer.config file:
> <RenderingExtension>MHTML</RenderingExtension>
> which is under the EmbeddedRenderFormats element
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:OUYrEE7gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
> NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
> debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When
> I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
> reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr
> > > >
> > > >
> > >
> > >
> >
> >
>|||What exactly are you seeing? Can you create the subscriptions? Do they
never fire?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:D7BDCEF4-6090-49AD-A937-42A26EE9C192@.microsoft.com...
> Hi Dennis,
> We install this fix and now can't send any subscriptions.
> How you install this fix?
> Do you have some other problem when you isntall it?
> Thanks.
> "Dennis Redfield" wrote:
> > ok. thanks for the tip. HOTFix resolved all problems with a single
> > exception. WEB ARCHIVES are still not working in notes (works fine with
> > hotmail/outlook express) We are at v5.0.9 on Notes. Perhaps upgrading
NOTES
> > will resolve this last problem?....
> >
> > dlr
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:%236gRNPqgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > You can now download a hotfix that addresses this problem. See
> > > http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> > > news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > > > OK, I am looking for help on how to break this problem up for
debugging.
> > > > I
> > > > am testing Email report schedules. We are working with files of
type:
> > > > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE
> > SHARE
> > > > successfully. I am able to email LINKS to reports successfully.
When I
> > > > send files of these three types as Email ATTACHMENTS they arrive
> > corupted.
> > > > The HEX dump is really ugly. Mostly FF bytes... I am passing from
RS
> > to
> > > > a
> > > > SMTP server is external to the RS server, which then passes the
reports
> > > > to
> > > > a NOTES server and then to me. The log file for RS shows nothing
> > unusual.
> > > > How would you approach debuging this issue?
> > > >
> > > > thanks.
> > > >
> > > > dlr|||After fix install i subscriptions show this error:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
But before install subscriptions work with files formats errors.
Configuration was no touched and we have RS with SP1 + 872774
How log file i should check?
"Daniel Reib [MSFT]" wrote:
> What exactly are you seeing? Can you create the subscriptions? Do they
> never fire?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||This is the log (Fideicomiso is the report name):
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
based subscription notification for subscription:
4683f97c-9125-4f74-bb1c-5804303e7a54
ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004 4:30:03
PM.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call to
RenderFirst( '/ReportSystem/Fideicomisos' )
ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: 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.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(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(CatalogItemContext
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(RSService
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.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!3844!09/08/2004-16:30:04::
Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: Fideicomisos, Attempt 0
ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
NotificationPolling finished processing item
b8c2e7c5-0d9a-460b-b17d-e064f36198e7
"Carlos E. Mosquera" wrote:
> After fix install i subscriptions show this error:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> But before install subscriptions work with files formats errors.
> Configuration was no touched and we have RS with SP1 + 872774
> How log file i should check?
> "Daniel Reib [MSFT]" wrote:
> > What exactly are you seeing? Can you create the subscriptions? Do they
> > never fire?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.|||The error you are getting is: The specified domain either does not exist or
could not be contacted.
This is indicating a problem resolving the name of the owner of the
subscription. Can you try recreating the subscription and see if the new
subscription works? Also, does this happen with all users? What about a
user local to the report server box?
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:F05D7D1B-BFAB-428B-9445-E3E640E0BDDE@.microsoft.com...
> This is the log (Fideicomiso is the report name):
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e executed at 9/8/2004 4:30:03 PM.
> ReportingServicesService!schedule!3844!9/8/2004-16:30:03:: Creating Time
> based subscription notification for subscription:
> 4683f97c-9125-4f74-bb1c-5804303e7a54
> ReportingServicesService!library!3844!9/8/2004-16:30:03:: Schedule
> a58e2b9e-782b-4589-b6c2-b920bf754c9e execution completed at 9/8/2004
4:30:03
> PM.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03:: EventPolling
> finished processing item 4a28e564-b3d6-491d-826c-96a9926daf72
> ReportingServicesService!dbpolling!234!9/8/2004-16:30:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!3844!9/8/2004-16:30:03::
> NotificationPolling processing item b8c2e7c5-0d9a-460b-b17d-e064f36198e7
> ReportingServicesService!library!3844!09/08/2004-16:30:03:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO: Call
to
> RenderFirst( '/ReportSystem/Fideicomisos' )
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!3844!09/08/2004-16:30:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!3844!09/08/2004-16:30:04:: 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)
> ReportingServicesService!notification!3844!09/08/2004-16:30:04::
> Notification b8c2e7c5-0d9a-460b-b17d-e064f36198e7 completed. Success:
False,
> Status: Failure sending mail: The Report Server has encountered a
> configuration error; more details in the log files, DeliveryExtension:
Report
> Server Email, Report: Fideicomisos, Attempt 0
> ReportingServicesService!dbpolling!3844!09/08/2004-16:30:04::
> NotificationPolling finished processing item
> b8c2e7c5-0d9a-460b-b17d-e064f36198e7
>
> "Carlos E. Mosquera" wrote:
> > After fix install i subscriptions show this error:
> >
> > Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files
> >
> > But before install subscriptions work with files formats errors.
> >
> > Configuration was no touched and we have RS with SP1 + 872774
> >
> > How log file i should check?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > What exactly are you seeing? Can you create the subscriptions? Do
they
> > > never fire?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> The error you are getting is: The specified domain either does not
> exist or could not be contacted.
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the
> new subscription works? Also, does this happen with all users? What
> about a user local to the report server box?
PMFJI, but I am having the same issue as Carlos. Everything worked fine
with subscriptions with RS SP1, but I was having the issue of Lotus Notes
users not being able to open PDF attachments, so I installed the hotfix
872774. Now I'm unable to send any emails from RS (no matter what user I
create the subscription under). I'm running Windows 2003 Server, SQL Server
2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
8:25am PDT which shows the log file entries, but I didn't get a response
except from Carlos. Any ideas? Thanks!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||This is very strange. I am not sure what is going on. Are you also
receiving the 1355 error?
It may be best for you to contact PSS to try and find a resolution for this.
I am not sure why installing the hotfix would cause these problems.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:#8K95hnlEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi Daniel,
> Daniel Reib [MSFT] wrote:
> > The error you are getting is: The specified domain either does not
> > exist or could not be contacted.
> >
> > This is indicating a problem resolving the name of the owner of the
> > subscription. Can you try recreating the subscription and see if the
> > new subscription works? Also, does this happen with all users? What
> > about a user local to the report server box?
> PMFJI, but I am having the same issue as Carlos. Everything worked fine
> with subscriptions with RS SP1, but I was having the issue of Lotus Notes
> users not being able to open PDF attachments, so I installed the hotfix
> 872774. Now I'm unable to send any emails from RS (no matter what user I
> create the subscription under). I'm running Windows 2003 Server, SQL
Server
> 2000 SP3a, and RS SP1 w/872774 hotfix. I started a thread on 9/8/2004 at
> 8:25am PDT which shows the log file entries, but I didn't get a response
> except from Carlos. Any ideas? Thanks!
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Hi Daniel,
Daniel Reib [MSFT] wrote:
> This is very strange. I am not sure what is going on. Are you also
> receiving the 1355 error?
Yes - here's a snippet from my log file:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> It may be best for you to contact PSS to try and find a resolution
> for this. I am not sure why installing the hotfix would cause these
> problems.
Thanks - I'll try contacting PSS to see if they can shed some light on this.
I'd like to resolve this without having to roll back to SP1, as I have a
client that needs PDF attachments sent from RS and she's on Lotus Notes.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi
Finaly my server administrator try another way to avoid reinstall of RS and
everything work fine. He check every single configuration and all was
complete.
My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
Windows 2003 Server, then we try use RS with another server with Windows 2000
Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX 872774)
GUESS WHAT? Now all subscriptions work fine with same SMTP and
subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files corrupted.
This experience tell me something... Windows 2003 Server will have something
wrong.
Thanks a lot for all your help and contributions.
"Daniel Reib [MSFT]" wrote:
> The error you are getting is: The specified domain either does not exist or
> could not be contacted.
>
> This is indicating a problem resolving the name of the owner of the
> subscription. Can you try recreating the subscription and see if the new
> subscription works? Also, does this happen with all users? What about a
> user local to the report server box?
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Carlos,
Carlos E. Mosquera wrote:
> My principal server have SQL Server 2000 Ent. + SP3 and RS + SP1 in a
> Windows 2003 Server, then we try use RS with another server with
> Windows 2000 Server SP4 with IIS 5 and Framework 1.1 (WITHOUT FIX
> 872774)
> GUESS WHAT? Now all subscriptions work fine with same SMTP and
> subscriptors use Lotus Notes 6.5.1 (and 6.5.2) and any files
> corrupted.
> This experience tell me something... Windows 2003 Server will have
> something wrong.
I was working with PSS on this issue, but I ran out of time and options. I
never got it working under Windows Server 2003 with the hotfix applied. And
I was unsuccessful at getting it to work even after attempting to roll back
to RS SP1.
So I ended up doing the same thing - reformatting, installing Windows 2000
Server, installing RS, and installing RS SP1 - but I continued by installing
the hotfix as well. Guess what - works great now. I haven't had a Lotus
Notes client open the attachment yet, but hopefully it will work.
I did get an email today from the PSS rep assigned to my case. I think she
is leaning toward this being a Windows Server 2003 issue that happens to
cause problems for RS with the hotfix applied. Here's the article she
provided in case anyone else runs into this issue:
http://support.microsoft.com/?id=834859
I wish I still had 2003 installed so I could request this hotfix and test it
out. It does look promising.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||The hotfix actually fixed a similiar issue of ours:
Server A: Window 2003
Reporting Server: SP1 8.00.878.00
Issue: Excel Subscription Email Attachment Corrupted
Email Server: Novell Netware
Our two other environments/servers do not have problem:
Server B: Windows 2000
Reporting Server: RTM 8.00.743.00
Server C: Windows 2000
Reporting Server: SP1 8.00.878.00
So I think there is something to do with Windows2003 and Non-Exchange mail
server?
Tao
"Brian Welcker [MSFT]" wrote:
> You can now download a hotfix that addresses this problem. See
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:u%23hSrFWgEHA.4092@.TK2MSFTNGP10.phx.gbl...
> > OK, I am looking for help on how to break this problem up for debugging.
> > I
> > am testing Email report schedules. We are working with files of type:
> > TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE
> > successfully. I am able to email LINKS to reports successfully. When I
> > send files of these three types as Email ATTACHMENTS they arrive corupted.
> > The HEX dump is really ugly. Mostly FF bytes... I am passing from RS to
> > a
> > SMTP server is external to the RS server, which then passes the reports
> > to
> > a NOTES server and then to me. The log file for RS shows nothing unusual.
> > How would you approach debuging this issue?
> >
> > thanks.
> >
> > dlr
> >
> >
>
>

Sunday, February 19, 2012

EFS,SQL Server 2005 and Windows 2003

Has anyone used the Encrypting File System (EFS) capabilities of the OS to
encrypt the sql server 2005 data files? I am looking to do this but cannot
find any examples/instructions. Thanks.A little old but a good starting point nonetheless:
http://msdn2.microsoft.com/en-us/library/aa302434.aspx
Just remember to be consistent about what you use to perform the encryption
and the SQL Server service account both during setup and when you change
passwords. Getting locked out of your own DB sounds funny but really isn't.
joe.
"SQLUSER07" <SQLUSER07@.discussions.microsoft.com> wrote in message
news:F669E408-E3FC-41F6-8616-E95E5DA7A108@.microsoft.com...
> Has anyone used the Encrypting File System (EFS) capabilities of the OS to
> encrypt the sql server 2005 data files? I am looking to do this but cannot
> find any examples/instructions. Thanks.

Wednesday, February 15, 2012

Editing scheduled backups and time stamping backup files

Sorry for the previous post. Here are the problems:
1. Using enterprise manager, I chose to backup a
database. I picked my backup device and checked the
schedule option, setup the time and frequency of the
backup. It worked properly. How does one go in and edit
or modify the schedule after it is created? I went to
the backup device but, it doesn't show my schedule name
or settings, in fact, it shows the schedule option
unchecked. Any ideas or is it a matter of deleting the
device and recreating it?
2. I want to have each full backup have the basic file
name but have a time stamp added into the name. It would
look something like: databasename_db_200408141830. 2004
is the year, 08 the month, 14 the day, 1830 the hour. I
have seen it done but do not know how to duplicate it.
By doing this, I can go back to previous backups if a
problem occurs. Once again, any ideas?inline...
HTH
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
"smantz" <smantz@.smhscs.org> wrote in message
news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> Sorry for the previous post. Here are the problems:
> 1. Using enterprise manager, I chose to backup a
> database. I picked my backup device and checked the
> schedule option, setup the time and frequency of the
> backup. It worked properly. How does one go in and edit
> or modify the schedule after it is created? I went to
> the backup device but, it doesn't show my schedule name
> or settings, in fact, it shows the schedule option
> unchecked. Any ideas or is it a matter of deleting the
> device and recreating it?
the device actually will not show anything until it has been initialized. if
you want to edit the backup job itself you will find it under the
management, SQL agent, jobs. you 'll find it there.
> 2. I want to have each full backup have the basic file
> name but have a time stamp added into the name. It would
> look something like: databasename_db_200408141830. 2004
> is the year, 08 the month, 14 the day, 1830 the hour. I
> have seen it done but do not know how to duplicate it.
> By doing this, I can go back to previous backups if a
> problem occurs. Once again, any ideas?
>
the best way to do this is to create the backup job in database management
section. here you can create a scheduled backup and it will automatically
append the date/time of the backup.|||sorry I should be a bit more specific. you should look for the database
maintenance plan wizard. it can reindex, update statistics, backup database
and tlogs, and send notifications of job completion (I like this last one,
sends me an e-mail over lunch that my tlog backup has completed successfully
or not. it does take a bit more setup for the mail portion).
I'm a huge fan of the Maint.wizards but it shouldn't be the only way you
create these jobs. give em a shot...
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
/* Check out the books on-line (BOL) for more one the above */
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:#3XtUUB$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> inline...
> HTH
> Neil MacMurchy
> Senior DBA
> Regional Municipality of Niagara
> "smantz" <smantz@.smhscs.org> wrote in message
> news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> > Sorry for the previous post. Here are the problems:
> > 1. Using enterprise manager, I chose to backup a
> > database. I picked my backup device and checked the
> > schedule option, setup the time and frequency of the
> > backup. It worked properly. How does one go in and edit
> > or modify the schedule after it is created? I went to
> > the backup device but, it doesn't show my schedule name
> > or settings, in fact, it shows the schedule option
> > unchecked. Any ideas or is it a matter of deleting the
> > device and recreating it?
> the device actually will not show anything until it has been initialized.
if
> you want to edit the backup job itself you will find it under the
> management, SQL agent, jobs. you 'll find it there.
> >
> > 2. I want to have each full backup have the basic file
> > name but have a time stamp added into the name. It would
> > look something like: databasename_db_200408141830. 2004
> > is the year, 08 the month, 14 the day, 1830 the hour. I
> > have seen it done but do not know how to duplicate it.
> > By doing this, I can go back to previous backups if a
> > problem occurs. Once again, any ideas?
> >
> the best way to do this is to create the backup job in database management
> section. here you can create a scheduled backup and it will automatically
> append the date/time of the backup.
>

Editing scheduled backups and time stamping backup files

Sorry for the previous post. Here are the problems:
1. Using enterprise manager, I chose to backup a
database. I picked my backup device and checked the
schedule option, setup the time and frequency of the
backup. It worked properly. How does one go in and edit
or modify the schedule after it is created? I went to
the backup device but, it doesn't show my schedule name
or settings, in fact, it shows the schedule option
unchecked. Any ideas or is it a matter of deleting the
device and recreating it?
2. I want to have each full backup have the basic file
name but have a time stamp added into the name. It would
look something like: databasename_db_200408141830. 2004
is the year, 08 the month, 14 the day, 1830 the hour. I
have seen it done but do not know how to duplicate it.
By doing this, I can go back to previous backups if a
problem occurs. Once again, any ideas?inline...
HTH
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
"smantz" <smantz@.smhscs.org> wrote in message
news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> Sorry for the previous post. Here are the problems:
> 1. Using enterprise manager, I chose to backup a
> database. I picked my backup device and checked the
> schedule option, setup the time and frequency of the
> backup. It worked properly. How does one go in and edit
> or modify the schedule after it is created? I went to
> the backup device but, it doesn't show my schedule name
> or settings, in fact, it shows the schedule option
> unchecked. Any ideas or is it a matter of deleting the
> device and recreating it?
the device actually will not show anything until it has been initialized. if
you want to edit the backup job itself you will find it under the
management, SQL agent, jobs. you 'll find it there.

> 2. I want to have each full backup have the basic file
> name but have a time stamp added into the name. It would
> look something like: databasename_db_200408141830. 2004
> is the year, 08 the month, 14 the day, 1830 the hour. I
> have seen it done but do not know how to duplicate it.
> By doing this, I can go back to previous backups if a
> problem occurs. Once again, any ideas?
>
the best way to do this is to create the backup job in database management
section. here you can create a scheduled backup and it will automatically
append the date/time of the backup.|||sorry I should be a bit more specific. you should look for the database
maintenance plan wizard. it can reindex, update statistics, backup database
and tlogs, and send notifications of job completion (I like this last one,
sends me an e-mail over lunch that my tlog backup has completed successfully
or not. it does take a bit more setup for the mail portion).
I'm a huge fan of the Maint.wizards but it shouldn't be the only way you
create these jobs. give em a shot...
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
/* Check out the books on-line (BOL) for more one the above */
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:#3XtUUB$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> inline...
> HTH
> Neil MacMurchy
> Senior DBA
> Regional Municipality of Niagara
> "smantz" <smantz@.smhscs.org> wrote in message
> news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> the device actually will not show anything until it has been initialized.
if
> you want to edit the backup job itself you will find it under the
> management, SQL agent, jobs. you 'll find it there.
>
> the best way to do this is to create the backup job in database management
> section. here you can create a scheduled backup and it will automatically
> append the date/time of the backup.
>