Connect to server from Report Builder

I am able to start Report Builder from the Reports site.

Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works. What's more, when I cancel and then click on the open button I get an exception:

Code Snippet

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportBuilder.CatalogItemDialog.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
ReportBuilder
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.VDBRANDE/Local%20Settings/Apps/2.0/97YHGD67.7XE/97YX7M5J.5E2/repo..tion_c3bce3770c238a49_0009.0000_827b297b08a11874/ReportBuilder.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Deployment
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
-
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
-
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
yicgob7u
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
g5yh0wut
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
a0wegfwe
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

I run the Report Builder on the server so there should be no connection problems.

Thanks for any tips.

rept wrote:

I am able to start Report Builder from the Reports site.

Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works.

This doesn't work quite like you think it does.

In order for report builder to work properly, you need to create a Report Model Project in BIS. Once you've deployed a datasource, view and report model your report model will appear in the "select site or server" area in which you currently don't see anything.

The trick to defining the proper report model project is to define the proper relationships.

|||

Thanks for your help, I tried at first doing it in BIS but it doesn't seem possible to create a datasource based on OLAP in there? This is why I searched the net and found this tutorial which I'm trying to do:

http://msdn2.microsoft.com/en-us/library/ms345313.aspx

|||

Found the solution: I needed to open internet options in IE and then connections and check:

Bypass proxy server for local addressess. After that the Report Builder opened correctly and displayed the DSV perfectly.

Connect to .mdb Database in Crystal Report 9 from VB

Hi,

Some one Pls tell me How to connect to a .mdb file from Visual Basic

Am using Crystal Report 9.

I have created a CRAXDRT. Application and Report and I have opened the Report.

How should I pass the database name (.mdb) after this..

I want to add App.Path also when I connect to the database

Thanks
PremodDim CrxRep As New CRAXDDRT.report
Dim CrxApp As New CRAXDDRT.Application
Dim CrxDataFiles As CRAXDDRT.DatabaseTables

strDBPath = "Path to DB Goes Here"

Set CrxRep = CrxApp.OpenReport(App.Path & "\CrystalRpt\BPOilAnalysis.rpt", 1)
Set CrxDataFiles = CrxRep.Database.Tables
CrxDataFiles(1).SetLogOnInfo (strDBPath)

I used this code since my DB path can change and wanted it to remain versatile to the user.

Hope this helps! Tricia =)

Connect SQLRPS2005 to SQL2k DB?

