Showing posts with label servers. Show all posts
Showing posts with label servers. Show all posts

Monday, March 26, 2012

ReportService Deployment

I need to create a installation for a group of report on our customer
servers. Based on googling it seems the only way to do this is via script
or direct calls using SOAP and VS.2005 has not direct support for creating
setup programs.
Is this correct or is there a better way?
Regards,
JohnThere is no direct support for creating an MSI to do deployments, but it
would be fairly easy to write one to push the reports yourself.
"John J. Hughes II" <no@.invalid.com> wrote in message
news:up6Lve8iGHA.4776@.TK2MSFTNGP05.phx.gbl...
>I need to create a installation for a group of report on our customer
>servers. Based on googling it seems the only way to do this is via script
>or direct calls using SOAP and VS.2005 has not direct support for creating
>setup programs.
> Is this correct or is there a better way?
> Regards,
> John
>|||Sorry. crappy response.
You can create a setup project and a custom installer that connects to the
report server and, using the web service calls, adds the reports.
I think you can also use RSS to perform installations.
"John J. Hughes II" <no@.invalid.com> wrote in message
news:up6Lve8iGHA.4776@.TK2MSFTNGP05.phx.gbl...
>I need to create a installation for a group of report on our customer
>servers. Based on googling it seems the only way to do this is via script
>or direct calls using SOAP and VS.2005 has not direct support for creating
>setup programs.
> Is this correct or is there a better way?
> Regards,
> John
>|||Thanks, guess MS only supports the product partially still.
Regards,
John
"Tim Dot NoSpam" <Tim.NoSpam@.hughes.net> wrote in message
news:esmwbxajGHA.4508@.TK2MSFTNGP05.phx.gbl...
> Sorry. crappy response.
> You can create a setup project and a custom installer that connects to the
> report server and, using the web service calls, adds the reports.
> I think you can also use RSS to perform installations.
> "John J. Hughes II" <no@.invalid.com> wrote in message
> news:up6Lve8iGHA.4776@.TK2MSFTNGP05.phx.gbl...
>>I need to create a installation for a group of report on our customer
>>servers. Based on googling it seems the only way to do this is via
>>script or direct calls using SOAP and VS.2005 has not direct support for
>>creating setup programs.
>> Is this correct or is there a better way?
>> Regards,
>> John
>

Friday, March 23, 2012

reportserver url - get Directory Listing Denied

I have two servers, basically identical on which reporting services is installed.

On one when i go to the /reportserver url i get to a listing of report directories/reports o the server.

On the 2nd, I get the IIS error:

Directory Listing Denied

I've checked and all of the settings i can verify (in report server, Iis etc.) are identical on both.

What might cause this?

thx.

r-

The reportserver virtual root should be configured to map all extensions to aspnet_isapi.dll. It sounds like this is not the case. If you are using Report Server 2005, you might want to recreate the virtual root using the Report Server Config Tool.

Wednesday, March 21, 2012

Reports won't attach in subscription email after sp2 installation

Hello,
I installed SP2 on one of the 2 reporting servers we have in our
environment. Before the SP installation, Subscriptions were able to send the
attached reports. Now the job reports an error. I set up the same
subscription and reports to the server not running SP2 (with identical
settings) and the report worked fine.
If I choose to send only a link, then it works. However, any time I try to
add an attachement, I get errors. Any Ideas? There are no specific errors
in the reportserver logs...
Please help!Do you have some Date fields in report ?
Or do you have changed the Default language for report ?
"MustangDJB" <MustangDJB@.discussions.microsoft.com> a scris în mesajul de
ºtiri:51A3960E-4E6E-4FBE-870E-A59ADEBDE85C@.microsoft.com...
> Hello,
> I installed SP2 on one of the 2 reporting servers we have in our
> environment. Before the SP installation, Subscriptions were able to send
> the
> attached reports. Now the job reports an error. I set up the same
> subscription and reports to the server not running SP2 (with identical
> settings) and the report worked fine.
> If I choose to send only a link, then it works. However, any time I try
> to
> add an attachement, I get errors. Any Ideas? There are no specific
> errors
> in the reportserver logs...
> Please help!|||The language was not changed and there are no date fields in the report.
thanks!
"spp" wrote:
> Do you have some Date fields in report ?
> Or do you have changed the Default language for report ?
> "MustangDJB" <MustangDJB@.discussions.microsoft.com> a scris în mesajul de
> ºtiri:51A3960E-4E6E-4FBE-870E-A59ADEBDE85C@.microsoft.com...
> > Hello,
> > I installed SP2 on one of the 2 reporting servers we have in our
> > environment. Before the SP installation, Subscriptions were able to send
> > the
> > attached reports. Now the job reports an error. I set up the same
> > subscription and reports to the server not running SP2 (with identical
> > settings) and the report worked fine.
> >
> > If I choose to send only a link, then it works. However, any time I try
> > to
> > add an attachement, I get errors. Any Ideas? There are no specific
> > errors
> > in the reportserver logs...
> > Please help!
>
>|||The problem was resolved by installing the latest service pack for windows
2003. No changes were required to the report services server.
FYI
"MustangDJB" wrote:
> The language was not changed and there are no date fields in the report.
> thanks!
> "spp" wrote:
> > Do you have some Date fields in report ?
> > Or do you have changed the Default language for report ?
> > "MustangDJB" <MustangDJB@.discussions.microsoft.com> a scris în mesajul de
> > ºtiri:51A3960E-4E6E-4FBE-870E-A59ADEBDE85C@.microsoft.com...
> > > Hello,
> > > I installed SP2 on one of the 2 reporting servers we have in our
> > > environment. Before the SP installation, Subscriptions were able to send
> > > the
> > > attached reports. Now the job reports an error. I set up the same
> > > subscription and reports to the server not running SP2 (with identical
> > > settings) and the report worked fine.
> > >
> > > If I choose to send only a link, then it works. However, any time I try
> > > to
> > > add an attachement, I get errors. Any Ideas? There are no specific
> > > errors
> > > in the reportserver logs...
> > > Please help!
> >
> >
> >

