hi all
i m facing a problem in reporting services. i have a global database, in which i m mainting user inormation like database name, server name and all credentails about user database. i want that when my report is open a user parameter will display, on the basis of that users id report will display data from his database. server name can be different, database name can be different but schema of database will be same for all user. so pls help me
SQL server 2005 express reporting problem.
error message:
This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service
I got this error message when I try to connect to database hosted in another PC running SQL server 2000.
Is it true that SQlL server Express can only use Local Database Engine to host the database?
I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)
The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
Justin Song
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni
View 4 Replies View Related
Hi every one,
I'm very new new at this. I'm try to deploy a report model and got this message. I have no idea what its going on about.
Can anyone help me?
Aku
------------------------------
System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag)
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo()
at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)
------------------------------
BUTTONS:
OK
------------------------------
every 1 hour my server's computer is restarting !
when the windows finish restarting i open the Event viewer and see that what coused it is the error :
"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."
Event 107
source : "Report Server Windows Service (MSSQLSERVER)"
How can i solve it ?
I would like to know if it is possible to have different applications on separate report servers sharing one report server database. If so are there possible issues or ptfalls to this type of architecture?
Thanks,
thecoleman
Hi
I went to my comp ->rt cick->manage-IIS->default website->rt click->properties->directory security->annoymouse access€¦EDIT->under Default domain it was blank, and i added a domain there.
And i was getting error opening up the reports from localhost.
I changed everything to same as it was previosly, and I am getting the error:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError) Get Online Help
Cannot open database "ReportServer$SQLExpress" requested by the login. The login failed. Login failed for user 'NGESComputer name$'.
Hi,
I am newbie and working with an application that ueses report server 2000 to make reports.
The problem is somebody has moved the database and changed some acounts and now I can not either get any report from the server or install my changes for reports. I used to run this commando to install changes for reports:
rs -i PublishGeckoReports.rss -s http://IpAddress:32808/reportserver -v definitionPath="C:TempDeploymentReportsRDL" -v targetFolder="/MyReports"
here is the error message i get when i try to install:
System.Web.Services.Protocols.SoapException: The report server cannot open a connection to the report server database. The logon failed
when I browse to http://IpAddress:32808/reportserver I get following:
The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
Logon failure: unknown user name or bad password.
at IIS Manager for default web site Enable Anonymous Access is checked and on the database server and the web.config file use same account and password.
but I heard that somewhere there is encrypted password that i have to change it too.
I need your help
Thanks
Hi,
I got consistent error of the following:
ReportingServicesService!runningjobs!13!1/3/2007-10:45:21:: e ERROR: Error in timer Database Cleanup (NT Service) : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
--- End of inner exception stack trace ---
The error happens on Reporting Service version 9.00.3017.00 (the version we are running in Production). The Reporting Service and its database are actually resided in the same physical server. And the strange thing is that it does not prevent any functionalities or features working except when I launch the Management Studio on that server, it usually takes 2 minutes to load up. (any other server would just take 5 -10 seconds).
Can any one help?
Thanks!
William.
I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly today, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver became inaccessable. End users received the following error:
Message: An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Stack Trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at IFA.CAP.SQLReportingService.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in C:ApplicationsIFACAPWeb ReferencesSQLReportingServiceReference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID, Boolean isDraft, Boolean isCertified) in C:ApplicationsIFACAPBusinessObjectsIFA.CAP.BusinessObjects.Report.vb:line 551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e) in C:ApplicationsIFACAPMainCertificateDetail.aspx.vb:line 2287
Subsequently, the following error is logged on the Report Server/Database server:
Report Server (MSSQLSERVER) cannot connect to the report server database.
I was able to temporarily correct the problem by performing as iisrest on the Report Server/Database server. However, the same problem occured again a couple hours later. I am relatively new to SQL Reporting Services so any help would be appreciated.
MDJ
I am getting the following error, when trying to deploy. the report should point to a server which is in my network, but the report is on my machine. where i am trying to deploy locally but point to a different machine.
******************************************************
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.
***********************************
Thank you very much for the information.
Hello,
View 14 Replies View RelatedIs there anyone who knows how to create a database report in SQL server 2000 after we run queries?
Thanks for help
Please could someone advise me the best way to produce statistical reports from a SQL table. The database has been moved from Access and they used to be done by Access queries and reports.
Is it Crystal ? Is there some other way ?
Has anyone used this ? LogiReport from LogiXML
http://www.freereporting.com/?source=google&gclid=CI-jktCKk48CFQYWEAod8CViIw#1
Hi,
I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.
How do I go about generating this type of report. What system tables are to be refered?
Please help.
Thanks
Sri
I would like to generate a report that lists each database in both sql 2000 and 2005 instance alongwith their size. I can get the size sysfiles... perhaps i can join it with sysdatabases ?
thanks
ps. posted in the wrong forums before. apologies.
Hi,
I am very new to SSRS. Currently I am developing a web project which involves report generation through SSRS. My SQL Server Database engine is configured to have Windows Authentication. I want my reports to be secure by creating Accounts. In such a case how can I create Accounts in SQL Report Server database set. Is it possible or is there any other approach to achieve this.
Thanks,
Uma Ramiya
Hello,I am trying to use the SQl Server database reporting tools to create areport on the database to find areas for optimization including tableformats, column formats, and sizes. Can anybody please help me withthis. If any body has used any other tool by which I can create abovementioned reports plz do let me know. I will be really thankful foryour help.ThanksSuneel
View 1 Replies View Related
Hello,
I have a database in MS SQL and need some tool which is able to report the structure - tables and columns with datatype and description. As well each table should have a description. Is there any way how to achieve this goal ? I have spent more than one hour looking at MS SQL Server Management Studio Express and didn't see any possibiliy .
Thanks a lot.
Mario
Hi
I have been asked to create an archive database which we can use for reporting purpuse . The idea is to have a seperate data base which is an exact copy of the current production database , Once we setup the archive DB . we will remove all 40 days old data from Production database and form that day on should have archive DB with full data and production DB with 40 days old.
I thought go going log shipping or back up restor or snapshortor something but the problem is with all these technology the both data base will come in sync . If i delete data from production that will reflect in arvhive also .
I thought of keeping the 40 days only in production and the rest in archive . But they want to wiew the both data together in one aspx page . so i had think of some joint view . But when the archive data gets grow this would be the main perfomence bottlentck
Can any one help me to select a good solution for this, thanks in advance
P M Varughese
Hi,
Currently I have a Report Model that uses a Data Source where the "Credentials are supplied by the user running the report". This works quite well.
The only further requirement is that I would also like to be able to specify which database to use (at runtime), would this be possible?
Kind Regards,
Robert
Hello :
In the heading of the report, I want to put one text area, or i put a datum of the base.
He says to me :
Fields cannot be used in headings o feet of page.
Have you ideas??
Thank you very much
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?
<add name="appdataConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|appdata.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
I have a database in the SQL 2005 default instance and a report server in a named instance. The database has a symmetric key for decrypting one of the columns. When the report server queries the database I get this error: "Cannot find the symmetric key 'key', because it does not exist or you do not have permission."
I know the symmtric key is there because it works when queried from the same instance. Should the database and report server be in the same instance? Or is there a way to change the permissions so that the report server can access the symmetric key in the other instance?
I might note that the report server is able to access unencrypted data in the other instance. The error only occurs when I try to decrypt data using the symmetric key.
Hi,
I need a way to automatically generate a daily report of user names, time of access, and type of access (login, select, insert, update, delete, etc.) to a database.
We need to audit all accesses from all accounts to find out who is accessing the payroll system. We have already defined the security to be as tight as possible - however we need to monitor all Administrator accounts to ensure they are not being used to obtain sensitive information.
I have looked for some software to read the live SQL Transaction Logs, but none of the tools I have seen can do exactly what we require. For example, I've tried Lumigent Log Explorer (http://www.lumigent.com/products/le_sql.html), but it's not automated and the report output is just garble to our payroll staff.
I have looked up all Microsoft SQL Server partners but their software is all about data recovery and data reporting. We need Security Reporting.
I have created a general SQL Profiler trace that may suffice if everything else fails, but I still have no way of automating it - it relies on Real-Time monitoring which I can't trust (admin can turn this off, do their stuff, turn it back on). Also this is dependant on someone turning it off, save the log, turn it back on, every day - this person would be the Administrator - what admin would monitor themselves?
- SQL Trace seems like a good idea, how do I read the trace log file? How do I automate a trace?
- Can we automate the SQL Profiler to read the transaction log to find all accesses to a database?
- Does anyone know what we can do to automatically audit accesses to a database? What format can the report come in (pdf, xls, dbf, html etc.)
- Recommended software to try?
- Ideas for alternatives to try?
- Any companies/developers out there who know of a tool or are developing a tool to provide this sort of report?
- Is there a spec somewhere to let us write our own software to query the live transaction log?
Thanks, I appreciate any help.
Kind Regards
James Payne
IT Administrator
I ran the database consistency on 2 databases, the first little used (and relatively new), the other much more active. On the little used db the report didn't return any lines. On the much more active DB it returned 6 lines (one each for the last 6 days). They all reported 0 errors. Should I be concerned that the one database is actually reporting information, even if it appears to tell me "all clear"?
View 8 Replies View RelatedHey guys,Does anyone know a way (in Enterprise Manager or thru a SQL statement)to get the number of rows and the size of each table in a database?Thks,
View 2 Replies View Relatedhi, can anyone help me out with this report.I need to produce a report for the database level user permission.like for a database: DB_A, I want to output as such:[SELECT] [INSERT] [UPDATE] [DELETE] [CREATE TABLE] .... otherpublic G Dguest D D D D Ddbo G G G G Guser_A G D D D GG stands for Grant and D stands for Deny.I need not only to look at direct grant/deny but also whether that useris a member of fixed database role and fixed server role. like dbo willhave G on all.I am trying to look into sysprotects table and looking at lines with id= 0 but I just can't get to know what different action and protecttypenumbers means!Many thanks
View 1 Replies View RelatedMy db version is sqlserver2005 sp2
Now, I need to install report services
However failed when i specify the report server database after report services was installed
It prompt the database version(C.0.8.40) does not match the report services installation.You must update your reporting services installation.
but how to update reporting services installation?
Thanks a lot
Hail to all the serious Report Server users. Let us all start the documentation effort on Report Server Database (Reporting Services 2005). This will let us work around many problems that occur due to lask of documentation of the RS DB Schema.
Example :
Subscriptions table in the report server database can be used for handling the subscriptions manually. A DML statement coupled with the same on the sysjobs in msdb database can stop corrupt subscriptions (which cannot be modified directly using User Interfaces)
Current Problem
The problem that I am facing is related to the size of the Report Server (it is above 35 GBs, with 422 users) while its counter part with 128 users is only 4 GBs. This is due to a table ServerParametersInstance which is growing in an out-of-bound fashion. The lack of documentation is hurting.
So let us put in some effort & document the RS Database for good.
Any help is greatly appreciated...
Labyrinth
Hi,
Can I use any existing MS report writer for Access database?
Thanks
I have been trying to configure SQL Server 2005 Report Services. Every time I create the ReportServer database, the systems asks me if I want to "update" the database. It allows me no other option. When I click "apply", I get the message that the database version does not match my installation version. Does anybody have any insight into what happening with the configuration? What's more, do you have a solution?
View 3 Replies View Related