An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors
Hi , I get this error message An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors In my report, i receive parameter values as SQL Server instance name and process it. I get error message for sql server version 2008 R2 servers,2005,2000. but i get output for servers entered as sql server 2008 Sp2. Other than this i get error for all versions of sql server name i enter.Mano
November 20th, 2012 10:31pm

Copy the query in SSMS and run it. Do you get an error? It is possible that MS has changed something in SQL Engine and you need to edit the query.Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2012 10:37pm

Hi, As i mentioned before, when i run in SSMS i get ouput for servers specified in the previous post. Also getting error for servers as " OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Deferred prepare could not be completed.". Msg 916, Level 14, State 1, Line 1 The server principal "NT AUTHORITY\ANONYMOUS LOGON" is not able to access the database "msdb" under the current security context. " My query is DECLARE @sql nvarchar(max),@servername nvarchar(max) set @servername = 'xxx' SET @sql = 'select * FROM OPENROWSET(''SQLOLEDB'',''server=' + @servername + ';Trusted_Connection=yes;'',''select name from msdb.dbo.sysjobs order by name'')' EXEC sp_executesql @sql
November 20th, 2012 11:17pm

Hi, As i mentioned before, when i run in SSMS i get ouput for servers specified in the previous post. Also getting error for servers as " OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Deferred prepare could not be completed.". Msg 916, Level 14, State 1, Line 1 The server principal "NT AUTHORITY\ANONYMOUS LOGON" is not able to access the database "msdb" under the current security context. " My query is DECLARE @sql nvarchar(max),@servername nvarchar(max) set @servername = 'xxx' SET @sql = 'select * FROM OPENROWSET(''SQLOLEDB'',''server=' + @servername + ';Trusted_Connection=yes;'',''select name from msdb.dbo.sysjobs order by name'')' EXEC sp_executesql @sql HI manoj ! You need to enable 'Ad Hoc Distributed Queries' to be able to run 'OPENROWSET' command; EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'Ad Hoc Distributed Queries', 1; RECONFIGURE; GO Please let me know if this doesnt work for you. Hope I have answered you correctly. Thanks, Hasham Niaz
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2012 1:17am

Hi Hasham, it doesnt work even after enabling the option. It works from project, when i go for preview. But doesnt work while accessing via link.. Mano
November 21st, 2012 10:43pm

I used sqlcmd command line utility and it worked fine.Mano
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2012 4:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics