View Complete Post
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.
John C. Hancock
MSDN Magazine August 2004
We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.
We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.
I was able to publish my 2005 reports using VS 2005 easily.
1) But when I try to run the reports I am getting below errors at my website home page.
The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)
I could not get why there is no user name in above error and how it says machine name does not have permissioin?
There should be at least some user id mentioned as per me.
What could be the reason of above error?
2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.
"An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.
What should I be doing to resolve above errors?
3) Also one more point about the s
I am looking for suggestion on deploying;
1) Performance Point Scorecards, KPI's, Dashboard, Reports created using dashboard designer from one enviornment to another.
2) Performance Point Web Parts like KPI web part, scorecard web part and report web part.
3) Performance Point Data Sources
Does SharePoint Solution Package support this scenario? How will this work?
Our goal is to define all the configuration for each release which will include add new content, webe pages having various sharepoint web parts and update sharepoint content for future release.
Thank you for your input in advance.
Which factor impacts the Transactions/Sec in SQLServer 2005. What could be the reason to get less Transactions/Sec.
After some code changes in the stored procedure, the Transactions/Sec rate has come down.
We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause. If we use a non-parametrized query (but keep the WHERE
clause the same) the query performs much faster and, in fact, executes a different plan. Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005. Obviously, we'd like to use parametrized queries to prevent SQL injection
but the slow perf is unacceptable. We need the LIKE to support wildcard scenarios. If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries. We're wondering, however, is there another option that would
give us the perf without sacrificing safety? I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...
We are calling store procedure from vb.net client following are the observation.
1) sqlserver 2005 takes huge amount of time (more than 1 hour) to execute procedure. The procedure has select statement using join statement. (Generally this procedure executes and populate data in 5 seconds when it is called from .net client.)
2) If same procedure is executed from sql server management studio, procedure executes and populate data in 5 seconds (works as per expectation)
3) If we recompile procedure (i.e. open procedure in alter mode in management studio and click on execute button) , the procedure executes and populate data as per expectation.
4) This is intermittent issue on production machine. Most of the time procedure is executed and populate data as per expectation when called from vb.net client. But it does not give expected outout in some scenario. The frequency for occurring the issue
is once in 15 days and there is no pattern in which the issue is occurring.
Can any one help to resolve the issue.
Thanks in advance!!!
I am struggling to work out a very frustrating replication issue and wondered if anyone could help me.
Here is my situation.
I have a virtual machine with 16gb RAM and 4 quad core 3Ghz processors and 250gb disk. This has Windows Server 2008 64 bit installed.
The machine has a SQL Server 2005 64 bit instance installed with SP3.
I have setup a publication on this SQL Server called pub1 , this publication publishes all tables/sp's /views and UDF's . I have set the article properties for the published tables as below.
- Copy Check Constraints = True
- Copy Clustered Index = True
- Copy Non Clustered Index = True
- Copy Default Value Spec = True
- Copy Collation = True
- Copy Insert, Update and Delete = True
- Copy unique key contraints = True
- Copy XML Indexes = True
Every other setting is set to false.
I have created a subscription to pub1 within the same SQL Server instance. The database has replicated everything I require without an issue.
If I run a query against the databse that I have published, it returns the query in less than 10 secs. If I run the same query against the subscription DB then this query takes over 30 mins to return.
I thought this was an issue with the indexes not replicating. From what I have selecte
I have MS Accounting Professional 2009 installed on Windows Small Business Server 2008 with the accounting database in SQL Server 2005
I can access the database on the server using my client installation of MS Accounting and use it as expected
When I add another user I am unable to restrict the access rights of that user by selecting a role for them and restricting their access by denying them access to certain areas or providing read-only access to certain areas
What happens when we select a user and select a role and un-tick the Administrator rights box and click ok is that the user rights are not saved without administrator rights. When the user's rights are opened again, the Administrator box has a tick
in it again.
The sequence of events is exactly as described - untick the Administrator box, click ok, then select the user in the "Manage Users" list again, click "Edit" and there's a tick in the "Administrator" box.
In every other respect, MS Accounting appears to work ok, i.e. no error messages, no crashes.
We believe that we should be able to work around this issue by manually setting user access rights directly in the SQL database, but so far we have not been able to do that.
Has anyone ever experienced anything like this, can anyone provide any help or suggestions?
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer
cache the maximum memory is 28GB, the PAGEIOLATCH_SH is always high and the procedure cache is always around 700mB. Durring production hours we have over 6000 connections to sql server (500 users). What is wrong here? Please help. Thank you.