SSRS Error: No Such Interface Supported

Hello,

getting the above error when running a report in SSRS 2005, using a stored procedure with many input parameters,

connected to a Sybase IQ database,

I want to have some of the prompts to be multi valued prompts.......

Please advise on how to fix......

 

Thanks.

 

Using the full SQL Server 2005 patched up to build 9.0.3054.

 

Creating a simple maintenance plan to backup specific databases.

 

As soon as i try to save the plan i get the popup error :"no such interface supported". It won't allow me to save any plan at all regardless of what I put in there.

 

I need someone's help!!!!

Hello,

I am using following code line in my web app through external javascript file.

 

this.ViewState.removeChild(this.ViewState.firstChild); 

and

window.__doPostBackOld(arguments[0],arguments[1]);

 

both these methods are working fine in IE6 but failing in IE8 with a error: "Object or Property is not supported".

 

any solution would be appreciated!

 

Thanks

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

I get the following compiler errors when creating my first LINQ to SQL class (I just dragged a table "ProfileExtended" onto the designer and hit build):DataClasses.designer.cs(31,11): error CS1519: Invalid token 'void' in class, struct, or interface member declaration these are the offending lines of autogenerated code:#region Extensibility Method Definitions  partial void OnCreated();  partial void InsertProfileExtended(ProfileExtended instance);  partial void UpdateProfileExtended(ProfileExtended instance);  partial void DeleteProfileExtended(ProfileExtended instance);  #endregion

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

Hello all, I am a windows admin with intermediate knowledge of SQL Server and its components like SSRS. Anyway, I built a production SQL2008 cluster successfully. The head developer also wanted to install SSRS2008 on one of the nodes along with a custom .NET framework application. Needless to say I did get SSRS2008 installed on the active node, but starting having problems with the cluster services and other strange happenings. So I removed SSRS2008 from the node and created a VM, installed SSRS2008 ENT(gonna have to uninstall/reinstall Standard) on that and created the databases via the config wizard and this vm is also running the custom .NET framework application. All of the DBAs agreed that this should have not been installed on the cluster. Now I have to justify why I did this...... 1. For a Production cluster environment isn't is suggested to have ssrs installed on a separate server with it's database housed on the cluster? ( I was told this was an "old school" way of thinking by the developer). 2. Is having SSRS installed on one node of the cluster supported by Microsoft?  In my humble opinion, a database cluster is meant for housing databases only for high availability and nothing else should be present on these two nodes.  Is there any documentation for SSRS that suggests the seperate server deployment rather than including t

I have this one user who can access SharePoint with no problems otherwise but is getting errorAn unexpected error occurred while connecting to the report server When they try to access an SSRS reports I confirmed he has access. Client issue? AD Account issue?Thanks.

HelloI encountered the following error because in my stored procedure, some of the tables were truncated. I resolved the problem, but wanted to know how I can ensure that the report users will not get an error when they run the report and a record does not exist.  Build complete -- 0 errors, 0 warnings[rsRuntimeErrorInExpression] The ToolTip expression for the textrun 'Text.Paragraphs[0].TextRuns[0]' contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.[rsRuntimeErrorInExpression] The ToolTip expression for the textrun 'textbox3.Paragraphs[0].TextRuns[0]' contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.Preview complete -- 0 errors, 2 warnings Thanks,   Kajo  Kajoo

I have read the other topics that are related this issue and I thought that my issue was related as well until I checked the datatypes of all my measures and made sure that they indeed could be inherited properly.   I even went as far as deleting all measures out the measure group and I still recieved this error.   Is there a way I get more detailed information on what is not being converted properly?  The error is so vague and again, I have thouroughly checked my datatypes and they are fine and why would the partition not process, throwing me the exact same error when I decided to take out all measures in the measure group.   Here the second strange thing, I know that it has to be data related because I also ran the process structure and that finished with success. Please let me know if there is a better way to find the problem child or problem children pertaining to my measure group when processing data Here is a last thought, do you think that it could have something to do with the datasize?  I know SSAS automatically converts the datasize and I see several in my measures that have a zero for the size, I am speculating that could be wrong but is there a way I can check the datasize by running the script on my fact table?   ThanksNetwork Analyst

HI ALL, I Have created few reports in SSRS 2008 and deployed to report manager,though reports are working fine in it but sometime what happens when we click any reports its shows error "Service UnAvailable". after getting that report ,i simply close the window and open again after 10 or so ,again it work fine . Please suggest whether its a bug in report manager or i am commited some mistakes over it.   Regards Amit.

I keep getting a weired alert on the SQL Server 2005 Box, I would appreciate if some one can assist me in this. However my application is running smoothly, just wondering if any of you have seen such an error 'Alert 1:  Critical Failure in log file for Monitor_DB: Monitor_DB: :__FAILURE__: error with database connection 'HOSTNAME\INSTANCE@master' with error message: API client not supported' I am not sure what API client is trying to connect, I have a BizTalk server which connects to the SQL Server box, and the connections and processing are going on smooth, but still I keep getting this error. Can anyone assist me. Thanks in advance.

Hi After installing SSRS with SP2 and setting up the integrated database and services I am getting the following whenever I try to browse the the report server website using the URL.  Report Server has encountered a SharePoint error. (rsSharePointError)   e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'Domain\User' are insufficient for performing this operation., ;  Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\User' are insufficient for performing this operation.   I have the reporting service and SQL installed on the same server with the server added to the MOSS farm and central admin running on both the database server and a seperate WFE. In an attempt to find out where the insufficient permissions lay the account being used is a local admin on the database server and a SQL admin and is also being used for the windows server identity and web service identity for SSRS. It is my understanding that I do not need to install the add in for MOSS at this point, and I should be able to browse the sites in a list through the SSRS virtual directory I created under the default website. Many thanks

Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error: "You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)

The following error happens during step 2 of the Configuration Wizard.

****** Error MSG from log******
  Task configdb has failed with an unknown exception
Exception: Microsoft.SharePoint.SPException: The language is not supported on the server. ---> System.Runtime.InteropServices.COMException (0x8102005E): The language is not supported on the server.

***************************

If I start the Wizard again I now get:
************
Exception: System.InvalidOperationException: Windows SharePoint Services configuration infrastructure is not initialized.  You must wait until completion before joining another server to the farm.
************

If I delete the databases and start again I get the first error msg again. 
I have uninstalled and reinstalled WSS3  SP2 numerous times.
The DBServer is the same machine.

TFS 2010 RC is also running on this server.

Any suggestions or help would be appreciated.