Unable To Configure Reporting Services With Vista/IIS7
Jan 10, 2007
I am trying to configure a reporting server on my laptop at work. This laptop is running Vista and IIS 7. When I install reporting services, the option for "Install the default configuration" is disabled (greyed out) during setup. The install is successful, but then when I try to connect in the Reporting Services Configuration Manager, I get an unhandled exception ("A WMI error has occurred an no additional error information is available."). If I continue, this error continues to crop up as I attempt to configure the Report Server. When I attempt to configure the virtual directory, the configuration manager crashes. Then, when I navigate to the reportserver page, I get a page that states:
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
Any ideas for a solution or workaround would be greatly appreciated.
Thanks,
Dave
View 1 Replies
ADVERTISEMENT
Apr 21, 2008
Hi,
I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:
Report Server Virtual dir: ReportServer Default Web Site
Report Manager Virtual dir: Reports Defualt Web Site
Windows Service Identity: ReportServer with a service acct login
Web Service Identity:
Report Server: ReportServer,
Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.
When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:
"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".
I have read up on IIS7 and it says that:
"This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."
So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?
Thanks!
Isabelle
View 3 Replies
View Related
Feb 25, 2007
I am using vista, iis7 sql server 2005 sp2, vs 2005.
i first noticed that i could not deploy to the localhost server after upgrading to vista.
i installed sql server sp2 and configured the iis7 using the control panel. Everything i needed to check off got loaded exept the asp.net check box in the ApplicationDevelopmentFeatures subcategory under the iis configuration section.
It errored out when i clicked apply. there was no specific error just that it did not get added.
Controlpanel> Programs>T urnWindowsFeaturesOnAndOff> InternetInformationServices> WorldWideWebServices> ApplicationDevelopmentFeatures> Asp.net (check box)
When i click OK, afte a few minutes, i get a message:
"An error has occurred. Not all the features were successfully changed."
what good is iis7 if it cannot support asp.net?
I assume something is wrong. It is not permissions. I am the administrator account and i have assigned my account as the administrator for both sql server and reporting services.
So what is it?
Jerry Cicierega
View 22 Replies
View Related
May 16, 2008
I've created a SSIS package with a DataReaderDestination and a SSRS report that points to it.
I referenced these links during development and I have everything working as expected locally. **I changed the config files as stated on both my local machine and our server. My config matches the example exactly.
http://msdn.microsoft.com/en-us/library/ms345250.aspx
http://msdn.microsoft.com/en-us/library/ms159215.aspx
When I attempt to deploy my report project to the server I get this error message:
"An attempt has been made to use a data extension 'SSIS' that is not registered for this report server."
In the report manager data source properties page it reads:
"The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly."
In SQL Server Management Studio data source properties page SSIS is not a data source type option.
I've tried restarting both the Reporting Services and Integration Services on the server to no avail.
Any suggests? My problem is I can't get the SSIS to be recognized source on the server.
View 1 Replies
View Related
Apr 9, 2007
Hi ,
i'm a new to vista and also with sql server 2005 reporting services ..
i was able to install all the tools in sql2005 express edition except reporting services ..gives a message IIS required ..even though the IIS is running and able to browse http://localhost ..
can any one give me an idea , how to install reporting services on vista with IIS7
Thanks
View 1 Replies
View Related
Oct 12, 2007
Hi all, I tried to configure reporting services configuration by the following
step 1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and click Reporting Services Configuration.
when i did the above step, i received the following error..
No report servers were found on the specified machine.
Details: Invalid namespace
But i installed SQL server 2005 version.
Pls help me to solve this..
Thanks in advance..
Regards Nataraj.C
View 1 Replies
View Related
Feb 20, 2008
Vista + SQL Server 2005
Reporting Service Configuration Tool: No Red Cross.
http://localhost/reportserver get this error:
HTTP Error 403.1 - Forbidden
You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.
http://localhost/reports get this error:
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: Unable to connect to the remote server
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: HTTP status code --> 500
-------Details--------
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 127.0.0.1:443
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!4!20/02/2008-17:17:06:: 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)
I googled but not found anything useful.
Thanks in advance!!!
View 8 Replies
View Related
Apr 29, 2008
Hi,
I have installed SQL Reporting Service on one server. Using the config tool, I am trying to setup the Reporting Database on a seperate SQL instance. This SQL instance is running on a Clustered SQL 2005 server.
The creation of the Database is sucessful. However when I give the Windows credentials to connect to this database on the same page, I always fail at the following task : Setting Connection Info for Reporting Server. The error message is :
"System.Runtime.InteropServices.COMException (0x800706B3)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.Get()
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetDatabaseConnection(String server, String database, ConfigurationCredentialsType credsType, String userName, String password)"
The Windows Account I am using has Full SQL Rights to the Clustered SQL Server. I have seen other posts on the forums about the 0x800706B3 error, but most of them are related to a problem with RPC.
The Reporting Services account is runing under 'Network Services'. I am not sure if this is causing the problem?
Thoughts anybody?
Thanks,
Mahmood
View 8 Replies
View Related
Mar 20, 2007
Hi,
We are currently having a problem with a client running Vista business for a mobile application that uses SQLCE RDA with the Web Synchronization on IIS7.
I have run through the Configure Web Synchronization Wizard and it doesn't create a virtual directory. I manually create the virtual dir and point it to the new folder the Configure Web Synchronization Wizard created.
Browsing to the url "http://localhost/sqlce/sqlcesa30.dll" gives a valid test string.
Here is the ?diag response...
SQL Server Mobile Server Agent Diagnostics
2007/03/20 15:39:49
General Information
Item
Value
Server Name
localhost
URL
/sqlce/sqlcesa30.dll
Authentication Type
Anonymous
Server Port
80
HTTPS
off
Server Software
Microsoft-IIS/7.0
Replication
Allowed
RDA
Allowed
Logging Level
3
Impersonation and Access Tests
Action
Status
ErrorCode
Impersonate User
SUCCESS
0x0
ReadWriteDeleteMessageFile
SUCCESS
0x0
SQL Server Mobile Modules Test
Module
Status
ErrorCode
Version
SQLCERP30.DLL
SUCCESS
0x0
3.0.5300.0
SQLCESA30.DLL
SUCCESS
0x0
3.0.5206.0
Reconciler Test
Reconciler
Status
ErrorCode
9.0 Database Reconciler
SUCCESS
0x0
8.0 Database Reconciler
SUCCESS
0x0
SQL Server Module Versions
Module
Version
sqloledb.dll
6.0.6000.16386
9.0 replrec.dll
2005.90.3042.0
9.0 replprov.dll
2005.90.3042.0
9.0 msgprox.dll
2005.90.3042.0
8.0 replrec.dll
2000.80.2039.0
8.0 replprov.dll
2000.80.2039.0
8.0 msgprox.dll
2000.80.2039.0
When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLOLEDB ...
HResult = -2147467259
Message = " [ 600 ]"
NativeError = 29022
numericErrorParameters = {600,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
Which roughly translates to from the header file ...
#define SSCE_M_INCORRECTPROVIDERVERSION 29022 // The version of the Microsoft OLE DB Provider for SQL Server is not correct. Install MDAC 2.8 or later. [,,,Version,,]
When a Windows Mobile or Pocket PC device tries to do a ServerExecute
or Push or Pull it gets this error message with SQLNCLI ...
HResult = -2147467259
Message = " [ 9 ]"
NativeError = 29022
numericErrorParameters = {9,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
A very similar error.
From this it seems that both SQLCE 2 and 3 seem to want MDAC 2.8+ drivers. The drivers installed with Vista for SQL Native client seem to be versioned 6.0.* and the required versioning would seem to need to be in line with MDAC 2.8.
Are there installable drivers to bump the versioning of SQLNCLI or SQLOLEDB upto MDAC 2.8+ levels?
Or is there an alternative that will make it possible to run SQLCE RDA apps with Vista as the SQLCE server (i.e. sqlcesa30.dll)?
Cheers,
Jonathan
View 5 Replies
View Related
Apr 23, 2007
Sorry if this is a simple question, I've not seen any similar posts.
I'm just finished installed SQL 2005 on Vista Business edition (first time for both). I subsequently installed SP2 for 2005.
Upon completing the SP2 installation, the SQL Server Surface Area Configuration manager opened asking me to grant admin rights to the account I used to install the software. The account I used is the local admin account on the machine (only account on the machine as this is my dev box) .
Nothing shows in the two boxes below on this dialog, "Available Privelages" is blank and "Privelages granted is blank".
In addition, if I go to SQL Server Configuration Manager, and click on SQL Server 2005 Services, nothing shows in the right pain. It's as if the software installed, and yet no instance of the database exists or is running.
My thought was that the admin account I used to install the software doesn't have sufficient privelages to to start the SQL Server or SQLBrowser. So I went to computer management, Local Users and groups (machine isn't on a network yet), and made sure this same account is part of the administrators group.
Any ideas on how I should solve this?
View 1 Replies
View Related
Jun 12, 2015
We have 15-20 report server environments including Dev/SIT/UAT/PROD/DR etc. so instead of configuring it on each servers, we would like a script to use with parameters.
After installing the SSRS 2012 package on each server with given instance and service account, I would like to configure the SSRS through script instead on running the Configuration manager RSConfigTool.exe manually.
we already have created the database beforehand using the scripts provided by WMI. do we need db_owner permission on msdb and master database to configure SSRS?
View 2 Replies
View Related
Aug 22, 2007
I have a report created using MS SQL Server 2005 reporting services and deployed to the report server. I added a subscription for the report to be scheduled to run and emailed to someone on a regular basis. But now we want the report emailed ONLY when there is data returned. If no data is returned after the report runs then don't email it.
Does anyone know how to do that?
Thanks!
View 10 Replies
View Related
Sep 9, 2007
Luckily I still have my old XP PC which has SS Reporting Services installed because my new PC w/Vista Home Premium does not have the Windows Authentication feature needed to install SSRS.
Does anyone know if there is an upgrade for Vista Premium to Business?? I'd much rather learn SSRS on my faster PC.
Thanks.
View 2 Replies
View Related
Jan 21, 2007
After 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
View 1 Replies
View Related
Mar 8, 2007
When I try to install Reporting Services on my Vista x64 machine, the following happens:
In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
On the following section, Reporting Services is greyed out so cannot be installed.I have found many posts on this matter and all of them suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
Can anybody please help?
View 3 Replies
View Related
May 15, 2008
Hi Guys,
I was struggling with installing reporting services from Sql 2005 dev edition on windows vista. I somehow managed to install the SQLExpress edition for Reporting Services, but now i want to unistall it and install Sql Reporting Services from Sql 2005 Dev edition CD.
When I try to unistall the SQlExpress Reporting Servie instance, the screen which says unistalling components disappears in a couple of secs and when i refresh the list of programs installed under Programs and features, i can still see SQLExpress Reporting Servies, i do not understand why this is happening and probably this is the reason behind not able to see the Reproting Services check box ungreyed when installing SQL 2005 dev edition.
CAN SOMEONE HELP ME ON THIS PLEASE?
View 1 Replies
View Related
Sep 5, 2007
I am just wondering....
Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!
I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.
In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...
What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...
View 8 Replies
View Related
Jun 13, 2006
Hello out there!
I've tried to install all features in the SQL Server 2005 to run on Windows Vista. The Reporting Services failed to install. I think it is because of the IIS 7.0 that 's not recognised by SQL Server.
Is there anyone who have had the same problem and is there anyone who have a suggestion to solve this problem?
View 5 Replies
View Related
Feb 13, 2008
I have a brand-new Toshiba laptop, running Vista Business, that I installed SQL Express onto. Prior to installation, I was sure to install all the requisite IIS components so SSRS would install.
The installation ran fine -- installed all components. The configuration ran fine. Everything that is supposed to be green shows green
But, when I go to http://localhost/ReportServer, I get:
Server Error in Application "Default Web Site/ReportServer"
--------------------------------------------------------------------------------
HTTP Error 404.2 - Not Found
Description: The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server.
Error Code: 0x800704ec
Notification: ExecuteRequestHandler
Module: IsapiModule
Requested URL: http://localhost:80/ReportServer
Physical Path: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServer
Logon User: Anonymous
Logon Method: Anonymous
Handler: AboMapperCustom-34881
Most likely causes:
No handler mapping for this request was found. A feature may have to be installed.
The Web service extension for the requested resource is not enabled on the server.
The mapping for the extension points to the incorrect location.
The extension was misspelled in the browser or the Web server.
What you can try:
Install the feature that handles this request. For example, if you get this error for an .ASPX page, you may have to install ASP.NET via IIS setup.
Verify that the Web service extension requested is enabled on the server.
Open the IIS Manager and navigate to the server level.
In the Features view, double-click ISAPI and CGI Restrictions to verify that the Web service extension is set to Allowed.
If the extension is not in the list, click Add in the Actions pane.
In the Add ISAPI and CGI Restrictions dialog box, type the path of the .dll or .exe file in the ISAPI or CGI Path box, or click Browse to navigate to the location of the file.
In the Description box, type a brief description of the restriction.
(Optional) Check "Allow extension path to execute" to allow the restriction to run automatically. If you do not check this option, the restriction status is Not Allowed, which is the default. You can allow the restriction later by selecting it and clicking Allow on the Actions pane.
Click OK.
NOTE: Make sure that this Web service extension or CGI is needed for your Web server before adding it to the list.
Verify that the location of the extension is correct.
Verify that the URL for the extension is spelled correctly both in the browser and the Web server.
Create a tracing rule to track failed requests for this HTTP status code. For more information about creating a tracing rule for failed requests, click here.
More Information... This error occurs when the necessary Web service extension is not enabled, the location or the name of the extension are misspelled or incorrectly entered.
--------------------------------------------------------------------------------
Server Version Information: Internet Information Services 7.0.
The only lead I could find when I googled this error was a reference to running appcmd to ensure that asp.net was enabled. It sure looks like it is:
C:WindowsSystem32inetsrv>appcmd list config -section:isapiCgiRestriction
<system.webServer>
<security>
<isapiCgiRestriction>
<add path="%windir%system32inetsrvasp.dll" allowed="true" groupId="ASP" description="Active Server Pages" />
<add path="%windir%Microsoft.NETFrameworkv2.0.50727aspnet_isapi.dll" allowed="true" groupId="ASP.NET v2.0.50727" description="ASP.NET v2.0.50727" />
</isapiCgiRestriction>
</security>
</system.webServer>
C:WindowsSystem32inetsrv>
Honestly... I'm out of ideas. I've been messing with this for 8 hours now, and I'm ready to fling the laptop out the window. I've completely UNinstalled SQL Server, IIS, reinstalled both, repeated the uninstall/reinstall after double-checking all files were deleted, and so on.
Does *anyone* know how to resolve this error? I checked IIS.NET and although they have a few references to it (not within the Reporting Services context) there never seems to be a definitive answer as to what the solution is.
View 17 Replies
View Related
Jun 10, 2007
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
Any insights?
View 1 Replies
View Related
Apr 22, 2007
Hey guys, I'm creating an ASP.Net 2.0 Web app with VB in the code behind files. I've created a few reports in Business Intelligence Dev Studio that I've deployed to a Windows 2003 Server that has SQL Server 2005 & Reporting Services 2005 on it. Last night I ran into a problem as I tested code on my laptop. And after about 3 hours I have come to the conclusion that it's the way Vista authenticates or its some kind of bug.
When I go to set the report parameters I get an error about invalid credentials and get a HTTP 401 unauthorized. I googled and searched on the forums, however it didn't make sense to me why it was working before now not working. No one was signed on AIM to test to see if it was a specific computer issue, so I decided to try and code a workaround.
I set ShowCredentialsPromt to True and I never got a prompt for credentials when the parameters were attempted to be set. I just got the error. I'm not on my laptop right now, but I will include the exact verbiage of the error message.
i have read lots of posts regarding this by my question is why does the same code not work on Vista than XP? Is that the deciding factor of my issue? I'll get some friends with Vista to test out the site and see if they get the error as well. Any insight?
View 1 Replies
View Related
Mar 17, 2008
I have a couple of questions which is better for commercial development
the standard edition sql or sql express edition?
Does the express edition 2005 in visual studio professional come with
advanced services or do you have install sp2?
Has anyone installed sql 2005 reporting services on vista ultimate
is there anything I should know besides the article How to install
sql reporting services on a windows vista computer? Thanks
I have sql express on my visual studio 2008, however I have
not installed it. Will this be a problem if I install standard ediion?
View 3 Replies
View Related
Apr 26, 2007
When I install SQL Server 2005 Express Edition with Advanced Services SP2 on Windows Vista, Reporting Services and Full-Text Search are not being installed. My user account is configured as a Standard User. When I initiate the installation, I'm prompted for the password for the administrator user account.
During the System Configuration Check, I get a warning for the IIS Feature Requirement action. The associated message says: "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."
KB Article 920201 ("You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server "Longhorn"") seems to address this issue. I used the Windows Features applet and selected all of the Internet Information Services items that were listed in the KB article; however, the "Windows Authentication" item was not in my list. ("IIS Metabase" and "IIS 6 WMI" were in my list but were worded differently--"IIS Metabase and IIS 6 configuration compatibility" and "IIS 6 WMI Compatibility", respectively--but I selected them both.) When I re-ran the SQLEXPR_ADV installer, I got the same warning...and Reporting Services and Full-Text Search were still not installed.
I went back into the Windows Features applet and selected all of the remaining unselected "Internet Information Services" items, and then re-ran the SQLEXPR_ADV installer. I got the same warning...and Reporting Services and Full-Text Search were still not installed.
It's frustrating that there is no obvious reason or error message as to why Reporting Services and Full-Text Search are not being installed. Are these features compatible with Windows Vista? Does anyone have an idea as to what the problem might be?
View 8 Replies
View Related
Apr 11, 2008
I have been through virtually every last posting on installing SQL Server Express with Advanced Services in this site and still have no success accessing the Reporting Services site: http://localhost.reports$sqlexpress. I get a the correct background to the site as in the tutorials, but only get "ERROR - unable to connect to the remote server", which may be indicative because this is all installed on my local machine (Dell AMD Athlon 64 X2 Dual Core 4000+ 2.11 Ghz, 1GB, Windows Ultimate). I have gone through How to install ... on a Windows Vista-based computer, KB934164, and most recently, How to configure .. to allow remote connections, kb 914277, in hopes of addressing the "remote server" issue. I still can't get past this obstacle. PLEASE HELP!! :-)
View 11 Replies
View Related
Apr 24, 2008
All,
While trying to access the Reporting Services in Mng studio.I receive the following error
Cannot Connect To ServerA
Client found response content type of 'text/html; charset=uf-8,but expected 'text/xml'
While trying to access the report on reportmanager.I receive an error."The report server is not responding.Verify that the report server is running and can be accessed from this computer"
Any suggestion?
View 4 Replies
View Related
Aug 23, 2007
Hi all,
I am new to reporting services. I have created a report project in SQL Server BIDS. The datasource is SQL Server. I was able to see the preview of the report and could build and deploy the report. But when I try to run the report, it gives me error. So I tried connecting to Reporting Services through SQL Server Management Studio.
There I am unable to connect to the Reporting Services.
I am getting a very long error message. Giving below few lines which made sense to me.
Client found response content type of text/html; charset=utf-8, but expected text/xml.
Parse Error Message : An error occurred loading a configuration file: Access to the path c:Inetpubwwwrootweb.config is denied
I have given full rights to ASPNET, AuthenticatedUsers.
Pl help to resolve this issue.
Thanks,
Tejaswini
View 14 Replies
View Related
Apr 20, 2015
We have created and scheduled some test reports via Idera performance tool but we are unable to delete the reports. These are not custom reports and reports created with Schedule Email option in Idera. Unfortunately, I dera does not have any option to delete these reports and support is asking me if I tried this by deleting from SQL Server Reporting Services.I looked at the Reporting services but can't find any place to delete these reports. This link does not provide any support because I don't have these (Or Report Manager)----> Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services.
URL....All I have is "Reporting Services Configuration Manager" under "Configuration Tools". How can I delete these reports from SQL Server Reporting services ?. Can I delete them from some tables in Reports databases ?. If so, what are the tables ?. I delete the jobs from SQL Server but the jobs are automatically created the next day emailing the reports again..
View 3 Replies
View Related
May 17, 2007
I have written Custom delivery extension, I am trying to debug this by attching the process ReportingServicesService.exe , I am getting error "Unable to Attach to the Process.Access is denied". I am Admin on my sytem, ASP.net is also part of admin and debuggers group. I am using Visual studio 2005, reporting services 2005, ReportingServicesService.exe is also under my login
Any idea??
View 4 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
Mar 21, 2008
We have a request to build a report based on user input from an excel spreadsheet. We have a SSIS package that imports the data from Excel. This is run by a sql server agent job. Our stored procedure executes this job and runs this whole process just fine but when we execute the stored procedure from reporting services we get errors. Has anyone done this type of thing before and do you have any working solutions for how to get this reporting methodology to function?
Thanks!
View 4 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
Apr 22, 2015
I have two SQL 2014 Enterprise Edition installed with the SSRS (native) role installed.
Both server are configured separately with their own Report Server database. Now I want to configured a scale out deployment with a shared database.
On Server 1, I created a new Report Server database. On the second server, I change the database and joined the existing database. The problem is that the second server never shows up under Scale-Out deployment (Waiting to Join).
View 6 Replies
View Related
Apr 6, 2008
I am new to SQL Server 2005 Reporting Services and I€™m having problems starting the service. I am running a Windows XP SP2 with SQL Server 2005 and reporting services but the service will not start. My SQL Server instance logs on using €˜Windows Authentication€™ using a username sysadm with no password
I have installed IIS and made sure that ASP.net is running.
I have opened up the Report Services Configuration Manager and amended the settings but I€™m unable to get the service started!!!
Theses are my settings
i) Report Server Virtual Directory OK
Name: ReportServer1
Website: Default Web Site
ii) Report Manager Virtual Directory
Name: Reports1
Website: Default Web Site
iii) Windows Service Identity
Service name: ReportServer
Service Account: NT AuthorityLocal Service
Iv Web Service Identity (NOT WORKING)
v) Database Setup
Servername €“ Nameofmyserver
Database name - ReportServer1
Credential Type Server Credentials
When I click on start no error message appears, it just seems to time out.
View 5 Replies
View Related