Tuesday, March 20, 2012

Reports Parameters

I use the Reports Servers Design to Design My report, but I need to use multi value fot Report Parameters, But Don.t to do.

Mulit Parameters (Type = 'A' , 'B')

A Value are '1' , '2'

B Value are '3' , '4'

I use SQL Script to Run

Select * From XXX

Where A IN (@.Type)

@.Type may be 1,2,3,4 or 1,2 or 3,4

How to slove

Thanks

this one must work for you:

select the parameter from the Report Parameters menu check the multi-value and then select the radio button non-queried, this should have you a list box with two columns, list all the possible values and labels for what do you want to be visible in the control. Then you can also set the default value you want to in the panel below it.|||

hi BLueDeViL

The Values could store 2 Values like value=1, 2 lable=A

thanks

william

|||

William,

I got your point, and if that's so..i think it is not yet possible. And even the logic of having 2 values for a single label..even the compiler will be confused.

Because take a look at the scenario, what if the user selects 'A' in the multivalue control? Do you think there is a logical way of determining the value, if they both have the same label? The label acts as the index, and that index is only referring to a one dimensional array! If the reporting services shall have a multi dimensional array, where in your case should include 2 values in a single index..this shall be done accordingly.

Hope you got my point. As of now I don't know if that is already possible, but as far as I know it is not yet implemented!

Thanks and more power,

Mark Guerra

Reports on Web farm-Please reply

Hi
We are planning to deploy SQL Server reports on our Internet site which is a
web farm of Windows 2003 web edition servers. We have total 9 boxes in our
Internet web farm and they sit in DMZ spread onto multiple locations. Our
dev/qa environment is inside our network and here are my questions:
1. Does the SQL Server database being used by our Internet servers has to be
in same DMZ domain or can it sit inside out network and then we can pass all
the db transactions back to database inside network? I read somewhere that RS
and SQL Server DB have to be on same domain to work. Is this correct?
2. Also I would like to know how we can deploy all the reports from our
internal dev/qa environment onto our Internet boxes on a continuous basis. I
guess I will have to setup report services on each box and then use some
scripting to move over the required files over to all 9 boxes. Is this
correct assumption? Do we need to copy some files onto each web servers or if
they are talking to same database then the moment we update the db, changes
will be reflected across all web farm sites? Is there any online resource
which describes this whole thing?
Please note that I am not SQL DBA and have just started using SQL Server
reports.
--
ThanksIf you are deploying over the internet then you need to use forms based
authentication and my understanding (but I am hazy on this so don't consider
the answer definitive) is the issue with domains will not matter.
I can answer your second question more definitively than the first. If you
look at a server and look for any rdl files you will not find any. When you
deploy you are not copying files. Deployment is the process where the
reports get stored in the object store for Reporting Services (i.e. in the
database). The whole point of a web farm is they all point to a single
database for the object store and they all see the same reports, report
cache, subscriptions, etc. As far as how you deploy, you can deploy from
your dev machines or you can copy the rdl files over someplace else and then
you scripting to deploy them. An example of how to do this ships with the
product (I always just deploy from the dev environment so I have no ever
scripted this but I know it is possible).
Note for a web farm you have to be running enterprise edition of SQL Server.
Also you need an enterprise edition license for each server in the web farm.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tiwanap" <tiwanap@.discussions.microsoft.com> wrote in message
news:5A5A9C26-2106-4E25-9BC6-6E52000ED2CB@.microsoft.com...
> Hi
> We are planning to deploy SQL Server reports on our Internet site which is
> a
> web farm of Windows 2003 web edition servers. We have total 9 boxes in our
> Internet web farm and they sit in DMZ spread onto multiple locations. Our
> dev/qa environment is inside our network and here are my questions:
> 1. Does the SQL Server database being used by our Internet servers has to
> be
> in same DMZ domain or can it sit inside out network and then we can pass
> all
> the db transactions back to database inside network? I read somewhere that
> RS
> and SQL Server DB have to be on same domain to work. Is this correct?
> 2. Also I would like to know how we can deploy all the reports from our
> internal dev/qa environment onto our Internet boxes on a continuous basis.
> I
> guess I will have to setup report services on each box and then use some
> scripting to move over the required files over to all 9 boxes. Is this
> correct assumption? Do we need to copy some files onto each web servers or
> if
> they are talking to same database then the moment we update the db,
> changes
> will be reflected across all web farm sites? Is there any online resource
> which describes this whole thing?
> Please note that I am not SQL DBA and have just started using SQL Server
> reports.
> --
> Thanks

