I am trying to create subscription on report manager.
Getting this error: "Failure sending mail: The transport failed to connect to the server. ".
how to resolve this..
More and more often, I am seeing this error message in RS subscriptions. I would assume it means the IIS server can't connect to the corporate exchange server. However I was wondering if there is some timeout setting/configuration in RS or the IIS server (or any other kind of setting) I can change to help alleviate this problem.
Has anyone else experienced this? Or know how to fix it?
Thanks,
Jeff
UPDATE: After looking closer at the subscriptions, I have noticed that subscriptions set up by a RS Admin (who is also a server admin) seem to be working fine. It is the subscriptions that are set up by ordinary users that are failing...
I have Configured Configuration settings properly ,
I have did the sMTP settings correctly and I am able to send a mail from db(using send mail task).
I have facing this error since a long while configure the subscription in the ssrs report.
Error: Failure sending mail: The transport failed to connect to the server.
Due to this I am not able to send the subscription in the report..
I am Getting this error in SSRS Report Subscription. I went to Subscription table Checked the Laststatus. The LastStatus is :Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.
View 3 Replies View RelatedI recently started working on SSIS packages and I have a package which will Validate a table records and prepare a txt file with all details and sends the email to approriate email ids. The problem i'm facing is I'm getting System.Net.Mail.SmtpException with inner exception as A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xx.xx.xx.xx:25. I'm using SMTPConnection and Windows Authentication as credentials.I also add the ISServerExec.exe to the firewall exclusion list still it throws the same error.
View 3 Replies View RelatedDear all,
I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail.
but still the Mail Task is failing..
plz suggest.
Hi Everyone,
Hopefully someone out there will have an idea as this is driving me nuts.
I've setup a task to email on success/failure and keep receiving the following message when executed:
Progress: The SendMail task is initiated. - 0 percent complete
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".
Progress: The SendMail task is completed. - 100 percent complete
Task Send Mail Task failed
When I configure Outlook Express on the same machine with the same settings it works.
On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL.
On the Send Mail Task, it uses the above connection. The To: , From: , Subject fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc.
Nothing useful is logged in the Event Viewer even with full logging turned on.
Any suggestions appreciated,
Thanks.
I have a web page that contains a ReportViewer control. I am trying to display a report, which is an .rdl file located on the SSRS server, in this Report Viewer control. I have set the ReportPath and ReportServerUrl correctly. I am getting an error message.Am I suppose to use an .rdlc file rather than a .rdl file? Does the web server configuration need to use a certain account? I am getting the following error message:The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
View 4 Replies View RelatedHi All,
When I am execute the SSIS packages in my machine, it is working fine,
The SSIS package contains Send Mail task, but if the same application is executed by my colleague,
he is getting the error "Failure Sending mail", but he was able to execute the same application successfully previouly. but he can able to send the mail from his outlook.
Any suggestions appreciated.
Regards,
Nathan
I have had a development XP workstation with RS2000 and IIS sending reports via email for 6 months straight with no problems.
Today my subscriptions are failing with
Failure sending mail: The system cannot find the path specified.
Been searching and digging for hours, and if anyone has any ideas they are greatly appreciated.
I have to send mail with HTML format and attaching multiple files dynamically via send mail task.
View 10 Replies View Related
Hi all
When using a subscription to send mail, I find that the report can be sent in any format apart from Excel, which gives me the error: "Failure sending mail: Unspecified error". As you can imagine, this doesn't give me much to go on!
I want to use Excel format as it retains the drilldown functionality (hiding / unhiding rows). The ExecutionLog has the status as rsSuccess, but Subscription tab for the report shows the error.
Any thoughts would be most welcome!
Hello.
Thanks for any help anyone can offer me.
I have SQL Server Reporting services on Windows 2000.
The reports seem to be working well, but I cannot get a subscription to work. The error I get is the one in the subject line.
I look into my log files and see these lines.
ReportingServicesService!emailextension!ab0!12/07/2007-15:02:07:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
Can anyone help me out with this one?
Thanks.
deep
Hi all,
We receive this error from all subscriptons on this server. Any advice?
Error: "Failure sending mail: Interface not registered "
Thank you,
-Randy
Hi,
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I am using a direct connection from my Gridview to perform a huge database search. the stored procedure will take 10- 60 seconds to execute the query.
What the problem i am facing is when the sp takes long time (more than 1 minutes), then when i try any other operation like calling another sp frm another page, i am getting the above specified error.
Anybody can tell why is it happening?
here my code snippet goes
<asp:GridView ID="searchGV" runat="server" AllowPaging="True" AllowSorting="True"
BorderColor="#999999" BorderStyle="None" CellPadding="3" Width="100%" AutoGenerateColumns="False" DataSourceID="searchObj" DataKeyNames="Recordnumber" OnDataBound="searchGV_DataBound" OnPageIndexChanged="searchGV_PageIndexChanged">
<RowStyle CssClass="gridRow" />
<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />
<HeaderStyle CssClass="gridHeader" />
<AlternatingRowStyle CssClass="gridAlternateRow" />
<Columns>
<asp:TemplateField HeaderText="All">
<HeaderTemplate>
<asp:CheckBox ID="chkid" AutoPostBack="true" OnCheckedChanged ="OnCheckChangedEvent" runat="server" />
</HeaderTemplate>
<EditItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server"/>
</ItemTemplate>
<ControlStyle Height="18px" Width="15px" />
<ItemStyle Width="5px" />
</asp:TemplateField>
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title">
<ItemStyle Width="150px" />
</asp:BoundField>
<asp:BoundField DataField="Artist" HeaderText="Artist(s)" SortExpression="Artist"/>
<asp:BoundField DataField="Album" HeaderText="Album" SortExpression="Album"/>
<asp:BoundField DataField="Writer" HeaderText="Writer(s)" SortExpression="Writer" ><ItemStyle Width="150px" /></asp:BoundField>
<asp:BoundField DataField="ISRC" HeaderText="ISRC" SortExpression="ISRC" />
<asp:BoundField DataField="UPC" HeaderText="UPC" SortExpression="UPC"/>
<asp:BoundField DataField="PLineLabel" HeaderText="P-Line Label" SortExpression="PLineLabel" ><ItemStyle Width="100px" /></asp:BoundField>
<asp:BoundField DataField="DistLabel" HeaderText="Distribution Label" SortExpression="DistLabel" >
<ItemStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="PublishInfo" HeaderText="Publisher(s)" SortExpression="PublishInfo" />
<asp:BoundField DataField="Recordnumber" HeaderText="Record Number" SortExpression="Recordnumber" />
<%-- <asp:BoundField DataField="UID" HeaderText="UID" Visible="false" />--%>
</Columns>
</asp:GridView>
with adapter
<asp:SqlDataSource ID="searchObj" runat="server" SelectCommand="gsp_titleSearchResult" SelectCommandType="StoredProcedure" ConnectionString="<%$ ConnectionStrings:ConnStr %>">
<SelectParameters>
<asp:ControlParameter ControlID="HuserID" PropertyName="Value" Name="Userid" Type="String" Size="50" DefaultValue="" />
<asp:ControlParameter ControlID="Htitle" PropertyName="Value" Name="title" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hartist" PropertyName="Value" Name="artist" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Halbum" PropertyName="Value" Name="album" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hwriter" PropertyName="Value" Name="writer" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hisrc" PropertyName="Value" Name="isrc" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hupc" PropertyName="Value" Name="upc" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hpline" PropertyName="Value" Name="pline" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hdist" PropertyName="Value" Name="distlabel" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="Hpublish" PropertyName="Value" Name="publisher" Type="String" Size="50" DefaultValue=" " />
<asp:ControlParameter ControlID="ReleaseID" PropertyName="Value" Name="Releaseid" Type="Int32" Size="50" DefaultValue="0" />
<asp:ControlParameter ControlID="RecordLabelID" PropertyName="Value" Name="recordlabelid" Type="Int32" Size="50" DefaultValue="0" />
<asp:ControlParameter ControlID="PublisherID" PropertyName="Value" Name="Publisherid" Type="Int32" Size="50" DefaultValue="0" />
<asp:ControlParameter ControlID="ArtistID" PropertyName="Value" Name="Artistid" Type="Int32" Size="50" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
Advance thanks
Anvar Sadath
Hi all,
I am new to SQL 2005. I have one issue and it is as follows:
I write a simple query and run it; it works fine.
Now I break the network connection and run the query; in this case it runs fine.
But when I reconnect the network and run the query, then I get an error as follows:
"A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - An unexpected network error occurred.) "
Every thing is local here. So how the network issue comes here?
I've tried to search on the web for a solution for this error but i didn't find any working solutions for this problem. We have 2 servers. The first one is the server we use to develop our ASP.NET 2 application. On this server we don't have this error. On the other server (use by our client) we have this error sometime and i don't know why. Both servers have the same configuration and both application have the same web.config file.
I've tried to add a try-catch and retry the query when the error occured. This seems to be working but we don't want to have to change all our connections and since we don't have this problem on the other server we want to find the source of the problem.
Any idea ?
Thanks !
Hello,
On the development server, I am trying to work with subscriptions . Report Server is windows authenticated.
When no paramters exist for the report, the sucbscription is successful.
But if there are paramters for the report, email delivery fails.
These are not data driven subscriptions.
Did anyone face the same problem ? Can anyone tell me where to start debugging since logfiles just say failure to send the email.
Thanks,
SqlNew
I have a job that runs every 3 minutes. The email that I received said the job failed at 10:30 a.m. but when I run the "All executions report" I see a skip in the times from 10:27 to 10:33. That failed Job is not logged as an execution.I looked in the system event log and I do not see anything odd at that time.
View 2 Replies View RelatedWhen I deploy my project and click the Pull button I reached tis error:
Err number: 80072EFD
A request to send data to computer running IIS has failed
Minor err: 28037
Microsoft sql server mobile edition.
My code is:
createDB()
' Connection String to the SQL Server.
Dim rdaOleDbConnectString As String = _
"Provider=SQLOLEDB.1;Data Source=pcpc,1433;" & _
"Integrated Security=SSPI;Persist Security Info=true;Initial Catalog=periyodik;" & _
"User ID=sa;Password=;Connect timeout=180;"
Dim rda As SqlCeRemoteDataAccess = Nothing
Try
rda = New SqlCeRemoteDataAccess()
rda.InternetUrl = "http://192.168.2.3/SQLCE/sqlcesa30.dll"
rda.LocalConnectionString = _
"Data Source=My Documentsssce.sdf"
rda.Pull("isimler", "Select * from isimler", _
rdaOleDbConnectString, _
RdaTrackOption.TrackingOnWithIndexes, _
"ErrorTable")
MsgBox("Pull operation completed", _
MsgBoxStyle.Information, _
"Pull")
Catch err As SqlCeException
ShowErrors(err)
Finally
rda.Dispose()
End Try
Hello,
we have problem installing SP1, Reporting Services is not updated correctly.
what schould we do? below our log file:
Thank You for answer
Wojtek
06/29/2006 18:59:39.579 ================================================================================
06/29/2006 18:59:39.611 Hotfix package launched
06/29/2006 18:59:39.626 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:39.642 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:40.548 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:40.564 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:42.376 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:42.392 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:42.423 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:42.439 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:42.454 Local Computer:
06/29/2006 18:59:42.470 Target Details: xxxxxxxxxxx
06/29/2006 18:59:42.486 commonfilesdir = C:Program FilesCommon Files
06/29/2006 18:59:42.501 lcidsupportdir = d:8eab555422b5e3d6e18cd38a7afa281033
06/29/2006 18:59:42.517 programfilesdir = C:Program Files
06/29/2006 18:59:42.548 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:42.564 supportdirlocal = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:42.579 windir = C:WINDOWS
06/29/2006 18:59:42.595 winsysdir = C:WINDOWSsystem32
06/29/2006 18:59:42.611
06/29/2006 18:59:42.626 Enumerating applicable products for this patch
06/29/2006 18:59:42.673 Found Redist 2005 product definition
06/29/2006 18:59:42.907 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:42.923 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:42.939 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:42.970 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:43.564 Attempting to check IA 64 platform
06/29/2006 18:59:43.595 Result of IA64 check: 0
06/29/2006 18:59:43.626 Last error: 0
06/29/2006 18:59:43.657 Found Redist 2005 product definition
06/29/2006 18:59:43.704 Found Redist 2005 product definition
06/29/2006 18:59:43.751 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:43.767 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:43.798 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:43.814 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:44.142 Attempting to check IA 64 platform
06/29/2006 18:59:44.157 Result of IA64 check: 0
06/29/2006 18:59:44.189 Last error: 0
06/29/2006 18:59:44.220 Found SQL 2005 product definition
06/29/2006 18:59:46.189 Determining QFE level for product instance MSSQLSERVER
06/29/2006 18:59:46.282 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnSQLServr.exe
06/29/2006 18:59:46.314 Found following QFE level for product instance MSSQLSERVER: 2047
06/29/2006 18:59:46.345 Determining GDR branching Hotfix for product instance MSSQLSERVER
06/29/2006 18:59:46.361 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnSQLServr.exe
06/29/2006 18:59:46.376 No GDR branch Hotfix found for product instance MSSQLSERVER
06/29/2006 18:59:46.423 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:46.454 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:46.470 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:46.486 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:46.673 Attempting to check IA 64 platform
06/29/2006 18:59:46.689 Result of IA64 check: 0
06/29/2006 18:59:46.704 Last error: 0
06/29/2006 18:59:46.736 Found OLAP Server 2005 product definition
06/29/2006 18:59:47.532 Determining QFE level for product instance MSSQLSERVER
06/29/2006 18:59:47.564 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1OLAP\Binmsmdsrv.exe
06/29/2006 18:59:47.595 Found following QFE level for product instance MSSQLSERVER: 2047
06/29/2006 18:59:47.611 Determining GDR branching Hotfix for product instance MSSQLSERVER
06/29/2006 18:59:47.626 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1OLAP\Binmsmdsrv.exe
06/29/2006 18:59:47.642 No GDR branch Hotfix found for product instance MSSQLSERVER
06/29/2006 18:59:47.673 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:47.704 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:47.720 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:47.736 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:47.861 Attempting to check IA 64 platform
06/29/2006 18:59:47.876 Result of IA64 check: 0
06/29/2006 18:59:47.907 Last error: 0
06/29/2006 18:59:47.939 Found Notification Services 2005 product definition
06/29/2006 18:59:48.689 Determining QFE level for product instance
06/29/2006 18:59:48.736 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242\Binsservice.exe
06/29/2006 18:59:48.751 Found following QFE level for product instance : 2047
06/29/2006 18:59:48.767 Determining GDR branching Hotfix for product instance
06/29/2006 18:59:48.782 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242\Binsservice.exe
06/29/2006 18:59:48.814 No GDR branch Hotfix found for product instance
06/29/2006 18:59:48.845 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:48.861 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:48.876 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:48.892 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:49.017 Attempting to check IA 64 platform
06/29/2006 18:59:49.032 Result of IA64 check: 0
06/29/2006 18:59:49.064 Last error: 0
06/29/2006 18:59:49.079 Found Report Server 2005 product definition
06/29/2006 18:59:49.829 Determining QFE level for product instance MSSQLSERVER
06/29/2006 18:59:49.923 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services\ReportServerinReportingServicesService.exe
06/29/2006 18:59:49.986 Found following QFE level for product instance MSSQLSERVER: 1399
06/29/2006 18:59:50.048 Determining GDR branching Hotfix for product instance MSSQLSERVER
06/29/2006 18:59:50.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services\ReportServerinReportingServicesService.exe
06/29/2006 18:59:50.157 No GDR branch Hotfix found for product instance MSSQLSERVER
06/29/2006 18:59:50.220 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:50.251 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:50.282 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:50.314 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:50.470 Attempting to check IA 64 platform
06/29/2006 18:59:50.501 Result of IA64 check: 0
06/29/2006 18:59:50.517 Last error: 0
06/29/2006 18:59:50.548 Found DTS 2005 product definition
06/29/2006 18:59:51.361 Determining QFE level for product instance
06/29/2006 18:59:51.439 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTS\BinnDTSPipeline.dll
06/29/2006 18:59:51.454 Found following QFE level for product instance : 2047
06/29/2006 18:59:51.470 Determining GDR branching Hotfix for product instance
06/29/2006 18:59:51.501 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTS\BinnDTSPipeline.dll
06/29/2006 18:59:51.532 No GDR branch Hotfix found for product instance
06/29/2006 18:59:51.564 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:51.579 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:51.595 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:51.626 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:51.767 Attempting to check IA 64 platform
06/29/2006 18:59:51.798 Result of IA64 check: 0
06/29/2006 18:59:51.814 Last error: 0
06/29/2006 18:59:51.845 Found SQL 2005 Tools product definition
06/29/2006 18:59:52.657 Determining GDR branching Hotfix for product instance
06/29/2006 18:59:52.704 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Tools\BinnVSShellCommon7IDESQLWB.EXE
06/29/2006 18:59:52.736 No GDR branch Hotfix found for product instance
06/29/2006 18:59:52.767 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:52.798 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:52.814 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:52.845 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:52.986 Attempting to check IA 64 platform
06/29/2006 18:59:53.017 Result of IA64 check: 0
06/29/2006 18:59:53.048 Last error: 0
06/29/2006 18:59:53.079 Found Redist 2005 product definition
06/29/2006 18:59:53.126 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:53.142 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:53.157 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:53.189 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:53.282 Attempting to check IA 64 platform
06/29/2006 18:59:53.298 Result of IA64 check: 0
06/29/2006 18:59:53.314 Last error: 0
06/29/2006 18:59:53.329 Found Redist 2005 product definition
06/29/2006 18:59:53.376 Found Redist 2005 product definition
06/29/2006 18:59:53.423 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:53.454 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:53.470 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:53.486 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:53.579 Attempting to check IA 64 platform
06/29/2006 18:59:53.595 Result of IA64 check: 0
06/29/2006 18:59:53.611 Last error: 0
06/29/2006 18:59:53.642 Found Redist 2005 product definition
06/29/2006 18:59:53.689 Found Redist 2005 product definition
06/29/2006 18:59:53.720 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:53.751 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:53.767 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:53.782 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:53.892 Attempting to check IA 64 platform
06/29/2006 18:59:53.907 Result of IA64 check: 0
06/29/2006 18:59:53.923 Last error: 0
06/29/2006 18:59:53.939 Found Redist 2005 product definition
06/29/2006 18:59:53.970 Found Redist 2005 product definition
06/29/2006 18:59:54.001 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:54.032 Successfully read registry key: CommonFilesDir, string value = C:Program FilesCommon Files
06/29/2006 18:59:54.048 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
06/29/2006 18:59:54.079 Successfully read registry key: ProgramFilesDir, string value = C:Program Files
06/29/2006 18:59:54.142 Attempting to check IA 64 platform
06/29/2006 18:59:54.173 Result of IA64 check: 0
06/29/2006 18:59:54.189 Last error: 0
06/29/2006 18:59:54.220 Found Redist 2005 product definition
06/29/2006 18:59:54.251 Product Details:
06/29/2006 18:59:54.267 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlncli.inf
06/29/2006 18:59:54.282 alwaysinstall = 1
06/29/2006 18:59:54.314 baselinebuild = 1399
06/29/2006 18:59:54.329 build = 2047
06/29/2006 18:59:54.345 description = SQL Server Native Client
06/29/2006 18:59:54.361 details = Service Pack for Microsoft SQL Server Native Client.
06/29/2006 18:59:54.376 kbarticle = KB913090
06/29/2006 18:59:54.392 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:54.407 lcid = 1033
06/29/2006 18:59:54.439 legalproductname = Microsoft SQL Native Client
06/29/2006 18:59:54.470 machinetype = x86
06/29/2006 18:59:54.486 package = HotFixSqlncli
06/29/2006 18:59:54.501 packagetype = Hotfix
06/29/2006 18:59:54.517 productcode = {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
06/29/2006 18:59:54.532 productname = Redist9
06/29/2006 18:59:54.548 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 18:59:54.564 splevel = 0,1
06/29/2006 18:59:54.595 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:54.611 upgradecode = {A6B19337-7392-4765-8675-5C25B758BA37}
06/29/2006 18:59:54.626 version = 9
06/29/2006 18:59:54.642
06/29/2006 18:59:54.657 File Group Details: MSI
06/29/2006 18:59:54.689 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 18:59:54.704 File Details: sqlncli.msi
06/29/2006 18:59:54.720
06/29/2006 18:59:54.736 Instance Details: SQL Server Native Client
06/29/2006 18:59:54.751 productcode = {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
06/29/2006 18:59:54.767
06/29/2006 18:59:54.798 Product Details:
06/29/2006 18:59:54.814 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlncli_x64.inf
06/29/2006 18:59:54.829 alwaysinstall = 1
06/29/2006 18:59:54.845 baselinebuild = 1399
06/29/2006 18:59:54.861 build = 2047
06/29/2006 18:59:54.876 description = SQL Server Native Client (64-bit)
06/29/2006 18:59:54.907 details = Service Pack for Microsoft SQL Server Native Client.
06/29/2006 18:59:54.923 kbarticle = KB913090
06/29/2006 18:59:54.939 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:54.954 lcid = 1033
06/29/2006 18:59:54.970 legalproductname = Microsoft SQL Native Client (64-bit)
06/29/2006 18:59:55.001 machinetype = x64
06/29/2006 18:59:55.017 package = HotFixSqlncli_x64
06/29/2006 18:59:55.032 packagetype = Hotfix
06/29/2006 18:59:55.048 productname = Redist9
06/29/2006 18:59:55.064 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 18:59:55.079 splevel = 0,1
06/29/2006 18:59:55.111 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:55.126 upgradecode = {6EC3319D-84BE-4C32-AA91-7D6057CF05A5}
06/29/2006 18:59:55.142 version = 9
06/29/2006 18:59:55.157
06/29/2006 18:59:55.173 File Group Details: MSI
06/29/2006 18:59:55.204 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 18:59:55.220 File Details: sqlncli_x64.msi
06/29/2006 18:59:55.236
06/29/2006 18:59:55.251 Product Details:
06/29/2006 18:59:55.282 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlSupport.inf
06/29/2006 18:59:55.314 alwaysinstall = 1
06/29/2006 18:59:55.345 baselinebuild = 1399
06/29/2006 18:59:55.361 build = 2047
06/29/2006 18:59:55.392 description = Setup Support Files
06/29/2006 18:59:55.407 details = Service Pack for the SQL Server support files.
06/29/2006 18:59:55.439 kbarticle = KB913090
06/29/2006 18:59:55.470 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:55.501 keyqualifier = 1
06/29/2006 18:59:55.517 lcid = 1033
06/29/2006 18:59:55.548 legalproductname = SQL Server 2005 Setup Support Files
06/29/2006 18:59:55.579 machinetype = x86
06/29/2006 18:59:55.611 package = HotFixSqlSupport
06/29/2006 18:59:55.626 packagetype = Hotfix
06/29/2006 18:59:55.642 productcode = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
06/29/2006 18:59:55.673 productname = Redist9
06/29/2006 18:59:55.689 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 18:59:55.720 splevel = 0,1
06/29/2006 18:59:55.751 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:55.767 upgradecode = {3A91FA19-A197-467C-850F-0AFE90899371}
06/29/2006 18:59:55.782 version = 9
06/29/2006 18:59:55.814
06/29/2006 18:59:55.829 File Group Details: MSP
06/29/2006 18:59:55.861 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 18:59:55.892 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 18:59:55.907 File Details: SqlSupport.msp
06/29/2006 18:59:55.939
06/29/2006 18:59:55.954 Instance Details: Setup Support Files
06/29/2006 18:59:55.986 productcode = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
06/29/2006 18:59:56.017
06/29/2006 18:59:56.032 Product Details:
06/29/2006 18:59:56.048 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSQL.inf
06/29/2006 18:59:56.079 baselinebuild = 1399
06/29/2006 18:59:56.095 baselinebuildmax = 2047
06/29/2006 18:59:56.111 build = 2047
06/29/2006 18:59:56.142 description = Database Services
06/29/2006 18:59:56.157 details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
06/29/2006 18:59:56.189 kbarticle = KB913090
06/29/2006 18:59:56.204 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:56.236 lcid = 1033
06/29/2006 18:59:56.267 legalproductname = SQL Server Database Services 2005
06/29/2006 18:59:56.282 machinetype = x86
06/29/2006 18:59:56.298 package = HotFixSQL
06/29/2006 18:59:56.329 packagetype = Hotfix
06/29/2006 18:59:56.345 productname = SQL9
06/29/2006 18:59:56.361 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 18:59:56.392 splevel = 0,1
06/29/2006 18:59:56.423 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:56.439 validateauthentication = true
06/29/2006 18:59:56.454 version = 9
06/29/2006 18:59:56.486
06/29/2006 18:59:56.517 File Group Details: MSP
06/29/2006 18:59:56.532 lockedfilecheck = 1
06/29/2006 18:59:56.548 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 18:59:56.579 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 18:59:56.611 File Details: sqlrun_sql.msp
06/29/2006 18:59:56.626
06/29/2006 18:59:56.657 Instance Details: MSSQLSERVER
06/29/2006 18:59:56.673 agentservicename = SQLSERVERAGENT
06/29/2006 18:59:56.704 associatedhotfixbuild = 0
06/29/2006 18:59:56.720 clustername =
06/29/2006 18:59:56.751 default = TRUE
06/29/2006 18:59:56.782 ftsservicename = MSFTESQL
06/29/2006 18:59:56.798 hiveregpath = SoftwareMicrosoftMicrosoft SQL ServerMSSQL.2
06/29/2006 18:59:56.814 id = MSSQL.2
06/29/2006 18:59:56.845 installsqldatadir = C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQL
06/29/2006 18:59:56.861 installsqldir = C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQL
06/29/2006 18:59:56.876 lcid = 1033
06/29/2006 18:59:56.907 name = MSSQLSERVER
06/29/2006 18:59:56.939 productcode = {EB76B218-8FC5-41DF-9F1F-7FF3E0448383}
06/29/2006 18:59:56.954 qfelevel = 2047
06/29/2006 18:59:56.970 servicename = MSSQLServer
06/29/2006 18:59:57.001 sku = ENTERPRISE
06/29/2006 18:59:57.032 sp = 1
06/29/2006 18:59:57.048 type = SQL Server Standalone Product
06/29/2006 18:59:57.079 vermajbld = 2047
06/29/2006 18:59:57.095 version = 9
06/29/2006 18:59:57.110
06/29/2006 18:59:57.142 Product Details:
06/29/2006 18:59:57.173 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixAS.inf
06/29/2006 18:59:57.189 baselinebuild = 1399
06/29/2006 18:59:57.220 baselinebuildmax = 2047
06/29/2006 18:59:57.235 build = 2047
06/29/2006 18:59:57.267 description = Analysis Services
06/29/2006 18:59:57.298 details = Service Pack for Analysis Services, and the tools used to support online analytical processing (OLAP) and data mining.
06/29/2006 18:59:57.314 kbarticle = KB913090
06/29/2006 18:59:57.345 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:57.392 lcid = 1033
06/29/2006 18:59:57.423 legalproductname = SQL Server Analysis Services 2005
06/29/2006 18:59:57.439 machinetype = x86
06/29/2006 18:59:57.470 package = HotFixAS
06/29/2006 18:59:57.501 packagetype = Hotfix
06/29/2006 18:59:57.517 productname = OLAP9
06/29/2006 18:59:57.532 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 18:59:57.564 splevel = 0,1
06/29/2006 18:59:57.595 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:57.610 version = 9
06/29/2006 18:59:57.642
06/29/2006 18:59:57.657 File Group Details: MSP
06/29/2006 18:59:57.673 lockedfilecheck = 1
06/29/2006 18:59:57.704 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 18:59:57.735 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 18:59:57.751 File Details: sqlrun_as.msp
06/29/2006 18:59:57.782
06/29/2006 18:59:57.798 Instance Details: MSSQLSERVER
06/29/2006 18:59:57.814 associatedhotfixbuild = 0
06/29/2006 18:59:57.845 clustername =
06/29/2006 18:59:57.860 default = TRUE
06/29/2006 18:59:57.876 hiveregpath = SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1
06/29/2006 18:59:57.907 id = MSSQL.1
06/29/2006 18:59:57.923 installsqldatadir = C:Program FilesMicrosoft SQL Server
06/29/2006 18:59:57.954 installsqldir = C:Program FilesMicrosoft SQL ServerMSSQL.1OLAP
06/29/2006 18:59:57.970 lcid = 1033
06/29/2006 18:59:58.001 name = MSSQLSERVER
06/29/2006 18:59:58.017 olapservicename = MSSQLServerOLAPService
06/29/2006 18:59:58.032 productcode = {52B0D62A-860D-4136-9A8A-9FD877E8EE89}
06/29/2006 18:59:58.064 qfelevel = 2047
06/29/2006 18:59:58.079 servicename = MSSQLServerOLAPService
06/29/2006 18:59:58.110 sku = ENTERPRISE
06/29/2006 18:59:58.126 sp = 1
06/29/2006 18:59:58.157 type = Olap Standalone Product
06/29/2006 18:59:58.173 vermajbld = 2047
06/29/2006 18:59:58.204 version = 9
06/29/2006 18:59:58.220
06/29/2006 18:59:58.251 Product Details:
06/29/2006 18:59:58.267 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixNS.inf
06/29/2006 18:59:58.282 baselinebuild = 1399
06/29/2006 18:59:58.314 baselinebuildmax = 2047
06/29/2006 18:59:58.329 build = 2047
06/29/2006 18:59:58.360 description = Notification Services
06/29/2006 18:59:58.376 details = Service Pack for Notification Services, a platform for developing and deploying applications that send personalized, timely notifications to a variety of devices or applications.
06/29/2006 18:59:58.392 kbarticle = KB913090
06/29/2006 18:59:58.423 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:58.439 lcid = 1033
06/29/2006 18:59:58.470 legalproductname = SQL Server Notification Services 2005 instances
06/29/2006 18:59:58.501 machinetype = x86
06/29/2006 18:59:58.517 package = HotFixNS
06/29/2006 18:59:58.548 packagetype = Hotfix
06/29/2006 18:59:58.595 productname = NS9
06/29/2006 18:59:58.642 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 18:59:58.720 splevel = 0,1
06/29/2006 18:59:58.767 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 18:59:58.814 version = 9
06/29/2006 18:59:58.829
06/29/2006 18:59:58.860 File Group Details: MSP
06/29/2006 18:59:58.876 lockedfilecheck = 1
06/29/2006 18:59:58.907 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 18:59:58.923 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 18:59:58.954 File Details: sqlrun_ns.msp
06/29/2006 18:59:58.970
06/29/2006 18:59:58.985 Instance Details: NS
06/29/2006 18:59:59.157 associatedhotfixbuild = 0
06/29/2006 18:59:59.235 clustername =
06/29/2006 18:59:59.282 hiveregpath = SoftwareMicrosoftMicrosoft SQL Server90NS
06/29/2006 18:59:59.329 id =
06/29/2006 18:59:59.392 installsqldatadir =
06/29/2006 18:59:59.423 installsqldir = C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242
06/29/2006 18:59:59.501 lcid = 1033
06/29/2006 18:59:59.517 name =
06/29/2006 18:59:59.532 productcode = {C0B81E26-F7D0-4E84-941A-21C438BC586D}
06/29/2006 18:59:59.548 qfelevel = 2047
06/29/2006 18:59:59.564 sku = ENTERPRISE
06/29/2006 18:59:59.595 sp = 1
06/29/2006 18:59:59.610 type = Tools Only
06/29/2006 18:59:59.626 vermajbld = 2047
06/29/2006 18:59:59.642 version = 9
06/29/2006 18:59:59.657
06/29/2006 18:59:59.673 Product Details:
06/29/2006 18:59:59.720 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixRS.inf
06/29/2006 18:59:59.735 baselinebuild = 1399
06/29/2006 18:59:59.751 baselinebuildmax = 2047
06/29/2006 18:59:59.767 build = 2047
06/29/2006 18:59:59.782 description = Reporting Services
06/29/2006 18:59:59.814 details = Service Pack for the Report Server and Report Builder, which manages, executes, renders, and distributes reports.
06/29/2006 18:59:59.829 kbarticle = KB913090
06/29/2006 18:59:59.845 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 18:59:59.860 lcid = 1033
06/29/2006 18:59:59.876 legalproductname = SQL Server Reporting Services 2005
06/29/2006 18:59:59.892 machinetype = x86
06/29/2006 18:59:59.923 package = HotFixRS
06/29/2006 18:59:59.954 packagetype = Hotfix
06/29/2006 18:59:59.970 productname = RS9
06/29/2006 18:59:59.985 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:00.001 splevel = 0,1
06/29/2006 19:00:00.079 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:00.110 validateauthentication = 1
06/29/2006 19:00:00.126 version = 9
06/29/2006 19:00:00.142
06/29/2006 19:00:00.157 File Group Details: MSP
06/29/2006 19:00:00.173 lockedfilecheck = 1
06/29/2006 19:00:00.204 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 19:00:00.220 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:00.235 File Details: sqlrun_rs.msp
06/29/2006 19:00:00.251
06/29/2006 19:00:00.267 Instance Details: MSSQLSERVER
06/29/2006 19:00:00.282 clustername =
06/29/2006 19:00:00.298 default = TRUE
06/29/2006 19:00:00.329 hiveregpath = SoftwareMicrosoftMicrosoft SQL ServerMSSQL.3
06/29/2006 19:00:00.345 id = MSSQL.3
06/29/2006 19:00:00.360 installsqldatadir =
06/29/2006 19:00:00.376 installsqldir = C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services
06/29/2006 19:00:00.407 lcid = 1033
06/29/2006 19:00:00.423 name = MSSQLSERVER
06/29/2006 19:00:00.439 productcode = {7D7E6D55-E338-4B4C-AD91-E750BFD2BA4C}
06/29/2006 19:00:00.454 qfelevel = 1399
06/29/2006 19:00:00.470 rsservicename = ReportServer
06/29/2006 19:00:00.501 servicename =
06/29/2006 19:00:00.517 sku = ENTERPRISE
06/29/2006 19:00:00.532 sp = 0
06/29/2006 19:00:00.548 type = Report Server Standalone Product
06/29/2006 19:00:00.579 vermajbld = 1399
06/29/2006 19:00:00.595 version = 9
06/29/2006 19:00:00.626
06/29/2006 19:00:00.642 Product Details:
06/29/2006 19:00:00.657 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixDTS.inf
06/29/2006 19:00:00.673 baselinebuild = 1399
06/29/2006 19:00:00.704 baselinebuildmax = 2047
06/29/2006 19:00:00.735 build = 2047
06/29/2006 19:00:00.767 description = Integration Services
06/29/2006 19:00:00.782 details = Service Pack for Integration Services, a set of tools and programmable objects used to create and manage packages that extract, transform, and load data, as well as perform tasks.
06/29/2006 19:00:00.798 kbarticle = KB913090
06/29/2006 19:00:00.829 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:00.860 lcid = 1033
06/29/2006 19:00:00.892 legalproductname = SQL Server Integration Services 2005
06/29/2006 19:00:00.907 machinetype = x86
06/29/2006 19:00:00.939 package = HotFixDTS
06/29/2006 19:00:00.970 packagetype = Hotfix
06/29/2006 19:00:00.985 productname = DTS9
06/29/2006 19:00:01.064 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:01.110 splevel = 0,1
06/29/2006 19:00:01.157 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:01.204 version = 9
06/29/2006 19:00:01.251
06/29/2006 19:00:01.282 File Group Details: MSP
06/29/2006 19:00:01.360 lockedfilecheck = 1
06/29/2006 19:00:01.392 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 19:00:01.407 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:01.423 File Details: sqlrun_dts.msp
06/29/2006 19:00:01.454
06/29/2006 19:00:01.485 Instance Details: DTS
06/29/2006 19:00:01.517 associatedhotfixbuild = 0
06/29/2006 19:00:01.532 clustername =
06/29/2006 19:00:01.548 dtsservicename = MsDtsServer
06/29/2006 19:00:01.579 hiveregpath = SoftwareMicrosoftMicrosoft SQL Server90DTS
06/29/2006 19:00:01.595 id =
06/29/2006 19:00:01.626 installsqldatadir =
06/29/2006 19:00:01.642 installsqldir = C:Program FilesMicrosoft SQL Server90DTS
06/29/2006 19:00:01.657 lcid = 1033
06/29/2006 19:00:01.689 name =
06/29/2006 19:00:01.704 productcode = {8E408A85-E0E5-4094-903F-8675707AC313}
06/29/2006 19:00:01.735 qfelevel = 2047
06/29/2006 19:00:01.767 servicename = MsDtsServer
06/29/2006 19:00:01.782 sku = ENTERPRISE
06/29/2006 19:00:01.798 sp = 1
06/29/2006 19:00:01.829 type = Tools Only
06/29/2006 19:00:01.845 vermajbld = 2047
06/29/2006 19:00:01.876 version = 9
06/29/2006 19:00:01.892
06/29/2006 19:00:01.907 Product Details:
06/29/2006 19:00:01.939 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixTools.inf
06/29/2006 19:00:01.954 baselinebuild = 1399
06/29/2006 19:00:01.970 baselinebuildmax = 2047
06/29/2006 19:00:02.017 build = 2047
06/29/2006 19:00:02.064 description = Client Components
06/29/2006 19:00:02.110 details = Service Pack for the interactive management tools for running SQL Server, including SQL Server Configuration Manager, SQL Server Management Studio, SQL Profiler, and Replication Monitor.
06/29/2006 19:00:02.157 kbarticle = KB913090
06/29/2006 19:00:02.204 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:02.235 lcid = 1033
06/29/2006 19:00:02.251 legalproductname = SQL Server Tools and Workstation Components 2005
06/29/2006 19:00:02.282 machinetype = x86
06/29/2006 19:00:02.298 package = HotFixTools
06/29/2006 19:00:02.314 packagetype = Hotfix
06/29/2006 19:00:02.345 productname = SQLTools9
06/29/2006 19:00:02.376 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:02.407 splevel = 0,1
06/29/2006 19:00:02.423 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:02.454 version = 9
06/29/2006 19:00:02.470
06/29/2006 19:00:02.517 File Group Details: MSP
06/29/2006 19:00:02.532 lockedfilecheck = 1
06/29/2006 19:00:02.564 parameters = SQLBUILD=2047 KBNUMBER=KB913090 REBOOT=ReallySuppress
06/29/2006 19:00:02.579 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:02.610 File Details: sqlrun_tools.msp
06/29/2006 19:00:02.642
06/29/2006 19:00:02.673 Instance Details: SQL Tools
06/29/2006 19:00:02.689 associatedhotfixbuild = 0
06/29/2006 19:00:02.720 clustername =
06/29/2006 19:00:02.735 hiveregpath = SoftwareMicrosoftMicrosoft SQL Server90Tools
06/29/2006 19:00:02.767 id =
06/29/2006 19:00:02.798 installsqldatadir =
06/29/2006 19:00:02.814 installsqldir = C:Program FilesMicrosoft SQL Server90Tools
06/29/2006 19:00:02.845 lcid = 1033
06/29/2006 19:00:02.860 name =
06/29/2006 19:00:02.892 productcode = {4D2DFB70-AECB-47BF-A895-3B3AA544934F}
06/29/2006 19:00:02.923 qfelevel = 2047
06/29/2006 19:00:02.954 sku = ENTERPRISE
06/29/2006 19:00:02.970 sp = 1
06/29/2006 19:00:03.017 type = Tools Only
06/29/2006 19:00:03.064 vermajbld = 2047
06/29/2006 19:00:03.095 version = 9
06/29/2006 19:00:03.157
06/29/2006 19:00:03.189 Product Details:
06/29/2006 19:00:03.220 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixMsxml6.inf
06/29/2006 19:00:03.235 baselinebuild = 1399
06/29/2006 19:00:03.267 build = 2047
06/29/2006 19:00:03.298 description = MSXML 6.0 Parser
06/29/2006 19:00:03.329 details = Service Pack for Microsoft XML 6.0 Parser.
06/29/2006 19:00:03.345 kbarticle = KB913090
06/29/2006 19:00:03.376 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:03.407 lcid = 1033
06/29/2006 19:00:03.423 legalproductname = MSXML 6.0 Parser
06/29/2006 19:00:03.454 machinetype = x86
06/29/2006 19:00:03.485 package = HotFixMsxml6
06/29/2006 19:00:03.501 packagetype = Hotfix
06/29/2006 19:00:03.532 productcode = {AEB9948B-4FF2-47C9-990E-47014492A0FE}
06/29/2006 19:00:03.564 productname = Redist9
06/29/2006 19:00:03.595 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:03.610 splevel = 0,1
06/29/2006 19:00:03.642 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:03.673 upgradecode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B}
06/29/2006 19:00:03.689 version = 9
06/29/2006 19:00:03.720
06/29/2006 19:00:03.751 File Group Details: MSI
06/29/2006 19:00:03.767 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:03.798 File Details: msxml6.msi
06/29/2006 19:00:03.829
06/29/2006 19:00:03.845 Instance Details: MSXML 6.0 Parser
06/29/2006 19:00:03.876 productcode = {AEB9948B-4FF2-47C9-990E-47014492A0FE}
06/29/2006 19:00:03.907
06/29/2006 19:00:03.939 Product Details:
06/29/2006 19:00:03.954 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixMsxml6_x64.inf
06/29/2006 19:00:03.985 baselinebuild = 1399
06/29/2006 19:00:04.017 build = 2047
06/29/2006 19:00:04.079 description = MSXML 6.0 Parser (64-bit)
06/29/2006 19:00:04.126 details = Service Pack for Microsoft XML 6.0 Parser.
06/29/2006 19:00:04.173 kbarticle = KB913090
06/29/2006 19:00:04.189 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:04.220 lcid = 1033
06/29/2006 19:00:04.235 legalproductname = MSXML 6.0 Parser (64-bit)
06/29/2006 19:00:04.251 machinetype = x64
06/29/2006 19:00:04.282 package = HotFixMsxml6_x64
06/29/2006 19:00:04.314 packagetype = Hotfix
06/29/2006 19:00:04.329 productname = Redist9
06/29/2006 19:00:04.360 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:04.376 splevel = 0,1
06/29/2006 19:00:04.407 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:04.439 upgradecode = {5BBED1F8-E6F3-4A02-BC97-26D35BE200CA}
06/29/2006 19:00:04.454 version = 9
06/29/2006 19:00:04.485
06/29/2006 19:00:04.517 File Group Details: MSI
06/29/2006 19:00:04.532 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:04.564 File Details: msxml6_x64.msi
06/29/2006 19:00:04.595
06/29/2006 19:00:04.610 Product Details:
06/29/2006 19:00:04.642 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlxml4.inf
06/29/2006 19:00:04.657 baselinebuild = 1399
06/29/2006 19:00:04.689 build = 2047
06/29/2006 19:00:04.720 description = SQLXML4
06/29/2006 19:00:04.735 details = Service Pack for Microsoft SQLXML 4.0.
06/29/2006 19:00:04.767 kbarticle = KB913090
06/29/2006 19:00:04.782 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:04.814 lcid = 1033
06/29/2006 19:00:04.845 legalproductname = SQLXML4
06/29/2006 19:00:04.860 machinetype = x86
06/29/2006 19:00:04.892 package = HotFixSqlxml4
06/29/2006 19:00:04.907 packagetype = Hotfix
06/29/2006 19:00:04.954 productcode = {A188FCCF-E929-494D-B1F1-4313E02ACD52}
06/29/2006 19:00:04.970 productname = Redist9
06/29/2006 19:00:05.001 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:05.048 splevel = 0,1
06/29/2006 19:00:05.079 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:05.110 upgradecode = {D9CA3D82-6F1B-41A7-8141-B90ACA8F865B}
06/29/2006 19:00:05.173 version = 9
06/29/2006 19:00:05.189
06/29/2006 19:00:05.220 File Group Details: MSI
06/29/2006 19:00:05.235 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:05.267 File Details: sqlxml4.msi
06/29/2006 19:00:05.282
06/29/2006 19:00:05.314 Instance Details: SQLXML4
06/29/2006 19:00:05.345 productcode = {A188FCCF-E929-494D-B1F1-4313E02ACD52}
06/29/2006 19:00:05.360
06/29/2006 19:00:05.392 Product Details:
06/29/2006 19:00:05.407 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlxml4_x64.inf
06/29/2006 19:00:05.439 baselinebuild = 1399
06/29/2006 19:00:05.470 build = 2047
06/29/2006 19:00:05.485 description = SQLXML4 (64-bit)
06/29/2006 19:00:05.517 details = Service Pack for Microsoft SQLXML 4.0.
06/29/2006 19:00:05.532 kbarticle = KB913090
06/29/2006 19:00:05.564 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:05.595 lcid = 1033
06/29/2006 19:00:05.610 legalproductname = SQLXML4 (64-bit)
06/29/2006 19:00:05.642 machinetype = x64
06/29/2006 19:00:05.657 package = HotFixSqlxml4_x64
06/29/2006 19:00:05.689 packagetype = Hotfix
06/29/2006 19:00:05.720 productname = Redist9
06/29/2006 19:00:05.735 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:05.767 splevel = 0,1
06/29/2006 19:00:05.782 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:05.814 upgradecode = {F457D8E6-7686-437D-9B17-E21D45CCABD8}
06/29/2006 19:00:05.845 version = 9
06/29/2006 19:00:05.860
06/29/2006 19:00:05.892 File Group Details: MSI
06/29/2006 19:00:05.907 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:05.939 File Details: sqlxml4_x64.msi
06/29/2006 19:00:05.970
06/29/2006 19:00:05.985 Product Details:
06/29/2006 19:00:06.017 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSQLServer2005_BC.inf
06/29/2006 19:00:06.064 baselinebuild = 1399
06/29/2006 19:00:06.095 build = 2047
06/29/2006 19:00:06.110 description = Backward Compatibility
06/29/2006 19:00:06.142 details = Service Pack for the Backward Compatibility components, including Data Transformation Services Runtime and SQL-DMO.
06/29/2006 19:00:06.157 kbarticle = KB913090
06/29/2006 19:00:06.189 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:06.220 lcid = 1033
06/29/2006 19:00:06.235 legalproductname = Microsoft SQL Server 2005 Backward Compatibility
06/29/2006 19:00:06.267 machinetype = x86
06/29/2006 19:00:06.282 package = HotFixSQLServer2005_BC
06/29/2006 19:00:06.314 packagetype = Hotfix
06/29/2006 19:00:06.345 productcode = {2243F21A-E132-44F7-BA13-024D0845C815}
06/29/2006 19:00:06.360 productname = Redist9
06/29/2006 19:00:06.392 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:06.407 splevel = 0,1
06/29/2006 19:00:06.439 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:06.454 upgradecode = {1E70C6C9-E1B7-4A74-BC8C-8EB5D010CEC9}
06/29/2006 19:00:06.485 version = 9
06/29/2006 19:00:06.517
06/29/2006 19:00:06.532 File Group Details: MSI
06/29/2006 19:00:06.564 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:06.579 File Details: SQLServer2005_BC.msi
06/29/2006 19:00:06.610
06/29/2006 19:00:06.642 Instance Details: Backward Compatibility
06/29/2006 19:00:06.657 productcode = {2243F21A-E132-44F7-BA13-024D0845C815}
06/29/2006 19:00:06.689
06/29/2006 19:00:06.704 Product Details:
06/29/2006 19:00:06.735 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSQLServer2005_BC_x64.inf
06/29/2006 19:00:06.751 baselinebuild = 1399
06/29/2006 19:00:06.782 build = 2047
06/29/2006 19:00:06.798 description = Backward Compatibility (64-bit)
06/29/2006 19:00:06.829 details = Service Pack for the Backward Compatibility components, including Data Transformation Services Runtime and SQL-DMO.
06/29/2006 19:00:06.860 kbarticle = KB913090
06/29/2006 19:00:06.876 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:06.907 lcid = 1033
06/29/2006 19:00:06.923 legalproductname = Microsoft SQL Server 2005 Backward Compatibility (64-bit)
06/29/2006 19:00:06.954 machinetype = x64
06/29/2006 19:00:06.985 package = HotFixSQLServer2005_BC_x64
06/29/2006 19:00:07.017 packagetype = Hotfix
06/29/2006 19:00:07.064 productname = Redist9
06/29/2006 19:00:07.095 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:07.126 splevel = 0,1
06/29/2006 19:00:07.142 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:07.173 upgradecode = {7B6BF434-3C72-4DB3-8049-FEF31AEAFF9A}
06/29/2006 19:00:07.189 version = 9
06/29/2006 19:00:07.220
06/29/2006 19:00:07.251 File Group Details: MSI
06/29/2006 19:00:07.267 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:07.298 File Details: SQLServer2005_BC_x64.msi
06/29/2006 19:00:07.329
06/29/2006 19:00:07.360 Product Details:
06/29/2006 19:00:07.439 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlWriter.inf
06/29/2006 19:00:07.470 baselinebuild = 1399
06/29/2006 19:00:07.501 build = 2047
06/29/2006 19:00:07.517 description = Microsoft SQL Server VSS Writer
06/29/2006 19:00:07.548 details = Service Pack for Microsoft SQL Server VSS Writer.
06/29/2006 19:00:07.579 kbarticle = KB913090
06/29/2006 19:00:07.595 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:07.626 lcid = 1033
06/29/2006 19:00:07.657 legalproductname = Microsoft SQL Server VSS Writer
06/29/2006 19:00:07.673 machinetype = x86
06/29/2006 19:00:07.704 package = HotFixSqlWriter
06/29/2006 19:00:07.735 packagetype = Hotfix
06/29/2006 19:00:07.767 productcode = {C0D2F614-5CE5-4DCB-8678-E5C9AF7044F8}
06/29/2006 19:00:07.782 productname = Redist9
06/29/2006 19:00:07.814 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:07.829 splevel = 0,1
06/29/2006 19:00:07.860 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:07.892 upgradecode = {65D8E1DF-6201-4B53-A0F9-E654F8E80F97}
06/29/2006 19:00:07.923 version = 9
06/29/2006 19:00:07.939
06/29/2006 19:00:07.970 File Group Details: MSI
06/29/2006 19:00:08.017 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:08.064 File Details: SqlWriter.msi
06/29/2006 19:00:08.110
06/29/2006 19:00:08.142 Instance Details: Microsoft SQL Server VSS Writer
06/29/2006 19:00:08.173 productcode = {C0D2F614-5CE5-4DCB-8678-E5C9AF7044F8}
06/29/2006 19:00:08.189
06/29/2006 19:00:08.220 Product Details:
06/29/2006 19:00:08.251 INF File Name: d:8eab555422b5e3d6e18cd38a7afa28HotFixSqlWriter_x64.inf
06/29/2006 19:00:08.282 baselinebuild = 1399
06/29/2006 19:00:08.298 build = 2047
06/29/2006 19:00:08.329 description = Microsoft SQL Server VSS Writer (64-bit)
06/29/2006 19:00:08.360 details = Service Pack for Microsoft SQL Server VSS Writer.
06/29/2006 19:00:08.392 kbarticle = KB913090
06/29/2006 19:00:08.407 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
06/29/2006 19:00:08.439 lcid = 1033
06/29/2006 19:00:08.454 legalproductname = Microsoft SQL Server VSS Writer (64-bit)
06/29/2006 19:00:08.485 machinetype = x64
06/29/2006 19:00:08.517 package = HotFixSqlWriter_x64
06/29/2006 19:00:08.548 packagetype = Hotfix
06/29/2006 19:00:08.564 productname = Redist9
06/29/2006 19:00:08.595 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
06/29/2006 19:00:08.610 splevel = 0,1
06/29/2006 19:00:08.642 supportdir = d:8eab555422b5e3d6e18cd38a7afa28
06/29/2006 19:00:08.673 upgradecode = {E9031696-DD39-4C25-BAEB-425FF28279EA}
06/29/2006 19:00:08.689 version = 9
06/29/2006 19:00:08.720
06/29/2006 19:00:08.735 File Group Details: MSI
06/29/2006 19:00:08.767 sourcepath = <SUPPORTDIR><PACKAGE>Files
06/29/2006 19:00:08.798 File Details: SqlWriter_x64.msi
06/29/2006 19:00:08.814
06/29/2006 19:00:08.845 Authenticating user using Windows Authentication
06/29/2006 19:00:08.876 SQL Service MSSQLServer was previously running, ready for authentication
06/29/2006 19:00:08.907 SQL Agent Service SQLSERVERAGENT was previously running
06/29/2006 19:00:09.423 User authentication was successful
06/29/2006 19:00:09.439 Attempting to install product: Redist9
06/29/2006 19:00:13.235 Successfully installed product: Redist9
06/29/2006 19:00:13.251 Attempting to install product: Redist9
06/29/2006 19:00:18.079 Successfully installed product: Redist9
06/29/2006 19:00:18.142 Attempting to install product: SQL9
06/29/2006 19:03:29.328 Successfully installed product: SQL9
06/29/2006 19:03:29.375 Attempting to install product: OLAP9
06/29/2006 19:04:45.906 Successfully installed product: OLAP9
06/29/2006 19:04:45.921 Attempting to install product: RS9
06/29/2006 19:05:13.952 Successfully installed product: RS9
06/29/2006 19:05:13.983 Attempting to install product: NS9
06/29/2006 19:06:11.999 Successfully installed product: NS9
06/29/2006 19:06:12.030 Attempting to install product: DTS9
06/29/2006 19:08:03.842 Successfully installed product: DTS9
06/29/2006 19:08:03.857 Attempting to install product: SQLTools9
06/29/2006 19:12:20.746 Successfully installed product: SQLTools9
06/29/2006 19:12:20.778 Attempting to install product: Redist9
06/29/2006 19:12:24.637 Successfully installed product: Redist9
06/29/2006 19:12:24.762 Attempting to install product: Redist9
06/29/2006 19:12:27.309 Successfully installed product: Redist9
06/29/2006 19:12:27.543 Attempting to install product: Redist9
06/29/2006 19:12:31.059 Successfully installed product: Redist9
06/29/2006 19:12:31.246 Attempting to install product: Redist9
06/29/2006 19:12:34.512 Successfully installed product: Redist9
06/29/2006 19:12:34.621
06/29/2006 19:12:34.653 Product Status Summary:
06/29/2006 19:12:34.684 Product: SQL Server Native Client
06/29/2006 19:12:34.731 SQL Server Native Client (RTM ) - Success
06/29/2006 19:12:34.762
06/29/2006 19:12:34.793 Product: Setup Support Files
06/29/2006 19:12:34.824 Setup Support Files (RTM ) - Success
06/29/2006 19:12:34.856
06/29/2006 19:12:34.887 Product: Database Services
06/29/2006 19:12:34.918 Database Services (SP1 2047 ENU) - Success
06/29/2006 19:12:34.949 Analysis Services (SP1 2047 ENU) - Success
06/29/2006 19:12:34.981 Reporting Services (RTM 1399 ENU) - Failure
06/29/2006 19:12:35.028
06/29/2006 19:12:35.059 Product: Notification Services
06/29/2006 19:12:35.090 Notification Services (SP1 2047 ENU) - Success
06/29/2006 19:12:35.184
06/29/2006 19:12:35.246 Product: Integration Services
06/29/2006 19:12:35.293 Integration Services (SP1 2047 ENU) - Success
06/29/2006 19:12:35.324
06/29/2006 19:12:35.356 Product: Client Components
06/29/2006 19:12:35.387 Client Components (SP1 2047 ENU) - Success
06/29/2006 19:12:35.434
06/29/2006 19:12:35.465 Product: MSXML 6.0 Parser
06/29/2006 19:12:35.496 MSXML 6.0 Parser (RTM ) - Success
06/29/2006 19:12:35.528
06/29/2006 19:12:35.543 Product: SQLXML4
06/29/2006 19:12:35.574 SQLXML4 (RTM ) - Success
06/29/2006 19:12:35.621
06/29/2006 19:12:35.637 Product: Backward Compatibility
06/29/2006 19:12:35.668 Backward Compatibility (RTM ) - Success
06/29/2006 19:12:35.699
06/29/2006 19:12:35.731 Product: Microsoft SQL Server VSS Writer
06/29/2006 19:12:35.762 Microsoft SQL Server VSS Writer (RTM ) - Success
06/29/2006 19:12:35.824
06/29/2006 19:12:35.856 Hotfix package completed
06/29/2006 19:12:36.246 Hotfix package closed
Hi,
I am new to reporting services. I am currently on the maintenance of few reports that are developed.
Any subscribed report I attempt to deliver via email is failing with a strange error.
"Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information."
I am not able to understand where this log file is stored..where can I find this? Please let me know.. and if someone has faced this error before then what could be the reason? I am using SQL Server 2005 on Windows Server 2003 R2 standard edition.
Cheers
Abhi..
I need help regarding how to send mails through SQL server. Let me give you some more details: I am having a table where in all the e-mail id's are stored so i need to write a stored procedure that will pick up the email id from the table and it has to send the mail once you run the stored procedure.
Any help in this regard will really help...pls help me out...
Hi,
i want to send Mail from sql server.which means that when i execute an query a mail will send to mentioned e-mail.is it any predefined function is there?.if,yes,can u explain Detail.
Regards
Umapathy
Lokendra writes "I have configured the Database mail profile and account in Sql Server 2005 but the mail is not sending and showing the following error message:
Error,235,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-03-05T15:16:07). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: Sorry<c/> that domain isn't in my list of allowed rcpthosts.).
),3000,90,,3/5/2007 3:16:07 PM,sa
but while in the same mail set up in previous instance of sql server 2005 the message was sending very well. After installing new instance of sql server 2005 the problem is arising.
Anybody can tell me that what I can do so that i can send mail using the SMTP databasemail account."
Hello,Does anyone know how I can set SQL Server up so that after it hascompleted a backup sucessfully it will send the completion report toan e-mail address via SMTP.Unfortunatly we cannot install MS OUTLOOK Express or similar.Is this possible?Many thanks in advance,Allan Martin
View 2 Replies View RelatedHello Friends
I want to send mail using Stored Procedure using SQL Server 2000 using windows smtp component. I don't want third party component.
can any body send Stored Procedure.
I keep getting a generic "Error Sending Mail" error. For testing purposes I am just trying to send using my own email account. What goes in the SMTP Server box in the connection manager? I have tried:
A - the exchange server address (SOMETHING.us.company.com)
B - The SMTP properties I see when I look at the properties of my email address: (my.name@abcd.efgh.company.com)
C - Just the end portion of the SMTP properties: (abcd.efgh.company.com)
D - My email address (my.name@company.com)
I don't know what to enter, or what is giving me such a generic error message.
I know you can specify additional recipients in the To column by sepperating them with a semicolon. But whats the easiest way to send to several users, when the email address must be retrieved from a table with a query like this:
select email from problem_subscribers
where project = 'project1'
and statusmail = 'OnError'
So when the eventhandler gets an OnError i want the mail task to be sent to each problemsubscriber.
I have installed 2005 in a new machine with reporting services and configured the reporting services fine. I see the virtual directories fine in IIS but when I try connecting to the report server using IE (http://localhost/reports or http://servername/reports) i get page cannot be displayed errro. When I try connecting using management studio I get the following error
TITLE: Connect to Server
------------------------------
Cannot connect to BLRPTSQL03T.
------------------------------
ADDITIONAL INFORMATION:
The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
------------------------------
An existing connection was forcibly closed by the remote host (System)
------------------------------
BUTTONS:
OK
------------------------------
I donot see any errors in the event logs or the report server logs. Any help with this issue greatly appreciated
I work in an environment where everyone is there own server. I can connect to a collegeau's SQL Server by using the Windows Authentication method in the Database Engine but if I try to connect to the Reporting Services Engine it says that I am not allowed to connect due to permission violations. How do I get adequate permissions to do so? I have all of the components for Reporting Services installed and I am actively using it. I want to be able to test the functionality of the RSScriptor before deploying it out to others.
View 2 Replies View RelatedHi,
I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does. IIS is up and running.
I'm running SQL 2005 Enterprise 64bit with Service Pack 2.
===================================
Cannot connect to ctbbcysql02.
===================================
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any help will be greatly appreciated.
Regards,
Ruaan
I would like to alert my users only if the report contains data.
Can I set the subscription to send a report only if there is data?
Also is SQL Job can send a SSRS report?