Unable To Config SSRS
Mar 11, 2007
My machine is a Vista64bit running a 32bit SqlDev (only dbServices) and a complete 64bit SqlDev. I had to install the 32bit Databse because we have to use some ODBC drivers that can't connect with the 64bits.
When i look in the serices i'm seeing nicely Sql Server (BIT32) and SqlServer (BIT64). I've named the instance so that is is clear to me. But on Sql Server Reporting Services i'm seeing (MSSQLSERVER) as the instance. When i go into the Reporting Services Configuration tool it crashes whenever i try to apply a change ...
Any suggestions, or, where can i change it direclty in registry/xml file ??
View 3 Replies
ADVERTISEMENT
Sep 2, 2015
Currently have a single hard coded file path to the SSRS config file which parses the file and provides the reporting services web service url. Â My question is how would i run this same query against 100s of servers that may or may not share the same file path as the one hard coded ?
Is there a way to query the registry to find the location of the config file of any server ? which could be on D, E, F, H, etc.Â
I know I can string together the address followed by "reports" and named instance if needed, but some instances may not have used the default virtual directory name (Reports).
Am I going about this the hard way ? Is there a location where the web service url exists in a table ? I could not locate anything in the Reporting service database. Basically need to inventory all of my reporting services url's.
View 2 Replies
View Related
May 18, 2008
Had trouble with this in the past. I always get through on luck and fiddling about long enough until now...
All brand new server. Can connect to this new server instance with Management Studio, and with Crystal Reports! Most of the Reports Services Config is now done apart from the very top item, Server Status, is still stopped, and times out when I try starting it - service starts, then stops. Seen this many times before - what causes it?
Database Setup is fine - default database ReportServer has been created and appeared in Management Studio.
Initialization item is grey and I can't even select it in the config window. Web Service Identity is the only other red item - not sure if it matters. Blue item Encryption Keys seems to require restoration or deletion to allow configuration...?
Why can't the Report Server connect to the SQL Server service?
Thanks
Mike
View 5 Replies
View Related
Apr 18, 2007
Hello,
I try to add an data extension who take the information to connect to the database in a config file. But It's could not retreive the values corresponding to the key.
I'm using the class ConfigurationManager from the namespace System.Configuration.
ConfigurationManager.AppSettings["QueryModel"]
Without the config file, the extension is working well.... I got the impression that reporting service and Visual Studio BI don't find the config file.
If someone can help me or have some advices. I will be pleased
View 1 Replies
View Related
Dec 3, 2007
We have SSRS 2005. The install put virtual directories under the website we wanted. We upgraded from Standard to Enterprise, and I put in virtual directories under the default web site so that the upgrade would work just fine. It did.
So, now I have 2 web addresses accessing the same database backend and the same files/folders on the same web server.
Someone added a mapping for .jsx extension and chose select all in the next dialog box and Reporting Services (under that web site) has not worked since. However, the one under the default web site works perfectly well. That leads me to believe that the files are fine, and the connection to the database is fine. I have tried deploying a report and it works.
The error I get from the http://server/reports interface is: Unable to connect to remote server
The error I get from the log files (ReportServerWebApp_) is:
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!6!12/3/2007-14:52:10:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Since it works with the same files and database on the default web site, and not on the website I want it to, I figure its an IIS setting or config problem/issue. I have looked at all the settings in the Properties for both Reports and ReportServer for both websites, but dont see a difference. I have also looked at the settings in the Properties for both web sites and while I know there are a few differences, there should be. (I did try to set them the same just to know, and it still didnt work). I have also deleted and recreated my Virtual Directories under the website I want it to work, with no success.
Anyone have any other suggestions, or links, or anything?
Thanks!
View 1 Replies
View Related
May 9, 2008
Hi
I am unable to start the SSRS . I have tried to start the service through SSRS configuation and even in configuration manager also.
I am getting the following error . help me out
"The request failed or the service did not respond in a timely fashion.COnsult the event log or other applicable error logs for details"
i Have gone thourgh surface area configuration also.
Thanks
View 1 Replies
View Related
Apr 9, 2008
Hi,
In a nutshell I'm unable to connect to SSRS within SSMS yet I can connect to SSIS, SSAS and the Database Engine within SSMS from the same named server instance ("BOODEMO")
"SQL Server 2005 Surface Area Configuration" reports that service status SSRS (DEMO) is running.
The only other problem that I have found which may be linked is that within "Reporting Services Configuration Manager BOODEMO" there is a red circled crossed next to "Report Manager Virtual Directory", yet this application has just recently reported that I successfully created a virtual directory.
Any help or constructive guidance would be greatly appreciated.
Thanks in advance,
Kieran.
View 8 Replies
View Related
Apr 23, 2007
Hi all,
I need help regarding forms authentication in SSRS. I exactly followed the steps described in the article: http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx. However it doesn€™t seem to be working at my end. The only things that I didn€™t implement correctly are the two members of IExtension interface, here€™s the code for these two members;
public string LocalizedName
{
get { return "Naveed"; }
}
public void SetConfiguration ( string configuration )
{
//throw new Exception("The method or operation is not implemented.");
}
After performing all the steps mentioned in the article when I access http://<servername>/reports, it displays my login page alright, but when I submit the user credentials (whether right or wrong) it gives me:
€œAccess denied creating App_Data subdirectory€?
Description: For security reasons, the identity 'NAVEEDSIDDIQUIASPNET' (under which this web application is running), does not have permissions to create the App_Data subdirectory within the application root directory. ASP.NET stores the Microsoft SQL Express Database file used for services such as Membership and Profile in the App_Data subdirectory of your application.
Along with steps of how to grant the required permission. My question is why it is trying to create the new directory. Does it mean it is unable to find the database or does it mean something else? When I access http://<servername>/reportserver, it gives me:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Could not load type 'Vantage.CustomSecurityExtension.Logon'.
Could not load type 'Vantage.CustomSecurityExtension.Logon'.
Could not load type 'Vantage.CustomSecurityExtension.Logon'.
Could not load type 'Vantage.CustomSecurityExtension.Logon'.
Here €˜Logon€™ is the name of the code-behind class of my login page.
Please help me out in this problem.
Thanks and Regards,
Naveed
View 1 Replies
View Related
Apr 11, 2007
I am having mucho difficulties deploying Report Models from my box.
I create a brand new report model project, I add a data source, a datasource view, and a report model. Everything builds fine. I setup the project to point to a valid SSRS Server (and I tried this on another person's box, everything worked fine), click deploy- enter the credentials, and the logon box just keeps popping back up instead of deploying.
When the credential box pops up, it has a "" in it. When I try this on another person's box, it works fine.
I just upgraded to SQL Server 2005 SP2, but I do not have Visual Studio 2005 SP1.
Could some of that be a problem?
View 1 Replies
View Related
Aug 4, 2015
I am having SQL query which has inner join table from another Database. The below highlighted query shows its values.
/*Trend and Capacity Report*/
SELECT MEA.DisplayName AS Cloud, MEB.DisplayName AS VM, OS.PropertyValue AS OS, CONVERT(varchar(17),PD.DateTime,113) AS Date,Â
VM3.VirtualCPUCount AS VCPU
FROM Perf.vPerfDaily AS PD
INNER JOIN vPerformanceRuleInstance AS PRI ON PD.PerformanceRuleInstanceRowId = PRI.PerformanceRuleInstanceRowId
INNER JOIN vPerformanceRule AS PR ON PRI.RuleRowId = PR.RuleRowIdÂ
[code]....
My request is to calculate total capacity of all available Virtual CPUs, Memory and Storage from 4 separate clouds: Â 'cloud1','cloud2','cloud3','cloud4'
Whenever I select =Sum(Fields!VCPU.Value) expression in Report Properties and assign it to a variable and assign that variable to a Text Box field I get the value as VCPU * (Number of VMs) which is not correct.
I am looking to get the value of VCPU from all 4 clouds above.
View 9 Replies
View Related
May 15, 2015
I have deployed SSRS reports to the Report Server, but am not able to open them in PDF.Â
View 3 Replies
View Related
May 20, 2015
when I try to open the SSRS in BIDS ( VS 2008), it is displaying the code portion alone. If i click 'View Designer', it prompts me like "....already opened. Do you want to close?" Only XML content of report is displaying. if I click 'Viee Code' then it displays error like "There is no editor available for 'c: eport Sample. rdl'.Make sure the application for the file type (.rdl) is installed."how to correct this issue by installing or by upgrading?
View 6 Replies
View Related
Feb 22, 2011
I've had a SSL wildcard certificate successfully in use, unless it had to be replaced because of its age. Now I've imported a new certificate, but unfortunately I'm unable to set it up in the SSRS Configuration Manager Console (Web Service URL / Report Manager URL), because "We were unable to create the certificate binding".Â
Â
Here is the Error Message:Â
Â
Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070520
 ---> System.Runtime.InteropServices.COMException (0x80070520): A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)
  --- End of inner exception stack trace ---
