ASP.NET && Anti-virus && SSRS 2005

Mar 2, 2007

Below, I have pasted a portion of an MS MSDN article dealing with a specific issue we are having with Report Server performance. The URL (http://support.microsoft.com/kb/821438/en-us) is the MS KB article on the described fix. The fix mentioned is for "ASP.NET 1.1" but our BP Report Server is using "ASP.NET 2.0".


Has anyone encountered and resolved and how?

Running on box:
ASP.NET 2.0.50727;
SSRS 2005 Sp1 + Hotfix#2175;
Win Server 2003, R2, x64, SP1
Trend Micro OfficeScan Cleint for Win 2003/xp v7.3
IIS Version (I cannot find this #) - ? IE 6.0



===========================
Report Manager or the report server runs very slowly

In some circumstances, ASP.NET applications run very slowly on computers that are running anti-virus software. If the Report Server Web service is restarting frequently, and you are running anti-virus software, you can obtain an ASP.NET fix from Microsoft Customer Support Services.

Symptoms include Web applications or Application Domains restarting for no apparent reason, slow performance, session restarts, and more. For more information about the symptoms, cause, and resolution, see Microsoft Knowledge Base article 821438.

You can find out whether there are excessive server restarts by viewing the number of reportserver_<timestamp>.log files. A new log is created each time the server starts. A large collection of logs created at very short intervals is an indication that the conditions described in article 821438 exist on your server
===========================

View 1 Replies


ADVERTISEMENT

Anti-virus And SQL?

Mar 12, 2001

Do you have antivirus software on your SQL 7 server? Which antivirus product?

Looking for input...

Thanks.

View 2 Replies View Related

Anti-virus Software

Jun 24, 1999

We are new to SQl Server and the NT environments we work on don't have any anti virus software installed. This concerns me. I was wondering how typical it is to install anti-virus software on SQLServer machines, and whether there are any problems associated (e.g. performance degradation) with installing software. We would be most likely to install Dr Solomons. Any comments/shared experiences would be appreciated.

View 1 Replies View Related

Anti-virus On Sql Server Box?

Jun 21, 2007

hi!

i am using sql 2005 with sp1 standard edition.

i have a question regarding the antivirus software. Is it ok to install anti-virus software on the sql server box? what are the issues involved if we install anti-virus software on the sql server box?
I heard, it causes some performance and other issues.

Is there anything we need to take care of .if we decide to install anti-virus software on the sql server box?

Can anybody share experience on this?


Thanks

View 6 Replies View Related

Anti-virus Exclusion List

Dec 21, 2006

Currently, I install an Anti-virus solution on MS SQL Server. It protects windows OS. In order to speed up the SQL performance, I dont want this Anti-virus to scan my SQL database. I want to know what's the exclusion list for the Anti-virus application. Thanks,

View 3 Replies View Related

SQL, Anti-select???

Sep 14, 2007

Anti-select is not the right word, but I want to do the reverse of selecting...
Say, if I have 2 databases, both of which are normalized, representing the same information, but in different table structures. Selecting and joining from the source database will give me a flat 2-dimensional table. Now how can I update the destination database with this 2-D table??
 If you can point me to the right direction, I'd appreciate it.
Thank you,
Hao
 

View 1 Replies View Related

Left Anti Semi Join

Jul 20, 2005

Hi!Whether there is an example where is used "Left Anti Semi Join"?Join Bytes!

View 2 Replies View Related

Any Virus Problems??

Mar 21, 2000

I was wondering if anyone has faced any virus problems while using SQL Server on NT.

Also what are the preventive measures taken?

Thanks!

View 1 Replies View Related

Anyone Aware Of A Virus...

Feb 12, 2004

That targets SQL Server. It deletes all data in random tables, and then truncates the transaction log.

Anyone heard of something like this?

Shaulie

View 3 Replies View Related

SQL Virus Exlusion List

Jan 23, 2008

I have a Server 2003 standard edition server running SQL 2005 standard edition. I have recently installed a Panda antivirus server. Is there a comprehensive document outlining what exclusions I need to set on my virus scans for SQL server 2005?

View 4 Replies View Related

List Of Parameters Used Together With Rs: Parameter In SSRS 2000 And SSRS 2005

Apr 24, 2007

Hi,

Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?

Thanks,

View 1 Replies View Related

SQL Security :: Virus Changing Values In Field

Sep 18, 2015

I've got this virus URL... in our production server. It is changing the values in a table column.

View 6 Replies View Related

Unable To Open Things With Stored Pro... In Their Name: Virus

Aug 15, 2007

I can't use the words "stored pro.." in file names, folder names, or internet searches. I also can't click on links with those words in them. (hence my above abbreviations) The application will close down. I'm putting hyphens between the letters in the hopes that if anyone answers this I will still be able to open it.

i.e., I have a folder on my harddrive called "stored pro---cedures" - I can't open it via any windows applications. I named a word document "stored pro----cedure" and it closed the second I typed it in. I can use "stored pro", but not the other, even if i put or remove spaces between the letters. Even if I type other letters at the beginning and the end, the application will close.

I tried to do a Google search on "windows update" and "stored pro..." but the explorer window closed.


Has anyone else had this problem?

View 4 Replies View Related

Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?

Sep 12, 2007

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!
-ErikR

View 4 Replies View Related

SSRS 2005 - Migrating SSRS Subscriptions

Oct 25, 2007



Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?

I really appreciate your help on this.

Thanks,
Sam

View 6 Replies View Related

How To Genarate Report Using SSRS 2005 And Visual Studio 2005

Apr 17, 2007

Dear All,

I am basically new as far as SQl server 2005 concern.
I want to try out reporting services provided by sql server 2005.
That is make report using sql server 2005 and call that report from web or window application.

Please guide me in doing so or give me some useful link.
Thanks

View 1 Replies View Related

Does SQL 2005 Come With SSIS, SSRS, SSAS, BIDS, VS 2005?

Dec 4, 2007


Hi everybody.

I'm looking to upgrade to SQL Server 2005 (Standard Edition). I'm interested in using SSIS, SSRS and SSAS. I hear that BIDS runs inside of Visual Studio 2005, and comes with the SQL 2005 software. I currently have VS 2003. My question is: Do I need to purchase anything besides SQL Server 2005 Standard, or do I need to buy anything separately, like VS 2005? (if so, which version would you recommend?)

Thank you very much!

- Trevor

View 7 Replies View Related

SSRS 2005

Apr 24, 2006

I have installed SSRS and is trying to run it from the client machines. I am getting this error below.  NOTE: If you run the SSRS Report Manager on the server it runs fine.
Reporting Services Error




An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'Clearview'. (rsErrorOpeningConnection) Get Online Help

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I have setup a local administrative user on their web server called €˜cv_report€™ and setup the virtual directories to run under this account anonymously.  I have also confirmed that cv_report the SQL user exists and is part of the correct roles.  How do you relate the Windows €˜cv_report€™ account and the SQL €˜cv_report€™ account €¦ just via the name?
I even tried changing the Data source for the TEST config which was setup to use Windows NT Authentication and I switched it to use the cv_report account.  It still didn€™t work.
 

View 1 Replies View Related

SSRS 2005

Mar 21, 2008

I have a table Report as follows











Product Category Id
Catergory
Product Subcategory ID
Sub Category

1
Bikes
1
Mountain BikesPlease expand this column width so as to incorporate this sentence

1
Bikes
2
Road BikesPlease expand this column width so as to incorporate this sentence

1
Bikes
3
Touring BikesPlease expand this column width so as to incorporate this sentence

This is how it is visible when i preview the Expense Report. When i export this report to excel; it does not display me the complete details of Sub Category field. I have to drag the column 2 see the complete details...can anyone help me to solve this problem..it urgent

View 13 Replies View Related

SSRS On 2005 Enterprise Edition Connecting To A Db On SQL Server 2005 Developer's Edition, Possible?

Apr 8, 2008



Is it possible to connect SSRS running on SQL Server 2005 enterprise edition (our production system) to a database running on SQL Server 2005 Developer's edition (our test system)

thanks!

View 1 Replies View Related

SSRS 2005 Problem

Aug 2, 2007

hi ,
i am trying generate a report using following query. but the parameter is nt properly passing. (OLEDB). i need to correct it. pls help me.

="WITH "+

"MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'"+

"SET [FilteredBUList] AS 'descendants((STRTOSET ( '{" & Join(Parameters!BU.Value,",") & "}', CONSTRAINED),[Account€”BillingCodeDsc].[Billing Code Description],leaves) ' "+



"SET [CustomTimeSet] AS Descendants([Date€”Fiscal].[2006].[Quarter 1]:"+
"[Date€”Fiscal].[2007].[Quarter 4],[Date€”Fiscal].[month],Leaves)"+



"SELECT "+
"{[Measures].[Amount]} ON COLUMNS,"+

"{ [FilteredBUList] "+
"}on rows"+

" FROM Profitability"

That BU parameter is multi value parameter. query should accept multi values .

View 1 Replies View Related

How To Fax Reports From SSRS 2005

Nov 17, 2006



How do I fax out reports from SQL Server Reporting Services (SSRS) 2005? I tried RightFax 6.0 but it didn't work.

View 4 Replies View Related

Paging In Ssrs 2005

Feb 13, 2008

Hi

Can any one tell me how to enable paging in ssrs 2005 reports, i am using "table" control for the report and when we print the report it gives every thing good, but when we desplay it the web it does not show page by page.

please help me...


thank you.............

View 5 Replies View Related

Can't Uninstall SSRS 2005 X64

Aug 27, 2007

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

View 4 Replies View Related

SSRS 2005 ReportViewer

Aug 23, 2007



Hi,

I am using ReportViewer control for showing reports on my aspx page. I am able to show the report. But for the report both vertical and horizontal scrollbars are coming. when I viewed the report in Report Server website it is coming with out them and i can use the browser scrollbars to see the full report.

I came know the I have to set 2 properties (SizeToReportContent to True & AsynchRendering to False) of the reportviewer control to remove the scroll bars. But even after that the scroll bars are coming. The scroll bars are not coming only if i set ShowToolBar to False. But if i do that I can not see the "page navigation" and "export" etc. options.

Can somebody suggest any way to remove the horizontal and vertical scroll bars with out removing the toor bar of the ReportViewer control.

Thanks,
Srik

View 3 Replies View Related

Using Two Databases With SSRS 2005

Aug 6, 2007

Hi,


I want to use two databases for my reporting services 2005. I want to connect to one database and check whether the logged in user is a portal admin using portalid and userid.If yes, then I will allow the user to user use all the stores. Stores are displayed in the drop down list as the multiselect parameter. If no, then I will connect to another database and check the user rights. Based on the user rights I will select only the stores that are applicable the user. i don't know how to use two databases in the reporting services. Please give me an idea to do this.


Thanks,

Muniappan Kandasamy

View 1 Replies View Related

Exporting In SSRS 2005

Apr 18, 2007

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

View 5 Replies View Related

SSRS 2005 - Charts

Aug 31, 2007

Hi,

Can you please solve my below problem.

I have a data in the report with one column having hyperlink. And below am showing Pie chart with respect to Whole data in the same report. But I want to view for particular value which has to reflect in Chart.

Very Very very Urgent...

Any help would be appreciated.

Thanks
Dinesh

View 2 Replies View Related

SSRS 2005 Goes To Sleep!

Jul 17, 2006

Has anyone figured out why it takes about 30-60 seconds to load a report or even get the login webpage in SSRS2005?? This seems to happen in 2 situations. One, the server has just started up and its the first request for a report or the SSRS webpage. Two, no one has requested a report or a SSRS webpage for a while (say 30min, maybe less). Its like part of SSRS has gone to sleep. Is there anyway to keep this from happening??

View 4 Replies View Related

FavIcon Possible In SSRS 2005?

Mar 19, 2007

Is it possible to have a custom FavIcon configured for a specific installation of SSRS 2005?

Regards, Dave

View 3 Replies View Related

SSRS 2005 Reporting.

Jan 4, 2008

Hi,

i am developing report in SSRS 2005. how to add the database field at the runtime when report is running.i e. when i click on the preview tab, how can i add column there in the report?

can anybody guide me?

thanks & regards,
Vishruti.

View 2 Replies View Related

Ssrs 2005 Sorting.......

Feb 7, 2008

Hi

i am developing ssrs2005 Report using Table control, i need sorting Option for each column,
as well as change the background color of that column (or table header of corresponding column) so that user easily can notice that data is sorted based on particular column

View 3 Replies View Related

Need Help On MDX Query - SSRS 2005

Mar 25, 2008





Hello Everyone,

I have been given a task to develop a SSRS report that Mimic's a ASP.net grid. this grid has four column headers such has


Measures
Jan 2006
Feb 2006
Mar 2006
First "Measure" Column as all the measure captions as the data in rows and other 3 columns (Jan 2006,Feb 2006,Mar 2006 Dimensions) has the measure values as the data in the row.

Measure Jan 2006 Feb 2006 Mar 2006
Profit 12.32 15.23 15.0


Revenue 12.33 16.33 11.22

ROI 2 4 5




In SSRS MDX is not flexible as writing in Query Analyzer , can some one give me the idea how to create this in SSRS report designer.





Thanks,





Pradeep.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved