Report Packs and SQL Server Express

I am trying to use the IISLog report packs with SQL Server Express reporting services. The guidance in http://blogs.msdn.com/sqlexpress/ indicates that I need to change the target URL and the connection string so that the report packs work with SQL Express. I cannot see how to centrally change the connection string, so that it will affect all the Datasets in the report project. If I try and open a report page and click on the Data tab I get the following error.

A connection cannot be made to the database.
Set and test the connection string.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I have seen this error before when I have mistakenly used "data source=(local); initial catalog=AdventureWorks" instead of "data source=.\SQLExpress; initial catalog=AdventureWorks" as a connection string when creating a new Dataset.

How can I get the IISLog report pack to work with SQL Express?

The Readme.doc file provided with the samples provide two options for deploying the reports. Option 2, using the Report Manager actually gives instructions on how to correctly create a new datasource and then point the uploaded reports to that datasource. I'll leave you to review the readme if you're using this method.

Option 1, describing using Business Intellegence Development Studio (BIDS) doesn't actually address modifying the datasource, so I'll cover that here. If you're using an all Express system, you'll need to have the following installed to do this:

SQL Express Advanced|||need to add another quickstart tutorial for this subject matter because installation on a winxp pro sp2 machine isn't yielding ability to deploy reports to sqlexpress.

The problem is how to configure the report server. seems the report designer will create a report and has ability to preview it, but cannot connect to server for deployment after the build.

Even though I can connect to the server after I go through the report server configuration tool setup.

==================================error
TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer$SQLExpress.

ADDITIONAL INFORMATION:

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.Designer)

================================error

Your above guidelines are not specifically applicable to IIs 5.1, as there is no " IISDatabase.rds Data Source listed under the Shared Data Sources folder"

|||I'm having the exact same inability to deploy report to SQL Server 2005 on an XP system. Using http:/localhost/ReportServer and receive "Object reference not set to an instance of an object"sql

Report Packs and SQL Server Express

I am trying to use the IISLog report packs with SQL Server Express reporting services. The guidance in http://blogs.msdn.com/sqlexpress/ indicates that I need to change the target URL and the connection string so that the report packs work with SQL Express. I cannot see how to centrally change the connection string, so that it will affect all the Datasets in the report project. If I try and open a report page and click on the Data tab I get the following error.

A connection cannot be made to the database.
Set and test the connection string.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I have seen this error before when I have mistakenly used "data source=(local); initial catalog=AdventureWorks" instead of "data source=.\SQLExpress; initial catalog=AdventureWorks" as a connection string when creating a new Dataset.

How can I get the IISLog report pack to work with SQL Express?

The Readme.doc file provided with the samples provide two options for deploying the reports. Option 2, using the Report Manager actually gives instructions on how to correctly create a new datasource and then point the uploaded reports to that datasource. I'll leave you to review the readme if you're using this method.

Option 1, describing using Business Intellegence Development Studio (BIDS) doesn't actually address modifying the datasource, so I'll cover that here. If you're using an all Express system, you'll need to have the following installed to do this:

SQL Express Advanced|||need to add another quickstart tutorial for this subject matter because installation on a winxp pro sp2 machine isn't yielding ability to deploy reports to sqlexpress.

The problem is how to configure the report server. seems the report designer will create a report and has ability to preview it, but cannot connect to server for deployment after the build.

Even though I can connect to the server after I go through the report server configuration tool setup.

==================================error
TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer$SQLExpress.

ADDITIONAL INFORMATION:

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.Designer)

================================error

Your above guidelines are not specifically applicable to IIs 5.1, as there is no " IISDatabase.rds Data Source listed under the Shared Data Sources folder"

|||I'm having the exact same inability to deploy report to SQL Server 2005 on an XP system. Using http:/localhost/ReportServer and receive "Object reference not set to an instance of an object"

Report Manager indicates mail was went but it's not delivered

Hope someone can give a hint how to resolve this issue. RS manager indicates
the report was sent via e-mail, but the mail is not received by the
recipients.
The wierd thing is that manually putting a file in the SMTP Pickup folder
like the one below. it works fine. File is sent and received just fine.
From: sender@.email
To: recipient@.email
Subject: Testing SMTP
This is a manual SMTP test
If I drop a report file created by Reporting Services (no attachment just
send the link). The file is pick it up by SMTP, but no mail is received.
SMTP & RS logs indicates the mail was sent sucessfully.
What's going on?
ThanksI'm having the same problem on a Windows Server 2003 with RS and SP1
installed. Logs indicate the message was sent successfully but nothing ever
arrives. Advice would be greatly appreciated.
"David Nevarez" <DavidNevarez@.discussions.microsoft.com> wrote in message
news:A9DF5133-1B9E-413E-8C19-AD17C7AAF088@.microsoft.com...
> Hope someone can give a hint how to resolve this issue. RS manager
indicates
> the report was sent via e-mail, but the mail is not received by the
> recipients.
> The wierd thing is that manually putting a file in the SMTP Pickup folder
> like the one below. it works fine. File is sent and received just fine.
> From: sender@.email
> To: recipient@.email
> Subject: Testing SMTP
> This is a manual SMTP test
> If I drop a report file created by Reporting Services (no attachment just
> send the link). The file is pick it up by SMTP, but no mail is received.
> SMTP & RS logs indicates the mail was sent sucessfully.
> What's going on?
> Thanks|||Hi Mark,
I found your post in the forum at searching some solutions for my problem,
what is the same like you had.
Did you found a solution? Thank you
"Mark" wrote:
> I'm having the same problem on a Windows Server 2003 with RS and SP1
> installed. Logs indicate the message was sent successfully but nothing ever
> arrives. Advice would be greatly appreciated.
>
> "David Nevarez" <DavidNevarez@.discussions.microsoft.com> wrote in message
> news:A9DF5133-1B9E-413E-8C19-AD17C7AAF088@.microsoft.com...
> > Hope someone can give a hint how to resolve this issue. RS manager
> indicates
> > the report was sent via e-mail, but the mail is not received by the
> > recipients.
> >
> > The wierd thing is that manually putting a file in the SMTP Pickup folder
> > like the one below. it works fine. File is sent and received just fine.
> > From: sender@.email
> > To: recipient@.email
> > Subject: Testing SMTP
> >
> > This is a manual SMTP test
> >
> > If I drop a report file created by Reporting Services (no attachment just
> > send the link). The file is pick it up by SMTP, but no mail is received.
> >
> > SMTP & RS logs indicates the mail was sent sucessfully.
> >
> > What's going on?
> >
> > Thanks
>
>|||Hi David,
I found your post in the forum at searching some solutions for my problem,
what is the same like you had.
Did you found a solution? Thank you
"David Nevarez" wrote:
> Hope someone can give a hint how to resolve this issue. RS manager indicates
> the report was sent via e-mail, but the mail is not received by the
> recipients.
> The wierd thing is that manually putting a file in the SMTP Pickup folder
> like the one below. it works fine. File is sent and received just fine.
> From: sender@.email
> To: recipient@.email
> Subject: Testing SMTP
> This is a manual SMTP test
> If I drop a report file created by Reporting Services (no attachment just
> send the link). The file is pick it up by SMTP, but no mail is received.
> SMTP & RS logs indicates the mail was sent sucessfully.
> What's going on?
> Thanks