Â
I've also deleted the existing bond in the netsh console with "netsh>http delete sslcert ipport=0.0.0.0:443", but this still doesn't fix the issue.
View 3 Replies
View Related
Oct 1, 2015
I am creating simple report in ssrs and pass one parameter only. It will work perfectly (here user enter the parameter value). but i need that i should select the value in drop down box. i had tried many time and did different ways but I am unable to do it.
First i gave the parameter in my sql query in Data set (like WHERE COUNTRY = @COUNTRY) and i checked the Parameters tab in the data set. Here by default comes the Parameter Name: COUNTRY and Parameter value: [@COUNTRY].
Next i select COUNTRY Parameter in the Report Data Pane. and go to properties Here in General Tab: Name COUNTRY Prompt: COUNTRY, Select Get values from query in available values Tab (and also i tried with Select Get values from query in Default Value Tab) and Select Data set: Data Set1, Value field: COUNTRY and Label Field COUNTRY. And Click Ok
And tried to preview the report, it throwing below error
"An error Occured during local report processing. The definition of the report is invalid. The Report Parameter 'COUNTRY' has a DefaultValue or a ValidValue that depends on the report parameter "COUNTRY". Forward dependencies are not valid.
How can I achieve dropdown list.What i missed? Even i unable to do it Multi valued parameters and Cascading parameters.
Actually i am working on SQL Express 2012 version.
View 5 Replies
View Related
Apr 30, 2007
Hello Friends,
I have created few reports in SSRS 2005 on Windows 2003 Standard. Previouly I was not able to view reports from my .ASPX page which contained a ReportViewer, after going throuhg some other threads I was able to create a snap-shot for my reports . But still I'm not able to view reports, each time I try to view the page I get a message box with a error as : "Unable to locate control SSRS 2005: oReportCell" the same error is displayed when i try to access my reports from "http://localhost/reports.....".
But the funny thing is I'm able to view the reports when I use the following URL: "http://localhost/reportserver/pages/reportviewer.aspx?/<report>". I have applied all the Hotfixes & installed the latest Service packs. Any suggestions ???????
View 1 Replies
View Related
Oct 7, 2015
I created a view that i want to use in ssrs.In the view there is a column for running balance.In the table contain transaction of inventory with their quantity.
"SELECT Â Â TOP (100) PERCENT ITEMNMBR, TRXSORCE, DOCTYPE, DOCNUMBR, DOCDATE, HSTMODUL, UOFM, UNITCOST, EXTDCOST, TRXQtyInBase,
             (SELECT   SUM(TRXQtyInBase) AS Expr1
              FROM      dbo.INVTRXB AS b
              WHERE    (DEX_ROW_ID <= a.DEX_ROW_ID) AND (ITEMNMBR = a.ITEMNMBR)) AS ENDQTY
