Cannot Install Reporting Services On Windows Vista
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?
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?
Steps to install SSX (& Reporting Serivces) on 64 bit Windows Vista Ultimate
I struggled quite a bit over the past few days to complete this install. The sequence of steps is less obvious than those for Windows XP Pro on a 32 bit machine.
I recorded all the steps in one place in cookbook style for non-technical (but database capable) users like myself. I have referenced appropriate other postings and sources for detail steps. These are steps I found useful, you may be in a different situation.
My environment is as follows: -New HP dv9000 w/ 2GHz and 2GB memory -Factory installed Windows Vista Ultimate. Note this includes .NET Framework 2.0 so I did not have to deal with installing that. -I have no extant databases or SQL Server that I am trying to convert or upgrade!
Setup Steps Before Install: 1) Turn off User Account Control. At present, I am a one-user operation with close control over my system and there seemed to be issues with getting reporting services set up right with UAC. I may come back and modify this step later on and certainly would change this for any releasable systems.
1a)Go to Control Panel Home --> User Accounts --> Turn User Account Control on or off. 1b)Unselect Use User Acount Control. 2)Set up your IIS 7.0 for Reporting Services. IIS 7.0 has IIS 6.0 Compatibility features turned off out of the box. You will turn them on with this step. This is needed for both Reporting services and to enable the Adminscripts that are used in Step 3 below.
2a) Use the Control Panel --> Programs --> Turn Windows features on and off function. This is quite nicely desribed with screen shots at: http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957 These steps worked for me although they are labeled Vista Beta 2.
3)Set up your 64 bit machine to run 32 bit ASP.NET This capability is needed to make sure you pass the System Configuration Check for Reporting Services. I don't know the full implications of this step and wonder if it might eventually bite me if I have to flip-flop between 32 and 64 bit ASP.NET or have them both run at the same time.
3a) Open a command line window by: Start --> Accessories -- Cmd Prompt 3b) In this window type: cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
At some point, you may wish to go back to 64 bit. For that, see the posting by MihaelaE as an Answer in the SQL Server Reporting Services Forum under a thread started by fagster on 3/8/2007.
Now to actually install SQL Server.
1) Download the 64 bit SSX. This step fooled me for a while as the 64-bit downloads are 'below the fold' on the web page.
1a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/
1b) Scroll down the page and below Step 5, Register, you will see this text which takes you to the download you want: "* For the 64-bit install of SQL Server 2005 Express Edition, click here." 1c) Follow the "click here" to get the download.
2) Install the package from step 1c and you will get SQL Server Express.
2a) The install may fail and complain about not finding a valid SQL Server Native Client Install, sqlncli_x64.msi. You will have to extract the files manually and then run the sqlncli_64.msi package by itself. Then you can go back to step 2 and should be successful. To do this, see post of Mike Wachal on 4/5/2007 to SQL Server Express Forum, titled "Cannot Install SQL Server Express on Vista Ultimate -- cannot find MS SQL Server Native Client".
3) Now add in the SQL Server Management Studio Express 64 bit version.
3a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/
3b) Scroll down the page and below Step 5, Register you will see this text which takes you to the download you want: "* For the 64-bit install of SQL Server 2005 Management Studio Express, click here."
3c) Follow the "click here" to get the download.
4) Now add the SQL Server Reporting Services.
4a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/
4b) Scroll to Step 3 Download and Install (in the middle of the page) and download SQL Server Express Edition with Advanced Services SP2. 4c) Install, but at the Feature Selection screen, disable all components EXCEPT Reporting Services. You already have the other components installed. 4d) In the install, you will get a screen called "Report Server Installation Options". Go ahead and select the "Install but do not configure the server" radio button.
5) Go ahead and configure SQL Server Reporting Services. I'm not highly skilled in this area so I recommend the SQL Server Express Video "Learning Video 10: Getting Started with Reporting Services". This is found at: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx I found this video to be cogent and useful.
That's what it took me to get SQL Server Express installed with reporting services on a 64 bit Vista Ultimate system. Sorry if this is so long but I wanted to cover all the steps that hung me up.
To forum moderators: If I have any errors that will lead people astray, I'm more than happy to correct them.
This posting is "AS IS" with no warrantees and caveat emptor.
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.
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
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?
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!! :-)
Hye all, running WHS 2008, I try to install SQL Server 2005 with reporting services, but on install, in "components to install" wizard, the reporting services box is hided. I can't check this box :/ Do you know whats wrong ? if anyone knows the problem, thanks in advance.
I want to ask a question, I am using Windows Vista Home Premium Edition in my notebook, I installed Visual Studio 2005 in it, it is working properly. Now I want to install SQL Server 2005 Enterprise Edition in it, in the begining it was giving me errors while installing Sql Server 2005 Enterprise Edition, but then it installed properly, but the problem is I cant see the "SQL Server Management Studio" in installed SQL Server, I think it is not installed properly.
I'm currently running Windows Vista x64 and SQL server 2005 on an HP laptop with a AMD Turion 64 processor. I've install all of the Windows Vista x64 update so far with no issues. However, I'm unable to install SQL server 2005 SP2 via Windows updates.
I was able to successfully download the service pack with no issues and it is currenly on my machine ready to install. The system does take a check prior to the install process beginning to perform the install.
I continuely get and "Error Code A91" when the install process is running. As a result the install does not complete successfully. When I used the "Get Help" option I get a list of possible error conditions but none of them seem be useful. I checked each one and none of them provide any help with a solution.
I've successful installed SP2 on Vista x32 system with no problem. Is this a "Windows Update" issue?
Hi, I'm having a problem installing SQL2005 Developer on Windows Vista.
At the System Configuration check page, I'm getting the IIS Feature Requirement item telling me IIS is not installed or disabled. This is not the case.
I have read article http://support.microsoft.com/kb/920201 and switched on the IIS components as specified.
I've tried installing with Firewall, virus checker etc switched off. Every time I get the same problem. This is an issue, as I specifically need Reporting Services installed.
have removed bsn contact manager and all sql related files from previous installation attempts, rebooted so should be a clean install - but still it fails
what did I miss or what am I doing wrong?
here are the logs with ref to the two items that fail
~~~
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Tue Mar 20 18:30:20 2007
Product : OWC11 Error : Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM. --------------------------------------------------------------------------------
Product : Microsoft Office 2003 Web Components Product Version : 11.0.8003.0 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0012_PATRICES-XPS_OWC11_1.log Last Action : InstallExecute Error String : Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM. Error Number : 1706
thanks for any help/light/suggestions you can share
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
I am using Vista Home Premium, Sql 2005 Sp2 & IIS 7.0
I tried to install Reporting service on Vista home premium. Got message there is compatability issue with this version of Windows. Then i check support website and downloaded SP2. BUT CANT STILL INSTALL REPORTING SERVICE ON MY SYSTEM.
Have tried all solution but i think problem is with windows authentication. which is creating problem for me.
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.
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:
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).
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 have some problem about reporting service add-in.
After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.
I try to uninstall and re-install again, it remain not work.
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...
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.
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:
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.
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.
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.
Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:
TITLE: Connect to Server ------------------------------
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?
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?
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'. MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8 Action ended 8:03:54: AppSearch. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'. Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is ' - MSXML6'. Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583'. Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. Action start 8:03:54: CA_ErrorMissingPreReqs. MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3. Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks, --- Barry Roskuski barry.roskuski@esko.com EskoArtwork Ludlow, MA
I originally posted this on the SQL Server Setup and Upgrade forum, but then I found this forum and though it might be more appropriate...
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'. MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8 Action ended 8:03:54: AppSearch. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'. Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1. MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is ' - MSXML6'. Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false) MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583'. Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1. Action start 8:03:54: CA_ErrorMissingPreReqs. MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Setup is missing prerequisites: - MSXML6 Go to http://go.microsoft.com/fwlink/?LinkId=54583 Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3. Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks, --- Barry Roskuski barry.roskuski@esko.com EskoArtwork Ludlow, MA
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports I disabled windows firewall and antivirus (eset nod32) I installed all service packs available I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services Client Tools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.6001.18000 Microsoft .NET Framework 2.0.50727.1434 Operating System 6.0.6001
Hi,I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm tryingto install the MS SQL Server Reporting Services that is in the MSDN of April2004. I also have Visual studio.net installed.So when I run the CD all goes well until you specify the database for thereporting server and then I get the following error:"This edition of the Report Server Database is not supported on the editionof SQL Server 2000 you have chosen. Please choose on that matches therequirements."MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000Developer edition.What does this mean, any comments or feedback will be greately appreciated.- Sergio
How can I install SQL2005 Reporting Services to a local pc? I have a WindowsXP workstation and want to be able to report from SQL databases, and am having a very hard time understanding what is necessary to get to the Reporting Services. I loaded the SQL2005 cd, but when it got to the Components to Install screen, Reporting Services was grayed out and not able to be selected. The SQL databases are maintained on a separate server apart from my workstation. MS Access 2000 is loaded on the computer and I know I can make pass-through queries for reporting, but I really would like to move to SQL2005. I just do not know where to go next. Thanks for any help. Dan
I may be a fool, I installed Sql 2005 on my dev box, and I forgot to check reporting services. Anyway how can I install reporting services once I have installed Sql Server? I tried re-runing setup but I did not see a reporting services option as an option. I am sure I am just missing something simple.