How do I go about connecting SQLRPS2005 in SPS3.0 integration mode to
a SQL2k DB?
(Actually I want to report from a Project server 2003 instance, which
is based on sql2k.
I have SQLRPS2k5 installed on the sharepoint server and have lots of
green ticks for the installation. I have also installed the SPS3.0
plug-in and cofigured its paramters through SPS central.
Then I create a data source within my SPS report libary with:
Data source type: Microsoft SQL Server
connection string: data source=act01projsvr01;initial
catalog=ProjectServer
Credentials: windows integrated
However, when I try to create a report builder model using this data
source I get:
Cannot create a connection to data source 'EPM Pilot.rsds'.
(rsErrorOpeningConnection)
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
So obviously the current users windows credentials are not getting
passed through to the remote SQL server correctly?
Any ideas?It looks like double hop issue. Real (and hard) solution is to use Kerberos.
As workaround, you can try to use stored credentials instead of Windows
Integrated.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"scubaal" <al@.blakes.net> wrote in message
news:1173848679.463141.29360@.n59g2000hsh.googlegroups.com...
> How do I go about connecting SQLRPS2005 in SPS3.0 integration mode to
> a SQL2k DB?
> (Actually I want to report from a Project server 2003 instance, which
> is based on sql2k.
> I have SQLRPS2k5 installed on the sharepoint server and have lots of
> green ticks for the installation. I have also installed the SPS3.0
> plug-in and cofigured its paramters through SPS central.
> Then I create a data source within my SPS report libary with:
> Data source type: Microsoft SQL Server
> connection string: data source=act01projsvr01;initial
> catalog=ProjectServer
> Credentials: windows integrated
> However, when I try to create a report builder model using this data
> source I get:
> Cannot create a connection to data source 'EPM Pilot.rsds'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
> So obviously the current users windows credentials are not getting
> passed through to the remote SQL server correctly?
> Any ideas?
>

Connect a report to an application database

I added a database named appdata to the app_data folder to hold temporary application data. I want to show this data in a report. I created a dataset and an object to select the data. I then created an report.fdlc and a report.aspx with a ReportViewer on it pointing to the dataset object. If I right click on the report.aspx and View in Browser, it work perfectly. But when I upload it to the server I get and browse to it I get (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). The server does allow remote connections. So I am thinking it's my connection string of the fact that the server doesn't have Sql Server Express.?

Here's my connection string. What am I missing here?

<

addname="appdataConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\appdata.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient" />

Set the Data Source attribute to the full SQL Instance name like 'machinename\SQLEXPRESS' and try again.

Confusion over datasets, lists, first(

I'm trying to build a report in VS2005. The main dataset (DSCases) for
the report is just "Select * from LawCases where Docket = ?"
It should only return one case. So I dragged a few fields onto the
report body, and VS kept making the expression First(Fields!...)
instead of just Fields!. I don't know why but I don't know much about
SSRS so that isn't too surprising.
I used a list with that dataset as the DataSetName and then I could
get rid of the Firsts. Fine.
However I need some other tables mixed in, so I created another
dataset DSAttorneys (Select * from LawCasesAttorney where Docket = ?),
which should get me the various attorneys who worked on the case. Then
I added a list inside the main list, set the DataSetName to the
DSAttorneys, and VS insists on using First again. And, indeed, I do
get the first attorney, but I need them all. It won't compile without
the First though.
I hoped that the inside list would understand that it would repeat
those fields for each record. I looked at filters and grouping but
can't get it to work as I expect.
Do I need to use subreports instead of a list?As you saw you can't just put a field on the layout surface. It has to be
bound to a list or a table. If you know there is only going to be one record
returned then drag and drop the fields and use the First aggregate. Then
drag the list over (or the table object, whichever works best). Otherwise
use a subreport.
What is happening is RS does not know it is a single row, how can it. So for
a list within a list it would need to be joining the data (like a
master-detail). For instance a list of orders and a list of items for each
order. When you do a 1 to many or a 1 to 1 you need to use subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dgk" <dgk@.somewhere.com> wrote in message
news:0i3pr39o6so20jdih2k8p1lrbpsep6mt37@.4ax.com...
> I'm trying to build a report in VS2005. The main dataset (DSCases) for
> the report is just "Select * from LawCases where Docket = ?"
> It should only return one case. So I dragged a few fields onto the
> report body, and VS kept making the expression First(Fields!...)
> instead of just Fields!. I don't know why but I don't know much about
> SSRS so that isn't too surprising.
> I used a list with that dataset as the DataSetName and then I could
> get rid of the Firsts. Fine.
> However I need some other tables mixed in, so I created another
> dataset DSAttorneys (Select * from LawCasesAttorney where Docket = ?),
> which should get me the various attorneys who worked on the case. Then
> I added a list inside the main list, set the DataSetName to the
> DSAttorneys, and VS insists on using First again. And, indeed, I do
> get the first attorney, but I need them all. It won't compile without
> the First though.
> I hoped that the inside list would understand that it would repeat
> those fields for each record. I looked at filters and grouping but
> can't get it to work as I expect.
> Do I need to use subreports instead of a list?|||On Wed, 20 Feb 2008 15:06:49 -0600, "Bruce L-C [MVP]"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>As you saw you can't just put a field on the layout surface. It has to be
>bound to a list or a table. If you know there is only going to be one record
>returned then drag and drop the fields and use the First aggregate. Then
>drag the list over (or the table object, whichever works best). Otherwise
>use a subreport.
>What is happening is RS does not know it is a single row, how can it. So for
>a list within a list it would need to be joining the data (like a
>master-detail). For instance a list of orders and a list of items for each
>order. When you do a 1 to many or a 1 to 1 you need to use subreports.
Thanks. There will be quite a few different detail records for each
master (at least four other tables) so I can't even think of how to
join them all. Subreports certainly seems the way to go. I'll give it
a shot.

Confused with FQDNs

Hi NG,
if i call a report with
http://servername/report everything works fine.
If i call the report with
http://servername.domain.com/report the report failed because he couldn't
find the datasource to the olap-cube.
I use win-auth on iis.
Any suggests?
FrankFrank Matthiesen wrote:
> Any suggests?
Solved...
frank

Conflicting Members

I have a report that includes a set, customer divisions as columns and products as rows. At certain intersections members are filtered by the same attribute (ie customer is filtered by product flag as is the product). Some of these have conflicting attribute values (ie product flag is true for the customer but false for the product). In these cases the customer setting is taking precedence. However I need the member setting for the product to override the customer. Is there a way of achieving this?

From your description it is not clear to me what your issue is. Axes are resolved independently, so there could be no conflicts in filtering customers and products. And if you refer to cell values, then what does filtering means ? It would be best if you will provide the exact MDX you are using and results you want to get, then this forum will be able to help you with MDX modifications.|||

In response to your question I am referring to cell values. My MDX query is basically SELECT [Customer Set] on Columns, [Product Set] on rows. I have members in my customer set and my product set which are filtered by the same attribute (Product Flag):

Product Member = ([Product - Own Keg Total] , [Product].[Product Flag].[TRUE])

Customer Member = ([Customer].[Customer Hierarchy - Area].[Market].&[United Kingdom].&[Tied Trade], [Customer].[Product Flag].[FALSE])

The values results returned indicate that the attribute value for the product flag of the customer member has been used.

Hope this makes it clearer. If not let me know. Thanks.

|||Can you please provide a definition of named sets [Customer Set] and [Product Set]. I am still not sure what you meant by Product Member and Customer Member in your response, but one thing contradicted what you said about same attribute (Product Flag) being used - in your tuple expression once you used attribute in the Product dimension and once in Customer dimension, so it cannot be the same attribute.|||

Sorry to add to the confusion. The customer member should have read:

([Customer].[Customer Hierarchy - Area].[Market].&[United Kingdom].&[Tied Trade], [Product].[Product Flag].[FALSE])

Ignoring sets, if I run the query with just the product member on the row and the customer member on the column I get the same result:

WITH MEMBER [Product].[Product Hierarchy].[Product Test] AS

([Product].[Product Hierarchy].[Product Group Section].&[Own Beer]&[Own Keg], [Product].[Product Flag].[True])

MEMBER [Customer].[Customer Hierarchy - Area].[Customer Test] AS

([Customer].[Customer Hierarchy - Area].[Market].&[United Kingdom].&[Tied Trade], [Product].[Product Flag].[FALSE])

SELECT

[Product Test] ON COLUMNS ,

[Customer Test] ON ROWS

FROM [beer_co]

WHERE ( [Measures].[Barrelage] )

|||

Thanks - it is clear now. The mechanism to control order of conflict resolution on calculated members is through SOLVE_ORDER property. I.e. in the following query Customer Test has higher solve order, therefore the Product Flag=True would win

WITH MEMBER [Product].[Product Hierarchy].[Product Test] AS

([Product].[Product Hierarchy].[Product Group Section].&[Own Beer]&[Own Keg], [Product].[Product Flag].[True]), SOLVE_ORDER=1

MEMBER [Customer].[Customer Hierarchy - Area].[Customer Test] AS

([Customer].[Customer Hierarchy - Area].[Market].&[United Kingdom].&[Tied Trade], [Product].[Product Flag].[FALSE]), SOLVE_ORDER=2

SELECT

[Product Test] ON COLUMNS ,

[Customer Test] ON ROWS

FROM [beer_co]

WHERE ( [Measures].[Barrelage] )

And in the following query, the SOLVE_ORDER is reversed, therefore Product Flag=False will win.

WITH MEMBER [Product].[Product Hierarchy].[Product Test] AS

([Product].[Product Hierarchy].[Product Group Section].&[Own Beer]&[Own Keg], [Product].[Product Flag].[True]), SOLVE_ORDER=2

MEMBER [Customer].[Customer Hierarchy - Area].[Customer Test] AS

([Customer].[Customer Hierarchy - Area].[Market].&[United Kingdom].&[Tied Trade], [Product].[Product Flag].[FALSE]), SOLVE_ORDER=1

SELECT

[Product Test] ON COLUMNS ,

[Customer Test] ON ROWS

FROM [beer_co]

WHERE ( [Measures].[Barrelage] )

|||Is there a way of configuring the query so that where there is a conflict neither member wins and nothing is returned?

Confirming the right hyperlink

Hi,
We create rdl files which contains <Hyperlink> elements. The
value for hyperlink is an expression build using report parameters,
field parameters etc and also contains calls to custom assemblies
eg : <Hyperlink>=Parameters!Param1.Value + CustomAssemblyCall + Fields!
someField.Value<Hyperlink>
When this report is rendered by HTML Rendering extension(by specifying
HTML4.0 in the format string passed to render() method) this
<Hyperlink> element is converted to href attribute of the <a> tag.
We have a scenario where we want to test whether this href url
generated is correct or no without deploying the rdl file on the
report server.
Is there any way to pass the xml file and find out what would be href
value when the <Hyperlink>
element is parsed by the report server ?
Any report server dll's which can directly be used ?
Thanks in advance,Can anyone guide me on this

Configuring reporting services

Hello Experts,

I have this problem when i go to http://<servername>/reprots

"The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible "

I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.

i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....

would be great if someone suggests.

regards,

lakshman.

Hi Lakshman,

Is it RS 2000 or 2005? In RS 2005, you can use RS config tool to see if all sections are correctly configured. If not, fix the problems using the config tool and try again.

Thanks,
Sharmila

|||

Hi Sharmila,

Thanks for the reply.

Its RS2005. I am pretty new to the subject, can you please guide about using the RSConfig tool. Or resources where i can find the subject.

Best Regards,

Lakshman.

|||

Hi Sharmila,

At the command prompt, I have done the following actions:

C:\>rsconfig -c -s iplserver -d iplserver -a SQL -u sa -p P@.ssword123445
The command completed successfully

C:\>iisreset
Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted

C:\>

when i try to access the report manager, the error persists.

pl let me know if i have to do something else.

many thanks,

lakshman.

|||

Hi Lakshman,

To access the config tool, go to Start ->All Programs -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration. Make sure that all sections are configured properly. You should see a green check mark. Please try this and let me know.

Thanks,
Sharmila

|||

Lakshman Pilaka wrote:

Hello Experts,

I have this problem when i go to http://<servername>/reprots

Is it safe to assume the mispelling of Reports is only here in the forums?

|||

oops, i wrote it wrong here in the thread, but i was spelling it correctly when i am testing...

Sharmila, thanks for the msg, I have checked that one and got to see that there is a blue exclamation for the "Encryption Keys". and the initialization is not done, i find a red cross. but rest all are okay with a green check mark.

i am not even able to access it the Initialization tab as its giving an error message,

plz help, or just guied me to a resource where i can have all this information..

i appreciate all your time and efforts,

lakshman.

|||

Hi,

I have installed the SQL SP2 on the server, and now the server is properly initialized. now i see a green check mark on all the tabs.

But unfortunately the problem still persists. I am seeing the same error:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

when i attempt to go to http://<reportserver>/reports

what could be the problem?

many thanks,

lakshman.

|||

Hi Lakshman,

Can you please take a look at the RS logs located here - %programfiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles and see what you can find around the same time you see the error or can you include information from the logs?

Thanks,
Sharmila

Configuring Report Services for 64 bit SQL 2005

Hi all

Can anyone help?

I have installed reporting services for 64 bit SQL and I am having a problem configuring it correctly so that I can access the reports manager on http://localhost/reports.

I have studied various SQL server 2005 bibles and looked at information on the microsoft support site but nothing seems to be helping me.

I get the impression that it could be a problem with the IIS server.

Can anyone give me a complete run down on how to set up and configure the reporting services so that it will actually work. Every step of the way please.

Thanks

Alex Oakley

Hi Alex. Are you using a default instance of the SQL Server 2005 installation or did you use a named instance? Also, what error are you getting when you attempt to access report manager?

|||

I am using a default instance.

When I am trying to access the report manager the internet page isnt loading at all.

I am getting the usual IE screen where url cannot be found.

Alex

|||

Try Http://Servername/Reports and see what you get....

|||I have tried that and the page is not being displayed....

|||

Can you open the RS config tool and make sure that all sections are configured properly. You should see a green icon if everything is configured correctly.

Thanks,
Sharmila

Configuring access

How can I let all domain users run reports without adding them one by one
into Report Manager?
ThanksAdd <DOMAIN>\Domain Users and grant Browse Rights.
Or better yet, create a security group that is allowed to view reports and
add this group to the list of users. I.e. if your group was called
"ReportUsers" and the name of my domain is WORKHERE then you would add:
WORKHERE\ReportUsers
=-Chris
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:evt7ufc%23GHA.3352@.TK2MSFTNGP03.phx.gbl...
> How can I let all domain users run reports without adding them one by one
> into Report Manager?
> Thanks
>

Configuring a Report Server for E-Mail Delivery

I've installed Report Services and need to setup the E-Mail Delivery.
There are documents like 'Configuring a Report Server for E-Mail Delivery'
that talk about entering values in the SMTPServer field in the
rswebapplication.config file, but there isn't enough specific information
about setting up e-mail delivery.
What needs to be done to setup e-mail delivery?
Thanks,
JimAre you just talking about a basic subscription? If so, during the
installation you were asked for an smtp server.
That should be all it takes. You might try to create a subscription and
see what happens.
You can also edit the config file and change the SMTP server, but I have
no experience with that.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:Jim@.discussions.microsoft.com:
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||It can be done during installation but otherwise just do the following:
If you have a smtp server somewhere then you can just use that and use the
mail client that comes with Reporting Services. That is what I do.
In rsreportserver.config look for:
<SMTPServer>123.45.6.78</SMTPServer>
and put in the address for your smtp server. I found I had to hardcode the
address rather than use the name.
Also put in this one as well:
<From>somebody@.somewhere.com</From>
These two are the minimum to put in. There are more items you can configure
but those two should get you going.
Of course, for this to work you smtp server needs to accept mail from
anonymous sources. If it doesn't then there is more you will have to do (in
my case I didn't so I can't help with that scenario).
Hopefully this gets you going in the right direction.
Note that you do not need any mail client installed on the server. RS just
sends your mail to an existing smtp server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||Report Services were installed before the SMTP server, so I would like to
configure the email server without removing the Report Services.
Did try a subscription and it did not work.
"John Geddes" wrote:
> Are you just talking about a basic subscription? If so, during the
> installation you were asked for an smtp server.
> That should be all it takes. You might try to create a subscription and
> see what happens.
> You can also edit the config file and change the SMTP server, but I have
> no experience with that.
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:Jim@.discussions.microsoft.com:
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> >
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> >
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||What structure in the rsreportserver.config do the values belong in?
"Bruce L-C [MVP]" wrote:
> It can be done during installation but otherwise just do the following:
> If you have a smtp server somewhere then you can just use that and use the
> mail client that comes with Reporting Services. That is what I do.
> In rsreportserver.config look for:
> <SMTPServer>123.45.6.78</SMTPServer>
> and put in the address for your smtp server. I found I had to hardcode the
> address rather than use the name.
> Also put in this one as well:
> <From>somebody@.somewhere.com</From>
> These two are the minimum to put in. There are more items you can configure
> but those two should get you going.
> Of course, for this to work you smtp server needs to accept mail from
> anonymous sources. If it doesn't then there is more you will have to do (in
> my case I didn't so I can't help with that scenario).
> Hopefully this gets you going in the right direction.
> Note that you do not need any mail client installed on the server. RS just
> sends your mail to an existing smtp server.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||The lines are already in there, you do not need to put them in, just search
for them and put your values in.
I.e. you will see this:
<SMTPServer></SMTPServer>
and you need to make it look like this
<SMTPServer>123.45.6.78</SMTPServer>
except, of course, put in the ip address. I had no luck putting the name in
for some reason so I put the IP address instead
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> What structure in the rsreportserver.config do the values belong in?
> "Bruce L-C [MVP]" wrote:
> > It can be done during installation but otherwise just do the following:
> >
> > If you have a smtp server somewhere then you can just use that and use
the
> > mail client that comes with Reporting Services. That is what I do.
> >
> > In rsreportserver.config look for:
> > <SMTPServer>123.45.6.78</SMTPServer>
> > and put in the address for your smtp server. I found I had to hardcode
the
> > address rather than use the name.
> >
> > Also put in this one as well:
> > <From>somebody@.somewhere.com</From>
> >
> > These two are the minimum to put in. There are more items you can
configure
> > but those two should get you going.
> >
> > Of course, for this to work you smtp server needs to accept mail from
> > anonymous sources. If it doesn't then there is more you will have to do
(in
> > my case I didn't so I can't help with that scenario).
> >
> > Hopefully this gets you going in the right direction.
> >
> > Note that you do not need any mail client installed on the server. RS
just
> > sends your mail to an existing smtp server.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > I've installed Report Services and need to setup the E-Mail Delivery.
> > >
> > > There are documents like 'Configuring a Report Server for E-Mail
Delivery'
> > > that talk about entering values in the SMTPServer field in the
> > > rswebapplication.config file, but there isn't enough specific
information
> > > about setting up e-mail delivery.
> > >
> > > What needs to be done to setup e-mail delivery?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >|||The lines aren't in the file I have.
"Bruce L-C [MVP]" wrote:
> The lines are already in there, you do not need to put them in, just search
> for them and put your values in.
> I.e. you will see this:
> <SMTPServer></SMTPServer>
> and you need to make it look like this
> <SMTPServer>123.45.6.78</SMTPServer>
> except, of course, put in the ip address. I had no luck putting the name in
> for some reason so I put the IP address instead
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> > What structure in the rsreportserver.config do the values belong in?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > It can be done during installation but otherwise just do the following:
> > >
> > > If you have a smtp server somewhere then you can just use that and use
> the
> > > mail client that comes with Reporting Services. That is what I do.
> > >
> > > In rsreportserver.config look for:
> > > <SMTPServer>123.45.6.78</SMTPServer>
> > > and put in the address for your smtp server. I found I had to hardcode
> the
> > > address rather than use the name.
> > >
> > > Also put in this one as well:
> > > <From>somebody@.somewhere.com</From>
> > >
> > > These two are the minimum to put in. There are more items you can
> configure
> > > but those two should get you going.
> > >
> > > Of course, for this to work you smtp server needs to accept mail from
> > > anonymous sources. If it doesn't then there is more you will have to do
> (in
> > > my case I didn't so I can't help with that scenario).
> > >
> > > Hopefully this gets you going in the right direction.
> > >
> > > Note that you do not need any mail client installed on the server. RS
> just
> > > sends your mail to an existing smtp server.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > >
> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > > I've installed Report Services and need to setup the E-Mail Delivery.
> > > >
> > > > There are documents like 'Configuring a Report Server for E-Mail
> Delivery'
> > > > that talk about entering values in the SMTPServer field in the
> > > > rswebapplication.config file, but there isn't enough specific
> information
> > > > about setting up e-mail delivery.
> > > >
> > > > What needs to be done to setup e-mail delivery?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > >
> > >
>
>|||Are you sure? Are you looking at rsreportserver.config , there is more than
one configuration file.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> The lines aren't in the file I have.
> "Bruce L-C [MVP]" wrote:
>> The lines are already in there, you do not need to put them in, just
>> search
>> for them and put your values in.
>> I.e. you will see this:
>> <SMTPServer></SMTPServer>
>> and you need to make it look like this
>> <SMTPServer>123.45.6.78</SMTPServer>
>> except, of course, put in the ip address. I had no luck putting the name
>> in
>> for some reason so I put the IP address instead
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
>> > What structure in the rsreportserver.config do the values belong in?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > It can be done during installation but otherwise just do the
>> > > following:
>> > >
>> > > If you have a smtp server somewhere then you can just use that and
>> > > use
>> the
>> > > mail client that comes with Reporting Services. That is what I do.
>> > >
>> > > In rsreportserver.config look for:
>> > > <SMTPServer>123.45.6.78</SMTPServer>
>> > > and put in the address for your smtp server. I found I had to
>> > > hardcode
>> the
>> > > address rather than use the name.
>> > >
>> > > Also put in this one as well:
>> > > <From>somebody@.somewhere.com</From>
>> > >
>> > > These two are the minimum to put in. There are more items you can
>> configure
>> > > but those two should get you going.
>> > >
>> > > Of course, for this to work you smtp server needs to accept mail from
>> > > anonymous sources. If it doesn't then there is more you will have to
>> > > do
>> (in
>> > > my case I didn't so I can't help with that scenario).
>> > >
>> > > Hopefully this gets you going in the right direction.
>> > >
>> > > Note that you do not need any mail client installed on the server. RS
>> just
>> > > sends your mail to an existing smtp server.
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > >
>> > >
>> > >
>> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
>> > > > I've installed Report Services and need to setup the E-Mail
>> > > > Delivery.
>> > > >
>> > > > There are documents like 'Configuring a Report Server for E-Mail
>> Delivery'
>> > > > that talk about entering values in the SMTPServer field in the
>> > > > rswebapplication.config file, but there isn't enough specific
>> information
>> > > > about setting up e-mail delivery.
>> > > >
>> > > > What needs to be done to setup e-mail delivery?
>> > > >
>> > > > Thanks,
>> > > > Jim
>> > >
>> > >
>> > >
>>|||Bruce,
You were right. It was the wrong file.
Thanks,
Jim
"Bruce L-C [MVP]" wrote:
> Are you sure? Are you looking at rsreportserver.config , there is more than
> one configuration file.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> > The lines aren't in the file I have.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The lines are already in there, you do not need to put them in, just
> >> search
> >> for them and put your values in.
> >>
> >> I.e. you will see this:
> >> <SMTPServer></SMTPServer>
> >> and you need to make it look like this
> >> <SMTPServer>123.45.6.78</SMTPServer>
> >> except, of course, put in the ip address. I had no luck putting the name
> >> in
> >> for some reason so I put the IP address instead
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> >> > What structure in the rsreportserver.config do the values belong in?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > It can be done during installation but otherwise just do the
> >> > > following:
> >> > >
> >> > > If you have a smtp server somewhere then you can just use that and
> >> > > use
> >> the
> >> > > mail client that comes with Reporting Services. That is what I do.
> >> > >
> >> > > In rsreportserver.config look for:
> >> > > <SMTPServer>123.45.6.78</SMTPServer>
> >> > > and put in the address for your smtp server. I found I had to
> >> > > hardcode
> >> the
> >> > > address rather than use the name.
> >> > >
> >> > > Also put in this one as well:
> >> > > <From>somebody@.somewhere.com</From>
> >> > >
> >> > > These two are the minimum to put in. There are more items you can
> >> configure
> >> > > but those two should get you going.
> >> > >
> >> > > Of course, for this to work you smtp server needs to accept mail from
> >> > > anonymous sources. If it doesn't then there is more you will have to
> >> > > do
> >> (in
> >> > > my case I didn't so I can't help with that scenario).
> >> > >
> >> > > Hopefully this gets you going in the right direction.
> >> > >
> >> > > Note that you do not need any mail client installed on the server. RS
> >> just
> >> > > sends your mail to an existing smtp server.
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> >> > > > I've installed Report Services and need to setup the E-Mail
> >> > > > Delivery.
> >> > > >
> >> > > > There are documents like 'Configuring a Report Server for E-Mail
> >> Delivery'
> >> > > > that talk about entering values in the SMTPServer field in the
> >> > > > rswebapplication.config file, but there isn't enough specific
> >> information
> >> > > > about setting up e-mail delivery.
> >> > > >
> >> > > > What needs to be done to setup e-mail delivery?
> >> > > >
> >> > > > Thanks,
> >> > > > Jim
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

Configuring a Report Server for E-Mail Delivery

Bruce
I am pretty much in the same boat I have setup a test reporting
services instance on a Windows 2003 box. I now want to setup the
WIndows SMTP server and make reporting services send emails to the
SMTP server running on Windows.
Your help would be highly appreciated if you can specify the steps in
setting up Windows 2003 SMTP server and making reporting services talk
to it.
Thanks
KarenI have not setup the SMTP server. I use Reporting Services ability to be a
client and have it send to an existing SMTP server. There should be no
difference with the setup for Reporting Services, it just needs a SMTP
server, regardless of where it is. So what you need to know is how to
install and setup Windows SMTP server. Two different things, Report Services
SMTP client support and SMTP server. One option once you have the SMTP
server working is you can have RS deposite the report in a directory that
then the SMTP server picks up and emails or you can have it send the report
to the SMTP server which then forwards it on its way. For SMTP Server help I
would check out a Windows 2003 newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0501062053.763b670e@.posting.google.com...
> Bruce
> I am pretty much in the same boat I have setup a test reporting
> services instance on a Windows 2003 box. I now want to setup the
> WIndows SMTP server and make reporting services send emails to the
> SMTP server running on Windows.
> Your help would be highly appreciated if you can specify the steps in
> setting up Windows 2003 SMTP server and making reporting services talk
> to it.
> Thanks
> Karen

Configure Report Server - SharePoint Integration

Hello,

I'm trying to set up SharePoint Integration for our report server. The setup we have is: 1. SQL server hosting the SharePoint databases and the Reporting Server, 2. SharePoint web front end hosting all SharePoint services. I've installed the reporting services SP2 on the SQL server and the reporting services add-in on the SharePoint server.

I configured the report server following the directions here: http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm and here: http://www.sharepointblogs.com/helloitsliam/archive/2007/02/21/19801.aspx

Everything seems to be set up correctly, but when I open the Reporting Services Configuration Manager, the SharePoint Integration option shows the error, "The report server cannot access setting in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model...."

I do have WSS 3.0 installed on the report server.

When I look in the logs on the report server it says the login failed for the account I have set as the Windows Service Identity however, when I look at the logs on the SharePoint server it shows that it is granting the account read and write access to each of the SPWebApplications I have set up.

Any suggestions?

Thanks,

Cynthia

I just figured it out. It always happens that after days of unsuccessful attempts, I figure out the problem as soon as I post to a forum.

In case anyone else has the same problem:

In the Reporting Services Configuration Manager, under Windows Service Identity, I re-entered the name and password of the account and this caused a new dialog box to open prompting me to create an encryption key back-up. I provided a password and file location and then it worked. I'm not sure why I didn't get that dialog box initially, but everything works fine now.

Thanks,

Cynthia

|||

Hi

Can you people please confirm me that

Is that SQL Reporting Services 2005 can only be integrated with MOSS but not WSS 3.0

I am using wss3.0 (Not MOSS) and SQL reporting services 2005.

Configuration steps completed but i am not able to see the Reporting Services section in Application management

of Central Administration.

I installed SQL SP2 and Reporting Services Add ins and everything is on one system, i mean SQL2005 and wss3.0 on one system

I could use SQL Report configuration tool and set all the properties but not able to find Reporting Services section in Application management

of Central Administration.

Please Advice

Thanks,

Tiger

|||

Yes i got the solution for this

We need to Activate the Reporting services in the Central Administration this can be done by the following steps

1. Go to Site settings

2.In the Site collection Administration navigate to Site collection Features

3. Enable the Settings for Reporting Sevices

This will dispay the Reporting Section in the Application Management of Central Administration

Hope this will be help full.

Many Thanks,

Tiger

Configure the version of referenced Assemblies after the deployment

Hi all,
I'm using the Reporting Services 2000 and the Report Designer within Visual Studio 2003. I have
configured several Assembly References (Report Properties -> References). After the addition of an
Assembly the respective row shows amongst others the version of the referenced Assembly. These
informations can be found in the RDL file as well.
I'm looking for a way to configure the version of a referenced Assembly "at runtime" *after* the
deployment of the respective report to the Reporting Services. From .NET Assemblies I know the
application configuration files (.config file) which can be used to configure and to change,
respectively, the version of referenced Assemblies "at runtime".
Thanks in advance,
Jochen.Hello Jochen,
You could redirect one version of myAssembly to another in the web.config
file of the ReportServer folder.
For more information, you could refer the following article:
http://msdn2.microsoft.com/en-us/library/7wd6ex19(VS.80).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei,
thank you very much. This is exactly what I'm looking for.
Regards,
Jochen.
Wei Lu [MSFT] wrote:
> Hello Jochen,
> You could redirect one version of myAssembly to another in the web.config
> file of the ReportServer folder.
> For more information, you could refer the following article:
> http://msdn2.microsoft.com/en-us/library/7wd6ex19(VS.80).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>

Configure Server for Email Delivery

I am having trouble getting a report emailed for the first time.
The timed subscription has been set. I have updated the ReportServer.config
file to include the ip of the exchange server along with port number although
im not sure where to enter a password. The IT guys are making sure that the
exchange server will accept smtp requests from other servers. My question is
what is the best method to troubleshoot & is there anything gleeming that i
am missing. ThanksI have noted that the sql server agent has a job logged & shows suceeded when
last run but I have recieved any emails. I have also noted a job in the
process info that has a status of sleeping. Event log shows nothing
"Tango" wrote:
> I am having trouble getting a report emailed for the first time.
> The timed subscription has been set. I have updated the ReportServer.config
> file to include the ip of the exchange server along with port number although
> im not sure where to enter a password. The IT guys are making sure that the
> exchange server will accept smtp requests from other servers. My question is
> what is the best method to troubleshoot & is there anything gleeming that i
> am missing. Thanks|||Can anyone help, please. Maybe a link to a ReportServer.config that is
successfully emailing reports might help.
Thankyou
"Tango" wrote:
> I have noted that the sql server agent has a job logged & shows suceeded when
> last run but I have recieved any emails. I have also noted a job in the
> process info that has a status of sleeping. Event log shows nothing
> "Tango" wrote:
> > I am having trouble getting a report emailed for the first time.
> > The timed subscription has been set. I have updated the ReportServer.config
> > file to include the ip of the exchange server along with port number although
> > im not sure where to enter a password. The IT guys are making sure that the
> > exchange server will accept smtp requests from other servers. My question is
> > what is the best method to troubleshoot & is there anything gleeming that i
> > am missing. Thanks|||Tango,
Did you ever find out an answer to this? If so could you please share it?
"Tango" wrote:
> Can anyone help, please. Maybe a link to a ReportServer.config that is
> successfully emailing reports might help.
> Thankyou
> "Tango" wrote:
> > I have noted that the sql server agent has a job logged & shows suceeded when
> > last run but I have recieved any emails. I have also noted a job in the
> > process info that has a status of sleeping. Event log shows nothing
> >
> > "Tango" wrote:
> >
> > > I am having trouble getting a report emailed for the first time.
> > > The timed subscription has been set. I have updated the ReportServer.config
> > > file to include the ip of the exchange server along with port number although
> > > im not sure where to enter a password. The IT guys are making sure that the
> > > exchange server will accept smtp requests from other servers. My question is
> > > what is the best method to troubleshoot & is there anything gleeming that i
> > > am missing. Thanks|||It is notoriously difficult to get the subscriptions to work, I spent a week
configuring a production server trying to do this and gave up, I have the
feeling you need to re-install RS using different accounts/settings, which in
my case wasn't an option. I ended up coding a small windows service that
downloaded the report through a crafted URL and emailed it based on a
schedule in a table. It actually took less to code that snippet than to
configure the much glorified data driven subscription feature of RS.
Microsoft shouldn't be in such a hurry to advertise features that won't even
work in plain vanilla, no frills install out of the box.
Regards,
Tzepesh
"Tango" wrote:
> Can anyone help, please. Maybe a link to a ReportServer.config that is
> successfully emailing reports might help.
> Thankyou
> "Tango" wrote:
> > I have noted that the sql server agent has a job logged & shows suceeded when
> > last run but I have recieved any emails. I have also noted a job in the
> > process info that has a status of sleeping. Event log shows nothing
> >
> > "Tango" wrote:
> >
> > > I am having trouble getting a report emailed for the first time.
> > > The timed subscription has been set. I have updated the ReportServer.config
> > > file to include the ip of the exchange server along with port number although
> > > im not sure where to enter a password. The IT guys are making sure that the
> > > exchange server will accept smtp requests from other servers. My question is
> > > what is the best method to troubleshoot & is there anything gleeming that i
> > > am missing. Thanks|||Report server will only work against an SMTP server that accepts anonymous
or NTLM authentication. The best solution for email is to use a local SMTP
server as a relay to your smtp server. Set the pickup directory element in
the RSReportServer.config file to the local SMTP servers pickup directory
and the SendUsing element to 1. Then configure your local SMTP server to
relay the email to your actual SMTP server.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tzepesh" <Tzepesh@.discussions.microsoft.com> wrote in message
news:547E777A-F7A3-4F9A-A7AA-236F22E04966@.microsoft.com...
> It is notoriously difficult to get the subscriptions to work, I spent a
> week
> configuring a production server trying to do this and gave up, I have the
> feeling you need to re-install RS using different accounts/settings, which
> in
> my case wasn't an option. I ended up coding a small windows service that
> downloaded the report through a crafted URL and emailed it based on a
> schedule in a table. It actually took less to code that snippet than to
> configure the much glorified data driven subscription feature of RS.
> Microsoft shouldn't be in such a hurry to advertise features that won't
> even
> work in plain vanilla, no frills install out of the box.
> Regards,
> Tzepesh
> "Tango" wrote:
>> Can anyone help, please. Maybe a link to a ReportServer.config that is
>> successfully emailing reports might help.
>> Thankyou
>> "Tango" wrote:
>> > I have noted that the sql server agent has a job logged & shows
>> > suceeded when
>> > last run but I have recieved any emails. I have also noted a job in the
>> > process info that has a status of sleeping. Event log shows nothing
>> >
>> > "Tango" wrote:
>> >
>> > > I am having trouble getting a report emailed for the first time.
>> > > The timed subscription has been set. I have updated the
>> > > ReportServer.config
>> > > file to include the ip of the exchange server along with port number
>> > > although
>> > > im not sure where to enter a password. The IT guys are making sure
>> > > that the
>> > > exchange server will accept smtp requests from other servers. My
>> > > question is
>> > > what is the best method to troubleshoot & is there anything gleeming
>> > > that i
>> > > am missing. Thanks

Configure Report services

HI,

I am having SQL Server 2005 express edition, how can i configure report services

Try the Reporting Services forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1|||This thread has been moved to RS forum (originally posted in SSIS)|||

VSB,

Take a look at this document from Microsoft.

http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/UsingSSRSwithSQLExpress.doc

Hope this helps.

Jarret

Configure Report Server with SQL Server Express with Advanced Services.

I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"

When I check IIS the directories were created but the Reporting Services Configuration Manager does not see them unless I attempt to recreate them again without deleting them from IIS.

Anyone have any ideas as to this disconnect?

Thanks in advance!

By default RS is configured during installation so you shouldn't need to do any additional configuration. I'll ping the RS team to see if they have additional information about the error you're seeing.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||I have been unable in this case to allow RS to be configured during the install as selecting that option always caused an error. That error was something along the lines that it could not connect to the Report Database. The only way I could get the install to finish with no errors was to have it not configure RS.|||

This one dropped off my radar, sorry.

Were you ever able to get your Report Server running correctly. It seems that I found a similar behavior that I could only create new RS virtual directories if the folder already existed.

Regards,

Mike

|||I have having precisely the same problem. I cannot install Report Services as part of the original install of SQL Server since it has an error. So I install report services separately, but if you do that, it will not auto-configure, and when I use the config tool, I get the same error above.|||It seemed to be related to an improper installation of ASP.NET. I uninstalled ASP 2.0, then uninstalled 1.1, and reinstalled both of these and then manual configuration worked.|||

It is possible that you installed ASP.NET 2.0 before you installed IIS. The .NET Framework 2.0 has some special configurations that it does when IIS is installed that don't happen after the fact without running a special configuration file.

The alternative approach that you've found is to remove and reinstall the framework.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

No, I am 100% certain that IIS and the 1.1 framework were present before I installed 2.0. I even tried aspnet_regiis -i for both 1.1 and 2.0 and that did not help. Since I did not personally install the 1.1 framework, since both it and IIS were installed from someone elses disk image, I cannot guarantee that they were configured properly.

|||

I am having problems with Reporting Services.

I go to http://localhost/reports and get error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

In terms of configuration, I have set name of Report Server Virtual Directory to "ReportServer2", as it would not let me name it "ReportServer".

I have tried uninstalling .net framework v2 and reinstalling, but this does not help.

Any suggestions?

|||

I'm trying to manually configure my second reporting server instance. I used reports/$rserver as the virtual directory, (rserver is my instance name), and got error message:

"The virtual directory could not be created. The previously set virtual directory will still be used."

Then i used only reports as the virtual dir, the configuration wizard liked it and let me go through. But when i trid to open the URL http://localhost/reports, got the error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

I verified my instance "rserver" was running and i'm sure i installed IIS before I installed SDK.Looks like some of us got the same problems here, have you figured it out yet?

By the way, i installed my only SQL server instance SQLEXPRESS and my first reporting service instance by default. They work fine.

Configure Report Server with SQL Server Express with Advanced Services.

I am having trouble with SQL Express Reporting services.

When going to http:/localhost/reports I get the following error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

In configuring the Report Server Virtual Directory, it would not let me set the name as "Report Server", so I named it "Report Server2".

I have tried uninstalling .NET framework v2 and reinstalling, but this does not help.

Any ideas?

By default, Express Advanced installs Report Server to a name instance, so you should be trying to get to http://localhost/reports$sqlexress. A default installation should have configured the virtual directory for you.

You can open SQL Server Configuration Manager and it will show you if the reporting service is running and if it has a name.

Mike

Configure Report Server with SQL Server Express with Advanced Services.

I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"

When I check IIS the directories were created but the Reporting Services Configuration Manager does not see them unless I attempt to recreate them again without deleting them from IIS.

Anyone have any ideas as to this disconnect?

Thanks in advance!

By default RS is configured during installation so you shouldn't need to do any additional configuration. I'll ping the RS team to see if they have additional information about the error you're seeing.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||I have been unable in this case to allow RS to be configured during the install as selecting that option always caused an error. That error was something along the lines that it could not connect to the Report Database. The only way I could get the install to finish with no errors was to have it not configure RS.|||

This one dropped off my radar, sorry.

Were you ever able to get your Report Server running correctly. It seems that I found a similar behavior that I could only create new RS virtual directories if the folder already existed.

Regards,

Mike

|||I have having precisely the same problem. I cannot install Report Services as part of the original install of SQL Server since it has an error. So I install report services separately, but if you do that, it will not auto-configure, and when I use the config tool, I get the same error above.|||It seemed to be related to an improper installation of ASP.NET. I uninstalled ASP 2.0, then uninstalled 1.1, and reinstalled both of these and then manual configuration worked.|||

It is possible that you installed ASP.NET 2.0 before you installed IIS. The .NET Framework 2.0 has some special configurations that it does when IIS is installed that don't happen after the fact without running a special configuration file.

The alternative approach that you've found is to remove and reinstall the framework.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

No, I am 100% certain that IIS and the 1.1 framework were present before I installed 2.0. I even tried aspnet_regiis -i for both 1.1 and 2.0 and that did not help. Since I did not personally install the 1.1 framework, since both it and IIS were installed from someone elses disk image, I cannot guarantee that they were configured properly.

|||

I am having problems with Reporting Services.

I go to http://localhost/reports and get error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

In terms of configuration, I have set name of Report Server Virtual Directory to "ReportServer2", as it would not let me name it "ReportServer".

I have tried uninstalling .net framework v2 and reinstalling, but this does not help.

Any suggestions?

|||

I'm trying to manually configure my second reporting server instance. I used reports/$rserver as the virtual directory, (rserver is my instance name), and got error message:

"The virtual directory could not be created. The previously set virtual directory will still be used."

Then i used only reports as the virtual dir, the configuration wizard liked it and let me go through. But when i trid to open the URL http://localhost/reports, got the error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

I verified my instance "rserver" was running and i'm sure i installed IIS before I installed SDK.Looks like some of us got the same problems here, have you figured it out yet?

By the way, i installed my only SQL server instance SQLEXPRESS and my first reporting service instance by default. They work fine.