Where Can I Find Report Server Log Files (rsServerConfigurationError)
Jul 30, 2007
Dear All ,
when i try to go to run http://localhost/reportserver an error message appear tell me "The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) "
and i dont know where to find the report server log files , so i wonder where can i fin the report server log file (rsServerConfigurationError).
Best wishes to you all
Karim.Maylo
View 2 Replies
ADVERTISEMENT
Nov 14, 2007
Hi am getting the following error when browsing reportserver
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied
please help................
View 1 Replies
View Related
Nov 6, 2007
I have installed reporting services on windows 2003 server and it was working perfectly fine, until i made a change to the IIS making to to use 5.0 version instead of 6.0 worker process model.
made it to use isolated to use previous version of iis which is 5.0., since i will be using both asp.net frameworks 1.1 and 2.0 on that server.
i am receiving the following error:
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.
Can someone please guide me, how to fix the above issue.
Thank you very much for the information.
View 1 Replies
View Related
Jan 21, 2015
Got following query:
SELECT
event_data.value('(event/data/value)[4]', 'bigint') AS cpu_time,
--database name
event_data.value('(event/data/value)[5]', 'bigint') AS duration,
--estimated cost
--estimated rows
--nest level
[code]...
Basically, is a simple T-SQL query that reads the local file for my already setup extended event sessions. But I can't find the way to retrieve the following attributes as part as the T-SQL query:
--database name
--estimated cost
--estimated rows
--nest level
--object name
I am trying to find a BOL or some MS link with the full list of possible values for event_data.value but can't find one.
View 2 Replies
View Related
Jun 11, 2015
Script to find the details of creation date and modified date of all files located in a path?
I wanna write few custom messages before I delete some files from a path.
View 9 Replies
View Related
Feb 23, 2007
Hi,
I created a report and am testing the data driven subscription to email it to myself. It is processed with 1 error. The status says "rsServerConfigurationError".
I opened the log file and it says
GetPermissions:<the report name>
Call to GetSystemPermissions
does this mean i don't have enough permissions? I'm the admin in the server. What else do i need?
Any ideas?
Thanks.
View 4 Replies
View Related
Mar 22, 2007
I installed SQL Server 2005 which include report server but got this error: no report servers were found on this server when trying to configure report server. Am I missing something?
Thanks
View 3 Replies
View Related
May 8, 2015
Is there any way to find Report server database name using T-SQL?
I have SQL server report server instance and authentication credentials.
I can use sys.databases but in case of user had changed ReportDb name at the time of configuration this approach will not work then How I can find?
View 2 Replies
View Related
Nov 23, 2015
I have SQL Server 2012 SP2 x64 Express Advanced Services installed on Windows 10 Pro 64 bit.
I cannot find the Report Builder download link for SQL Server 2012 SP2 x64 Express Advanced Services on Windows 10 Pro.
Shouldn't the Report Builder link be for SQL Server 2012 SP2 and x64 bit in order to work with SQL Server 2012 SP2 x64 Express Advanced Services on Windows 10 Pro 64 bit?The only Report Builder 3.0 links I have found have been x86 (32 bit) and SP1.
View 3 Replies
View Related
May 16, 2007
I have created a database on SQL Express using SQL Server Manager Express. However, when I try to connect to it in Visual Studio 2005, I cannot find the .mdf file so cannot create the project datasource. Can someone tell me where it is? Searching through the files does not find it. Knowing it cannot be obtained directly and needs to be rebuilt some other way would be helpful.
View 5 Replies
View Related
Dec 14, 2006
When you create data files and filegroups, you specify a size. Myquestion is -- how do you know how full they are? Is there a storedprocedure for that?
View 3 Replies
View Related
Oct 6, 2007
Hi
I am working on Report builder project and was wondering if somone can help me with below questions
Is it possible to convert RDL files built in report designer to Report Builde RDL file? if yes then is there any tool or we will have to do it manually. I have also seen that there is no SQL in RDL files created in Report Builder.
If above is not possible then my second question is if we can only copy the layout but as we have got 1000 RDL files in built by report desinger how can we automatically convert this into layout in Report Builder.
Does Microsoft has any specific tools for this?
Will highly appreciate for any help on above.
Thanks
M
View 7 Replies
View Related
May 4, 2015
I need to find all empty files in the database (SQL Server 2008R2 SP2) The files become empty after the archival of a partitioned tables.
I was trying this:
select f.name, *
from sysfiles f (nolock)
left join sys.filegroups fg (nolock)
on f.name = fg.name
left join sys.indexes i (nolock)
on i.data_space_id = fg.data_space_id
left join sys.all_objects o (nolock)
ON i.[object_id] = o.[object_id]
where i.name is NULL and o.name is NULL
Did not work.
My file names are the same as the filgroup names containing the file, this is why I was joining by name.
View 2 Replies
View Related
Sep 3, 2007
Hi gurus,
I've created a linked server (and set up the corresponding schema.ini file) in order to perform bulk-inserts from some CSV text files into SQL tables (from my standpoint the text files are just for reading purposes). The linked server works fine (I can select the data in the files without a problem).
Now the question: is possible to automatically detect when one or more of those files change in order to start the import process automatically? Something like having a trigger created on the CSV files Or there's no easy way to do that so I have, to say something, to create a Job that periodically checks if the files have changed programatically (say, recording each file's timestamp everytime is imported and comparing the recorded value with the current one, or whatever)?
Thanks a lot in advance!
View 1 Replies
View Related
Sep 22, 2005
After I install Reporting Service for SQL 2000, it will establish two virtual directory in IIS: Reports and ReportServer.and I can manage the Reporting Service with Report ManagerBut after I install Sql2005 and with Reporting Service Selected, I can't find these virtual directory. How can I manage the Reporting Service of Sql2005?
View 3 Replies
View Related
Jun 7, 2007
How do I find out the report that is currently being run? I have a scenario where some users run a report without knowing the amount of data that will be pulled by it... In such a case, it bogs down the server and doesn't let me access the Report Manager application.
How can I find out what is the report that is currently being run? I know I can get that information from the Show Jobs link fromm Site Settings in Report Manager. But in this case, I am not even able to login to the Report Manager. The memory (8 gigs) in the app server is fully maxed out and it doesn't log me in to the Report Manger.
I ran a query against the ExecutionLog table in the ReportServer database that logs all the executions. But it looks like the data to this table gets logged only after the report execution is completed. There is no way to tell what is being executed right now. I also checked the table RunningJobs in the ReportServer database, but there are no records in that table.
Can someone help?
Thanks.
View 4 Replies
View Related
Mar 28, 2007
I have a report.
In one of the text field i have to show the rowcount of the dataset
How can i do that
View 5 Replies
View Related
Jan 5, 2007
I have used SSRS since the original SQL 2000 beta, so am pretty experienced with it.
I think there may be a bug in V2.0 (2005) that did not exist in V1.0:
Have just started cutting over my V1.0 reports to V2.0 (2005). One of my users today showed me that the "Find" feature within a V2.0 report searches forward fine. In one case, a three page report, it found the first item on the third page. However, when the "Find" feature was used from that point to get something on the first page, a message was received that it could not find the item. After manually navigating back to page one, and re-entering the same data in "Find" from there, it found the data with no problem on page one.
Has anyone else seen this behavior?
Thanks, Tim
View 1 Replies
View Related
Jan 9, 2015
I proposed on a new server that we separate Data Files, Log Files, tempDB, Backups, etc. onto separate LUNS on a SAN with High Speed Solid State Drives.I was told that with the new technology with solid state SAN's that it would decrease performance and that it did not work the same way as it did when you had RAID 5's etc.I thought that if things were cared out correctly by a SAN Administrator they would know how to configure for optimal performance.
View 2 Replies
View Related
Feb 24, 2015
I have the need to delete old backup files via TSQL job. Found this solution online:
PushD "
emoteservershareDIFF" &&(
forfiles -m *DIFF*.sqb -d -1 -c "cmd /c del /q @path"
) & PopD
It works remotely if I run it via command prompt. But when I add this to a TSQL job on my remote SQL instance, it runs without deleting anything. What I'm missing?
View 6 Replies
View Related
Dec 15, 2009
I am using a Report Viewer on a web page and I'm not sure how to set up the ReportPath.
The URL.... I don't have any permission on the ReportServer database itself. How can I determine the correct path?
View 7 Replies
View Related
May 6, 2015
I came across a SQL 2000 instance with a report server database on it - looking at the execution log storage I can see that its still being used and running the following query tells me that the connections are coming from the same server: SELECT hostname, * FROM sysprocesses WHERE dbid = DB_ID ('ReportServer') but I cant find the SSRS instance in the services -Did it work differently with SQL 2000? How can I find the report manager URL?
View 3 Replies
View Related
Dec 14, 2006
I had a problem with mirroring that I only was able to resolve when I attempted to replicate instead. Replication gave me an error message that expained the problem; mirroring simply failed.
Is there any place where mirroring logs the details of what it is doing & why it is failing?
BTW, the problem was that the server name was changed after SQL was installed. Although i knew this, the forums indicated taht SQL 2005 automatically picks up the new name after it is restarted. This apparently is not true...
Thanks
Dave S
View 2 Replies
View Related
Jul 30, 2007
I have several maintenance plans setup and working in SQL/2005 (sp2 9.0.3042) on several servers; however, the .txt maint plan output files will not delete on any of the servers. The backups run fine, the old database and transaction log backup files delete fine (.bak and .trn); but, the .txt files won't go away unless I delete them by hand. I tried copy/paste the scripted command (xp_delete_file) and it runs with no errors but does not delete the old .txt files. ( This server was upgraded from SQL/2000 -
EXECUTE master.dbo.xp_delete_file 1,N'E:Program FilesMicrosoft SQL ServerMSSQLLOG',N'txt',N'2007-07-09T10:59:38'
)
I do NOT specify a period (.) in the file extension dialog box. Any ideas before I setup a .cmd batch file and schedule it instead?
Thanks in Advance,
DeWayne
View 6 Replies
View Related
Apr 23, 2008
Can I create reports with Crystal Reports and Deploy them in SSRS?
Thanks in advance,
saied
View 1 Replies
View Related
Mar 24, 2008
Hi, we are deploying in an external server a report model and some reports developed with it.
We already have a procedure to deploy the model and reports one by one using upload files feature, we are worried about not to deployed all reports we have to (mistake in manual process). Is there a way to automatize this process?, a command, a program o somethink like this?.
Thanks in advance.
Julio
View 3 Replies
View Related
Oct 7, 2014
I have SSRS Log files under
c:MSSQLMSRS11.MSSQLSERVERReporting ServicesLogFiles
I am getting frequently errors in report manager. When I open that log files, I can see some old logfiles in 2013. So now how to enable that logging feature again.
i.e. before that they enabled the logging in reportserver and disabled now?
View 3 Replies
View Related
Sep 20, 2007
I'm trying to do something which I hope can be accomplished relatively simply.
I have a report similar to bank statements let's say. When run, it currently prints out each person's statement into one file, with page breaks sepearating each person's statement. What I need to do, is when the report is run, save each person's report into a seperate file for the purpose of emailing to them later.
I could easily modify my report to just output for one particular person, but I'm not sure if there's a way to "bulk render" all the reports and have them saved to sepearate files.
I should also add that I'm using an MS Access Data Project (ADP) as the front end to my app - connected to a SQL Server 2005 DB. I currently display the reports by embedding a web browser object into an Access form and rendering the report via HTML.
Thanks in advance,
H
View 1 Replies
View Related
Feb 12, 2008
For those who want to know the root of my question without any of the detail:
I want to know if there is any recommended way to detect and remove potential malware from files uploaded to SQL 2005 Reporting Services via the Report Manager.
Here's a general description of our setup and challenge:
We have a Windows 2003/SQL 2005 Enterprise Server as the reporting database server and another server running Windows 2003/IIS 6.0/ColdFusion MX7/SQL 2005 Reporting Services as the web server. The Report Server is only used internally, but has a potential user community of approximately 150,000. The actual community of users who would have access to the Report Manager would be much smaller.
In our environment, we have no way of ensuring that virus scans are being performed at all of the clients, so we need a way to make sure that files uploaded through Report Manager are all being checked as they are coming in to the Report Server.
Here's what we've tried so far:
We downloaded the Eicar A/V test file and verified that Report Manager has no problem accepting it as an uploaded files by default. The servers are running Norton AntiVirus Corporate 10.2 with the latest definitions and it did not detect the virus as it was being loaded in to the database.
Next, I setup Microsoft ISA 2006 in reverse proxy mode with Kaspersky's Antivirus for ISA. Kaspersky does not prevent a client from uploading the test file to Report Manager, but it does prevent the user from downloading it, so it seems that it only works with HTTP get operations and ignores HTTP put operations.
I have had Watchguard come in with a Firebox (an appliance that they claimed could A/V scan files), but it provided similar results. Files uploaded to Report Manager were ignored, but infected files downloaded were blocked.
I have BlueCoat, TrendMicro, and CheckPoint all on tap to come in and see if they can fare any better, but I am not holding much hope for this.
I know that SharePoint has an API that virus scanners can use (VSAPI) for scanning binaries stored within its SQL database. Is there anything similar for SQL Reporting Services? Is there any other way of preventing these files from entering the application?
Thanks for reading and any responses. I am happy to provide more details if it would be helpful.
View 1 Replies
View Related
Jun 16, 2006
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?
View 5 Replies
View Related
Nov 18, 2008
I wrong a custom code in my report - Public shared Function Myfunc and in the header textbox - I tried to reference this code = Code.Myfunc.... the Myfunc gives an error Unrecognized identifier.The code is written in the report properties = Code Tab.
View 4 Replies
View Related
Sep 9, 2006
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
Apr 11, 2007
Hi -
I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".
I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.
Thanks,
Mike
View 13 Replies
View Related