Monday, March 12, 2012

Reports against Server

Can you make reports against a SQL Servers maintenace plans, DTS/SSIS
jobs and logs in the event viewer? If so what database can I connect
my datasource to my querry this information?
Thanks
steve archer
Perot SystemsJust check the report packs provided by MS in their website. But you cant
access directly instead you need to take all the logs data to your own table
and query for report, so you can create the same using SSIS and schedule it.
Amarnath, MCTS
"captkirkrules" wrote:
> Can you make reports against a SQL Servers maintenace plans, DTS/SSIS
> jobs and logs in the event viewer? If so what database can I connect
> my datasource to my querry this information?
>
> Thanks
> steve archer
> Perot Systems
>

Friday, March 9, 2012

ReportManager - new "Object reference not set to an instance of an object."-error

Hi,

Im having a bit of a problem with reporting services.

First of all, Im running three virtual servers. "MyApp", "ReportServer" and "ReportManager".

In order to have a single sign-on experience, I have authentication configured to Forms in all three web.config-files with the same cookie-name and so forth. I also added a MachineKey to all three web.config files to share the authentication for the virtual directories. (and yes, I use the same machineKey for all three apps)

To login, a user can enter "/MyApp", "/ReportServer", or "/ReportManager" and then I get redirected to "/MyApp/login.aspx" (as that is the setting in the web.config-files).

-
<authentication mode="Forms">
<forms name=".MyApp.Net" loginUrl="https://MyApp/Login.aspx" protection="All" timeout="60" />
</authentication>
-

It works!
The authentication works fine, and I get redirected to the specific directory. MyApp, well, here is the original application, no problems here. The "ReportServer" login works fine too, I get redirected to that directory and the reports I have show-up in a directory-listing type of way...

However...
When I try to go in to the ReportManager I get a nasty error:

-
SQL Server Reporting Services
Error

Object reference not set to an instance of an object.
Home
-

Checking the log-files to see if an error is generated I get the following:

ReportServerWebAPP.log
-
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerWebApp__07_25_2006_15_21_11.log</Path>
<SystemName>MYLOCALDOMAIN</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

w3wp!ui!c!2006-07-25-16:37:52:: e ERROR: Object reference not set to an instance of an object.
w3wp!ui!c!2006-07-25-16:37:52:: e ERROR: HTTP status code --> 500
-Details--
System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.UI.BasePermissions.ReadPermissions(String[] permissions)

at Microsoft.ReportingServices.UI.Permissions.GetPermissions()

at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)

at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!c!2006-07-25-16:37:52:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
-

ReportServer.log
-
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__07_25_2006_15_17_42.log</Path>
<SystemName>MYLOCALDOMAIN</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

w3wp!webserver!1!2006-07-25-15:17:42:: i INFO: Reporting Web Server started
....
....
w3wp!library!1!07/25/2006-16:37:52:: i INFO: Call to GetPermissions:/
-

Now what?
It seems that there is something wrong with the permissions and that this causes the report manager to behave as expected... but I just cant figure out what..