FROM Â Â Â Â dbo.INVTRXB AS a
ORDER BY ITEMNMBR, DOCDATE"
If i run the query on sql or use the view on ssr. The end qty is  not showing accurately.I ran it on another database it works perfectly. Then i noticed that the dex_row_ID of the second database is sequential as the date. But for the initial database it was not sequential as with the date.
View 4 Replies
View Related
Apr 28, 2015
Basically i have 3 images capacity per record in my asp.net application. In there i am saving the image path with record id in database and image in my application folder.
Now i am creating SSRS Report in Report builder . In there i have taken one image control to show the images. In the Image properties in report builder i have chosen database under the select the image source field. then inside use this field i have chosen image url and in use this MIME Type i have selected image/jpeg. Now i have saved this report in report server folder.
Now while calling in .net web from through report viewer control. It is opening the report but wont showing the image.
View 2 Replies
View Related
Oct 9, 2015
I have done the following and a domain user would not access report created a login to the SQL server to the user (this SQL Server is where data source DB is)went to site setting in Report Manager and made this use a system userright clicked on report folder and made this user in the browser roleeven checked that in the report in question, the user is already in the browser role Still the user would not access the report! "User .......... does not have required permission" is the error message I am getting.Â
View 6 Replies
View Related
Mar 8, 2008
Hi,
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €œsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
What do I do next please?
View 4 Replies
View Related
Apr 4, 2007
Hello all,
I'd like to know what's considered a best practice in the following scenario...
We're in the process of converting DTS to SSIS, our current SQL2K setup has one DTS package per database, each database and package are mirror images of each other, with the exception of connection properties and the files path's they pull from. (Occasionally there may be a one off Execute SQL Task that differs from package to package...but this will be handled in a different manner outside of the package from this point on)
From a administration perspective this has been somewhat cumbersome, as every time there is a schema change we need to update the transformations in each individual package...after updating 120 packages my index finger has a bad case of carpel tunnel!
My thought with SSIS is that I can create one package, with many configuration files (one for each database).
Now my question is, 1) is this a good idea? 2) Anytime we create a new database (New Customer = New Database) and need to create a new xml config file, do I have to create the config in BIS/SSIS package then redeploy the package?...or Can I simply add a new config file to the appropriate directory and reference this config in the scheduled job?
Any suggestions are greatly appreciated!
View 1 Replies
View Related
Apr 24, 2007
Hi,
Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?
Thanks,
View 1 Replies
View Related
Sep 3, 2015
Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012
My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?
if not what code changes we should do?
View 3 Replies
View Related
Sep 12, 2007
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
The developer PC is Windows Vista Business.
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
Thanks!
-ErikR
View 4 Replies
View Related
Oct 31, 2007
Hi,My application is acting weird and the research I've done leads me to an answer why it's breaking, but not how to fix it.My web app is hosted by a remote company. I have the main website sitting in the root web directory and in a subfolder I have another application that will handle login and updating the content in the SQL 2K5 backend (not an Express DB).The website itself is able to pull in informaiton from the DB without any trouble, so I know it's able to connect to the DB and everything is peachy. The login app though is acting as though it can't get to the DB. I've applied the ASPNET schema to the DB using the aspnet_regsql.exe from the framework and the login application is using the same connection string as the main website.One thing to note here is that the website and the login app have seperate web.config files since they were developed as different projects.With my customized provider defined in the web.config for the login app I get this error on page load:"Parser Error Message: It
is an error to use a section registered as
allowDefinition='MachineToApplication' beyond application level. This
error can be caused by a virtual directory not being configured as an
application in IIS." If I comment out the custom provider, the page loads but when I try to create a user it tells me that "...the SQL Server couldn't be contacted. This may be because it doesn't accept remote connections." Thing of it is that it's not a remote connection and it's the same connection string and db as the other site.Now, the research I've done points at the two different web.config files, which makes sense. But how do I make the one web.config work for both the website and the subdirectory with the login app? Keep in mind that I can't create any new virtual directories or modify IIS since this is a remote hosting company.Can someone help me understand the fix with a little more clarity?
View 1 Replies
View Related
Mar 30, 2007
Hi,
I'm kind of the first person at my new company to start a project using SSIS. My question(s) revolves around setup and configuration, maybe even best practices.
1. Connection Manager Config - What are some of the methods you use to config your connection managers? I was planning on creating a folder (C:SSISConfig or something) and keeping a config file for each connection there. That way it would be fairly trivial for each developer to also put said folder on there box for deving.
2. Solution set up - Are people creating solutions for each package or just using one Master solution and adding all the packages to that? Or maybe some combination, like having solutions for different areas of functionality or something..? I'm trying to figure out what the pain points are with different approaches.
If you have any other information or horror stories about SSIS that you think might help, feel free to pass them along.
Thanks,
-Ryan
View 1 Replies
View Related
Mar 10, 2007
I want to make an application using a distributed database (single logical database, parts of which are located at more than one location or more than one server). It acts as a single collection of data but the database itself is geographically in separate locations.
How do I make it in SQL Server 2005?
View 4 Replies
View Related
Jul 10, 2006
Hello All,
I am trying to use a custom C# dll from within a script task. The C# dll relies on the Enterprise Library 2.0. Where do I put the enterprise library configuration when I am debugging a package and then when I have the package in production. I cannot find any documentation anywhere on this.
Thanks for any help,
Justin
View 5 Replies
View Related
Oct 25, 2007
Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?
I really appreciate your help on this.
Thanks,
Sam
View 6 Replies
View Related
May 24, 2007
Does anyone have an example of a web.config file that works with Dynamic Data controls? I asked because I can't seem to arrange my "config sections" in any working order. I use 1 connection string in the web.config to establish a conversation with the database. Thanks in Advance.
View 1 Replies
View Related
Nov 15, 2007
I am using vs2005 and have a solution file with 4 projects, 2 of which are presentation layers (admin sections), 1 is a business logic layer, the other a data access layer.
The data access layer project is simply a class library that will provide data access functionality. Im using a dataset (xsd) to create my data access objects. My question is how do I select a connection string from the web config file (which is in each of the presentation layer projects) as the data access layer is a class library there is no web.config. Using the connection string selector in the dataset wizard doesnt show any available connection strings.
View 1 Replies
View Related
Feb 21, 2008
Hi the data connectionstring will be generated automatically in web.config file after dragging a data table from database into webpage.for example: <configuration> <add name="SQLProfileConnString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|MSPetShop4Profile.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </> But what if I have to write the connectionString part myself, I mean where I can get the syntax of it? Thanks a lot
View 1 Replies
View Related
Nov 21, 2003
When I connect locally, my app runs fine. But when I try to connect via FTP to a dedicated server, I can't connect at all. My connection string is in the web.config file. I noticed that the sessionState in web.config is automatically generated with the standard sa blank pwd. I still can't connect even when I change this to the correct uid and pwd. Does anyone know what I need to do? My conn string's data source is "." Please help.
Thank you,
Tina
View 22 Replies
View Related
Apr 6, 2006
I've defined my connection string in the web.config file:
<add name="RealtorXConnectionString" connectionString="Data Source=localhostSQLExpress;Initial Catalog=RealtorX;User ID=sa;password=welcome" providerName="System.Data.SqlClient" />
Now I want to get that string and use it in some code where I'm going to run a query against the database. This query happens in PageLoad, and won't be bound to any UI component. How can I replace XXXXX below with the value stored in web.config?
Dim strConnection As String = XXXXX
Dim cn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(strConnection)
cn.Open()
View 4 Replies
View Related
