Hi All! I'm a newbie to SQL & have a question about Reporting Services. I have already installed SQL Express & now want to install Reporting Services. Is there a way to install just this feature or do I need to do a complete re-install? Thanks!
View 5 RepliesHi,
I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages:
Number of errors: 0
Create Virtual Directory
The virtual directory was created and assigned.
Changing Secure Connection Level
After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft).
IIS shows that virtual directory under default web site was created.
Evenet viewer (application log) shows .NET Framework 2.0 error:
EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.3042.0, P3 45cd6ee2, P4 rsconfigtool, P5 9.0.242.0, P6 45cd6ee2, P7 15a, P8 5, P9 system.nullreferenceexception, P10 NIL
My environment:
MS SQL Reporting Services Version 9.00.3042.00
Windows XP Proffessional SP2
IIS 5.1
all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default.
Any help would be appreciated.
Best regards
Slawomir Nasiadka
Hello!
Has i install SQL Server 2005 Express Edition with Advanced Services but why that Report Manager it was not installed. To me will not address under the reference http: // localhost/reports$SQLExpress since such catalogue is not present in IIS. In what there can be a problem?
Thank's
Hi, i have sql server 2005 standard installed on my machine. I want to work on express edition and learn about it but on the installation its gets stuck because a higher version is installed. If the express version is free why cant have both versions installed on my machine. Thank you.
View 7 Replies View RelatedI'm attempting to install SQL Server 2005 Developer Edition Management Tools [only] on my workstation which is running Widows XP Pro SP2. I already have VSTS 2005 installed with SQL Server Express and Management Studio Express Edition.
Attempting to do an advanced install with just the Management Tools specified under Client Components, results in the Version Check warning that setup must be run with SKUUPGRADE=1 specified. When I do that, the installation fails with an unexpected error. Clicking the 'Help' button, displays the following info:
LinkID 20476
Product Name Microsoft SQL Server
Product Version 9.00.2047.00
Message Source setup.rll
Message ID 50000
EvtType packageengineinstallpackageaction.cpp@InstallToolsAction.11@sqls::InstallPackageAction:erform@0x643
Sending the info results in:
We're sorry
There is no additional information about this issue in the Error and Event Log Messages or
Knowledge Base databases at this time.
which isn't much help. I'd appreciate any suggestions on installing the full version of Management Studio other
than uninstalling SQL Server Express...
I have a server running Windows Server 2003 x64 SP2, SQL Server 2005 Enterprise SP2 (32 bit), and Visual Studio 2005 Enterprise (32 bit).
Did a full install of SQL, then followed with a full install of VS. What's weird is the reporting services portion of SQl appears to have been installed as a 64 bit instead of the 32, so now RS are not available.
Most of SQL shows up under the Program Files (x86) folder, but RS is in Program FilesMS SQL ServerMSSQL.3
Any know how I can pull the RS version out and get it to install correctly without an entire server rebuild as it is already in use?
The kicker comes when I tried to input the proper version again and it told me I needed ASP.net (32 bit) but when I tried to install it the dotnetfx.exe was not compatible. I have .Net Framework 2.0, and 3.5 loaded
Any help is appreciated!
Hi All,
I am creating an installer for the creation and deployment of reports and need to know whether Reporting Services is installed before allowing the installer to run.
Is there a simple way for me to find out? I know that I can look at various registry entries but I'm not sure which is the best. Is this the best way anyway, or is there some better way to tell if RS is installed?
Thanks in advance
Paul
I have a question regarding Reporting Services:
I want to run the Reports on a system that has Oracle Database but reporting Services are not installed there. Only Application exe file will be there designed in .NET Windows Forms.
Reports will access oracle Database.
Hi, all here,
Would anyone here please guide me how can I check the version of reporting services installed? My problem is in my virtual machine, both SQL Server and SQL Server 2005 are installed, but I can create report in the vistual studio 2005 IDE, but cant deploy it to the reporting server database, in addition, I cant connect to reporting services database in SQL Server 2005 management studio.
Is it possible to install two different versions of reporting services in the same virtual machine? Please anyone here give me some advice for that. Thanks a lot.
With best regards,
Yours sincerely,
I have installed windows server 2003 on one of our test boxes (prior to live) and found that reporting services is now unavailable.
When I browse to the report server I get
Service Unavailable
The event log reports several times
"A process serving application pool 'reportserver' terminated unexpectedly. The process id was '3500'. The process exit code was '0xffffffff'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
before the worker process is disabled:
"Application pool 'reportserver' is being automatically disabled due to a series of failures in the process(es) serving that application pool.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
Has anyone seen similar behavior?
Stuart
"
I have SQL 2005 reporting services installed and running, however I do not have the BI dev studio installed and cannot figure out how to get it installed.
The report server is operating correctly since I have developed reports on another pc using VS 2005 and uploaded them to the server.
How do I get the BI dev studio installed on the server?
Could someone from the SQL Server Express team confirm that SQL Server Express SP2 w/Advanced Services shows up as "SQL Server 2005" in the installed programs list? The "Express" portion seems to be missing. And how would one tell the difference between the Standard Edition and the Express Edition based on this?
Thanks.
Hi,
I just got SQL Server Reporting Services and I want to install it. The problem is that SQL Server is on one machine and visual studio along with IIS is on another machine. Is there that I can install reporting services such that the server tools are installed on sql server machine and the development tools are installed on vs.net machine????
Thu June 17, 2004 8:54 AM (NEW!)
Right, I have taken a deap breath and counted to 1000000. I'm calm and cool again, although I am getting fed up with RS.
I'm trying to install Reporting Services Evaluation Edition. I have downloaded it, checked the prerequisites. A server with W2K + latest sp's is running, IIS5 with the latest patches is installed. I have downloaded AUTHZ.DLL and placed in the winntsystems directory. Microsoft NT Framework 1.1 is installed. Visual Studio is NOT installed, since this is on a server and I do not wish to develop here. SQL Server 2000 is installed with the latest sp and patches.
Now, when I run setup for RS the second screen I get tells me:
System check result:
AUTHZ.DLL is not installed on this computer
ASP.NET is not installed or is not registered on this computer
Visual Studio .NET 2003 is not installed
What am I doing wrong?:rolleyes:
Please?
Hello everyone,
I have been trying to install Reporting services but with out success.
At the end of setup I get a message something like this ....unable to connect to the report server please configure manually.
at the command prompt an error message which says ...unable to connect to the database, is being displayed
can anyone advise me on this, please.
we have SQL server 2000,.net2003 installed on windows 2003 platform.
Thank you.
hi, i would like to ask where can i find the installation of reporting services?, is it on installation cd of sql server? or another that i'll have to buy? :) help pls. thank you very much.
View 8 Replies View RelatedHow do I install Reporting Services on SQL Server 2000?
Many thanks
Rupa
I followed the guide at http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#10 and the installation went fine, the problem is that i can't surf to my http://localhost/Reports to test my reportmanager.
This is all i get when opening up that url with internet explorer:
<%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
<%@ Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI" Assembly="ReportingServicesWebUserInterface" %>
Does anyone have a clue about what might have happend?
My computer is running WindowsXP SP2 with iss 5.1
I am completely exhausted trying to install Reporting services on my Windows Vista Home Premium machine.
Each time, I try I get the error message during System Configuration Check saying IIS is not installed or IIS is not turned on. I have gone through this check several times and stopped and restarted IIS and yet no luck. I have even uninstalled IIS, removed my SQL server installation and re-booted my computer. Then re-installed IIS and tried to re-install SQL server the Reporting Services option during is turned off.
Still after al this system configuration checks still comes up with the same message of IIS not installed or IIS is turned off.
please help!!
Hi all, I'm having problems to install Reporting Services in my computer (windows xp home edition) I'm getting this message:
IIS Feature Requirement (Warning)
Messages
* IIS Feature Requirement
* Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Someone can help me?
Thank you
I installed SQL Server Express before Advanced Service were available for download. I now want to install Reporting Services. Can someone explain what steps I must do? Do I uninstall the Express version and reinstall it with Advanced Services? Do I just install Advanced Services and select Reporting Services?
Thanks.
Hi Guys
I am wondering if someone can point me to some categorical information that says "Reporting services (the service/portal/etc basically the part that needs IIS) can be installed on a different physical machine to the machine to the database that you are trying to do reports for". At the movement the network services guys are telling us that there is no way to install reporting services, except to have it on the same machine as the SQL server that you are wanting to report on.
It was my understanding that you could install reporting services on any box as long as that box has IIS, access to a SQL service machine where it can set up its data libraries and definitions it needs and the SQL database that you want to report on. And that it doesn't matter if all three of these parts are on different machines as long as they can talk to each other.
Thus i was wondering if someone can point me in the right direction as to where it says that this can be done (preferably a Microsoft resource). I know that there might be another reason why in our case we can't do this but at the moment the guys are saying that it is a limitation of the software.
Thanks
Anthony
Hi there
We've got 2 servers: one is dedicated database server (NSWNOFUSQD01) and the other one is application/web server (NSWNOFUAPA01).
We've installed the SQL server Database Services, Notification Services, Integration Services and Workstation components, Books Online and development tools into NSWNOFUSQD01 (databases server).
We leave Reporting Service cause we don't want to install the application on this box but we want to install onto different box but the reporting database need to install into NSWNOFUSQD01. So we've tried to install the reporting services into NSWNOFUAPA01 - app server. But while installing it we don't have an option to tell that the database is pointing to different server?!?!.
Any ideas? Are missing step here? I saw these environment working - web instaaling on the app server and database installing on database server.
Thanks
i am having some trouble installing SQl server Reporting Services.well, in order to install the reporting services i have to installServicePack 3a.so through my installation of package 3a i am encoutering some trouble.i was able to comlete the first part of the installation i receivethis error message: Instance name specified is invalidso, my question is: once you have SQL Server installed, where can yougo to find the name of the instanceand once i find it, can i rename it?i originally installed SQL Server a while ago. during the setup, i donot recall a particular name i might have given it.
View 1 Replies View RelatedAfter wrestling my fair share on the Reporting services installation on Vista x64 with IIS 7.0 I figured to write out the details where the bells and whistles are found.
1. First Sergio Tarillo has written good guide for IIS 7.0 configuration so that Reporting Services accepts it. The guide is non-english, but the screenshots are self-explanatory:
http://geeks.ms/blogs/sergiotarrillo/archive/2006/10/16/4703.aspx
2. After that the resulting error is complainment about ASP.NET being 32-bit and not 64-bit registered. This actually means, that the application pool is opted to run 32-bit code. The real toggle is located under IIS management Application Pools ==> Set Application Pool Defaults... (top-right on the screen).
Under there set Enable 32-bit Applications to False.
3. You will need to install SQL Server 2005 SP2 CTP.
Note: The files seem to be named according to the KB article; however the filename does not show how old/new edition the SP2 CTP actually is (or at least I happened to have some from end of the November, when the current one as of now is December CTP - with different file size).
You can catch the December CTP here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en
Or choose the "safer" route and use the "Where to find the latest SPs page":
http://support.microsoft.com/kb/913089
After the SP installation I got the Reporting Server Configuration Manager to work without errors. However I ran out of time to work around the other errors configuration permission issues still.
I'll post follow ups as the thing progresses.
Kalle
Hi Folks,
I want to download Reporting Services for SQL Server Express Edition but I can't find it.
It seems to be in Analysis Services but when I run SQLEXPR_ADV.EXE I don't find any mention of Reporting Services.
I get to the final options choice which offers me 'Database Services' and 'Client Components' but neither of these mentions Reporting Services.
I have installed BI Studio successfully.
I'd be grateful for any and all suggestions.
Thanks a lot.
Barry
Hi my current setup is:
Server 1 - Office sharepoint server 2007
Server 2 - SQL Server 2005 with Service Pack 2 and reporting services
When I try to install the Reporting Services Add-in for Sharepoint on Server 1, I get an error - "Setup was interrupted"
Would you know how to fix it?
Thank you
I'm reinstalling Microsoft CRM 3.0 because it didn't feel like working, and when it tries to validate everything, everything passes except Reporting Services, and i get this:
Setup failed to validate specified Reporting Services Report Server http://4way/reportserver. Error: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>The format of the file 'ReportingServicesWebServer' is invalid.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 27: <assemblies>
Line 28: <clear />
<font color=red>Line 29: <add assembly="ReportingServicesWebServer" />
</font>Line 30: </assemblies>
Line 31: </compilation></pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerweb.config<b> Line: </b> 29
<br><br>
<b>Assembly Load Trace:</b> The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.<br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
=== Pre-bind state information ===
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesWebServer
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/8b363cf2/34a0bf14/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/8b363cf2/34a0bf14/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
</pre></code>
</td>
</tr>
</table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407
</font>
</body>
</html>
<!--
[BadImageFormatException]: The format of the file 'ReportingServicesWebServer' is invalid.
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
[ConfigurationException]: The format of the file 'ReportingServicesWebServer' is invalid. (C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerweb.config line 29)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
at System.Web.UI.TemplateParser.AppendConfigAssemblies()
at System.Web.UI.TemplateParser.PrepareParse()
at System.Web.UI.TemplateParser.Parse()
at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation()
at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound)
at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath()
at System.Web.UI.TemplateParser.GetParserCacheItem()
at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inputFile, HttpContext context, ApplicationFileParser& parser)
at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
at System.Web.HttpApplicationFactory.Init(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--.
Hiya All,
Our public network configuration is set up so that our database server is not directly connected to the internet at all, and does not have IIS installed.
That said, we would like to move to using Reporting Services...
Assuming we install IIS on that box and restrict port 80 to local only, is it possible to configure a subweb/virtual folder on another servers IIS to point to the same folder (on the network) that reporting services used (or some alternate way to configure a remote IIS install for a remote database?)
TIA
Dave Borneman
I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
Thanks to anyone who can help.
-- Mark
Hi,
I am using Windows XP PRO and trying to Install SQL SERVER 2000 Reporting Services.
I have already installed SQL SERVER 2000 developer Edition, sql server service pack 3, VS.NET 2003 and .NET frame work 1.1.
I downloaded the SQL Server 2000 Reporting Services Evaluation Edition. I expected that there are both Server Component and Client Components which are available to install because evaluation edition support all features of Enterprise Edition. However I only saw the Client Components available during setup. Where can I find the Server Components to install? I appreciate very much if I can get advice from any of you.
Thanks,
Jane
To Whom It May Concern:There is a piece of software that was needed to be installed to authorreports in Reporting Services for SQL 2000. That piece of software isVisual Studio .NET 2003. I do not have that piece but I am able toget the beta version of Visual Studio .NET 2005 from Microsoft. Willthat work for the installation and consequently the authoring part ofReporting Services? If not, could someone help me?Thank you in advance!Josh
View 1 Replies View RelatedDear all,
i have a problem on installing SQL 2005,when i was installing SQL 2005,i select to install all components (DB services,Reporting Services,...etc) except SQL Notification services.
the whole components were intalled properly except the reportingservices it was failed and it gave me Error # : 1603
Machine : Machine Name ####
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_XXX_RS.log
Error Number : 1603
when i run the Reporting Configuration manager to try to get the problem,i got this error message :
"The version of DB is in a format is that is not valid, or it can't be read,the found version is C.0.5.43. the expected version is C.0.8.40". To Continue,update the version of the report server database and verify access rights.(rsInvaludRerpotServerDatabase)"