Other things worth mentioning...
Im using custom authentication, overloading LogonUser etc, pretty much according to this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp

However, that part seems to be working fine, since I can access the "ReportServer"!

Ive also tried different permutations of authentication mode="forms", "windows" and impersonate with no luck.

My RSWenApplication.config looks like this:
-
<UI>
<CustomAuthenticationUI>
<loginUrl>https://MyApp/Login.aspx</loginUrl>
<UseSSL>True</UseSSL>
<PassThroughCookies>
<PassThroughCookie>.MyApp.Net</PassThroughCookie>
</PassThroughCookies>
</CustomAuthenticationUI>
<ReportServerUrl>https://ReportServer</ReportServerUrl>
</UI>
-

One last thing that might be of interest... I use SSL on the webserver, but there is no root-certificate installed since this is only a development machine... this was a problem at first, but then I added this to the Global.asax-file in the "ReportManager"-folder.

-
void Application_AuthenticateRequest(object s, EventArgs e)
{
ServicePointManager.ServerCertificateValidationCallback = delegate(Object obj, X509Certificate certificate, X509Chain chain, SslPolicyErrors errors) { return true; };
}
-

And now I get the "Object reference not set to an instance of an object."-error instead!


Please help me... getting increasingly frustrated...

Hey,

did you look at the other threads on this forum about the problem?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=470075&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=444736&SiteID=1

Maybe they offer a solution!

Grts

|||

Hi again,

Yeah, Ive taken a look at both of them and all the pages referenced in those articles... and so forth... still no luck...

Would appriciate any help I can get... been at it for almost a week now and Im starting to loose all hope :-)

Is there for example any place to start looking? Or would I have to tear everything down and start over?

Thanks!

|||A quick look at your config file, but this doesn't look right: https://ReportServer. Is that just a typo?

Wednesday, March 7, 2012

ReportingSrvc Logs filling drive

For no apparent reason RS logging started filling the
servers drive with 33 MB files. Researching it gave a
reboot solution, but no fix. The same 4 lines repeat
themselves.
ReportingServicesService!runningjobs!273c!8/15/2004-
14:22:20:: i INFO: Execution Log Entry Expiration timer
enabled: Cycle: 41859 seconds
ReportingServicesService!dbcleanup!2738!8/15/2004-
14:22:20:: i INFO: Expiring old execution log entries
ReportingServicesService!dbcleanup!2738!8/15/2004-
14:22:20:: i INFO: Expiration of old execution log entries
is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!2738!8/15/2004-
14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
ReportingServicesService!runningjobs!2738!8/15/2004-
14:22:21:: i INFO: Execution Log Entry Expiration timer
enabled: Cycle: 41858 seconds
ReportingServicesService!dbcleanup!273c!8/15/2004-
14:22:21:: i INFO: Expiring old execution log entries
ReportingServicesService!dbcleanup!273c!8/15/2004-
14:22:21:: i INFO: Expiration of old execution log entries
is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!273c!8/15/2004-
14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
Is there a fix for this?
GRWe are aware of this issue and are working on a potential fix. Your best
option at this point is to contact PSS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"GR" <anonymous@.discussions.microsoft.com> wrote in message
news:696501c48399$85c483e0$a301280a@.phx.gbl...
> For no apparent reason RS logging started filling the
> servers drive with 33 MB files. Researching it gave a
> reboot solution, but no fix. The same 4 lines repeat
> themselves.
> ReportingServicesService!runningjobs!273c!8/15/2004-
> 14:22:20:: i INFO: Execution Log Entry Expiration timer
> enabled: Cycle: 41859 seconds
> ReportingServicesService!dbcleanup!2738!8/15/2004-
> 14:22:20:: i INFO: Expiring old execution log entries
> ReportingServicesService!dbcleanup!2738!8/15/2004-
> 14:22:20:: i INFO: Expiration of old execution log entries
> is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!2738!8/15/2004-
> 14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
> ReportingServicesService!runningjobs!2738!8/15/2004-
> 14:22:21:: i INFO: Execution Log Entry Expiration timer
> enabled: Cycle: 41858 seconds
> ReportingServicesService!dbcleanup!273c!8/15/2004-
> 14:22:21:: i INFO: Expiring old execution log entries
> ReportingServicesService!dbcleanup!273c!8/15/2004-
> 14:22:21:: i INFO: Expiration of old execution log entries
> is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!273c!8/15/2004-
> 14:22:21:: i INFO: Cleaned 0 broken snapshots, 0 chunks
> Is there a fix for this?
> GR