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.
Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
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 have a problem when i want to debug an ssis component under visual studio 2005.
I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.
When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.
however when i begin debugging,it's always skip breakpoint
However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.
While installing SQL Server 2005 Express Edition SP2 or SQL Server 2005 Express Edition with Advanced Services SP2
on Vista Ultimate, I get the error "The feature(s) selected are not valid for this edition of SQL server". Then the installation stops and exist. The only feature selected is Database Services, data files and shared tools.
I'm trying to perform a fresh new install of SQL Express 2005 Advanced SP (CTP) on Vista Ultimate RTM but running into an installation issue preventing me from installing the Reporting Services option. When the SQL Express Advanced installation does it's system configuration check, it gives me this warning ...
- 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.
I do have IIS7 installed and running on my system with all options except for FTP. Why isn't the SQL Express install recognizing IIS7? Is there a workaround? I'd really like to get Reporting Services installed. But SQL Express isn't giving me that option during install because of this IIS issue. Thanks in advance!
I have been trying to install BCM 07 and Accounting Pro 07 for a couple days now with the same SQL Server Express eroor. I've also attempted to install SQL Express sp2 alone to no avail either. Here is the log file from my last BCM install attempt. Any advise would be GREAT! I have already tried changing my PC name to CHARLIE which did not resolve it either. Thanks for the help! Charlie
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 6000) Time : Thu Jul 26 21:21:43 2007
Machine : CHARLIE Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: Timeout error {258}. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Whenever I try to install SQL Server 2005 Express Edition on my Vista Ultimate x64 platform I get error 29506. All I could find on the web was that this is probably due to an access control problem. I have tried installing it as the local administrator, as a member of domain admins, and as the domain administrator. All get the same error. My domain is a Small Business Server domain. This may be part of the problem, but I can't imagine how.
When trying to force access to the domain administrator, I also seem to get an access problem.
I only installed SQL Express on Vista Ultimate OS and installed SQLServer2005_SSMSEE.exe to execute xp_dirtree SP. I could not get some special folders like "Desktop". But I could get the correct result with full installed Dev version SQL. Could anyone help me?
I am tring to install SQL standard edition on a laptop with vista ultermate, I have ISS 7 instaled and active (test by http:\localhost) but when SQL install does is system check it reports that ISS is not install or not enabled, hence the rest of the installation fails also get a error 1706
I'm trying to install just the client components of SQL 2005 on my clean Vista Ultimate machine and am not having a great deal of luck. From what I can see in this forum I'm not the only one. I apologise if this post is going over old ground but none of the other threads quite deal with my query so here goes.
I'm installing from a SQL 2005 Dev DVD. Compatibility checks are being passed fine but once the actual installation starts I get an OWC 11 failure followed by workstation components etc failure. None of the workstation tools are installed. I have tried installing OWC 11 but because I am using Office 2007 it won't let me do it. I can't understand why OWC should cause a failure of the workstation tools installation.
The intention is to use the Vista box as a development client with VS 2005 to work on a Windows 2003 server hosting SQL 2005 Enterprise.
I would really apreciate a steer on this one as I am close to abandoning Vista and going back to XP Pro which would be a real shame.
I have a notbook with vista ultimate and i am trying to install sql server 2005 (developers edition ) on it. The setup fails during the installation giving the message thaht the database service didnot start succesfully. I ahve tried a number of solutions for the issue but all in vain. The user i am using to install the server is an admin user.Plus i am very sure taht there are no h/w dependencies taht are causing the problem.
Can some one please help me . I have been banging my head withteh issue for the past 4-5 days and some some will be reallyy appreciated
========================A section of the SQL.Log file==============================
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER
Error Code: 1067 MSI (s) (8C!B0) [16:28:16:318]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Aug 23 16:28:16 2007 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:28:16 2007 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls:ervice:tart Source Line Number: 301
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER
Error Code: 1067 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5520 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 4116 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 2800 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5220 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 532 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5320 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5836 could not be cancelled. Error: 1168 MSI (s) (8C!B0) [16:28:22:408]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. .
A've installed Visual Studio 2005, SQL Server 2005 and all the SP's necessary. My Problem is I do not have the possability to install a SQL Server Instance of any kind, therefore it is not possible to start any of the SQL Server 2005 Configuration Tools.
I Get the Warnings during the Installation process:
Edition Change Check SQl Server Edition Operating System Campatibility
Any help at all is very much appreciated, thanks a lot.
As the titel suggests I am having quite a strange problem
I have installed an Enotebook on our domain server at work and it uses MSQL express 2005. When I ask it to automatically connect using window authentication to connect it works on windows XP machines with DomainUSERNAME. However when I try the same thing on Windows vista it tells me the logon failed with "DomainUSERNAM". I change it to SQL Authetifcation and type the same username fully (I have added the user via active directory as a SQL user) then it works
Basically it looks like the windows username is sent from Vista missing the last letter.
I have Googled this a lot and have not really found an answer. Am I mearly being very stupid or is this a known issue. Can anyone give me a suggestion as to why this might happen?.
Firstly, can someone confirm that this can be done. Because I am starting to wonder.
I have downloaded the SQL Server 2005 Express install, and attempted to install. Everything goes well. Computer scan indicates that everything is in place, but then when it goes to install the components it states that the following components failed:
(Successful items were SQL Setup Support Files, SQL VSS Writer, OWC11, SQL Server Backward-Compatibility Files, SQL Server Management Studio Express).
For those Items that failed, I just get a message stating "Setup failed. Refer to Setup Log'. The setup log tells me little to nothing about why these components failed.
I am also getting the following message part way through install "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.mis'". Does anyone know what this means? I downloaded the install from microsoft.com just a few days ago, so if this isn't "valid", then where do I get a valid one.
I'm totally stuck. Have spent almost a day trawling documentation etc. to find why these have not installed, but cannot find any indication of why they wont install.. everything that needs to be in place is. Hoping someone has had similar issues and can help.
I want to create deployment for MS SQL 2005 Express database, that creates database, tables and inserts data. I have made a similar with VisualStudio 2003 and MSDN
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation :
SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)?
Any work around for this issue?
P.S.: I didn't install VS.NET 2005 yet, can this solve the problem?
I am running on Vista Ultimate and Installing Sql Server 2k5 enterprise edition
Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration:
TITLE: Microsoft SQL Server Management Studio ------------------------------
Attach database failed for Server 'ZAPHOD42MSSMLBIZ'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1827&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
=================================================================================== The following is the Help obtained when clicking on the button on the error msg and the references in the error msg: ===================================================================================
Details ID: Attach database Server Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText
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. You can use the links in the Support area to determine whether any additional information might be available elsewhere.
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.
==================
Details ID: 1827 Source: MSSQLServer
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. You can use the links in the Support area to determine whether any additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
==========End of reproduction of error messages and help text ====================================
The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).
Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released?
When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though?
All of the features are green ticked except the OS which has a compatabilty warning (which i expected).
I feel im missing something really simple here....
I am getting the error message below when installing sql server 2005 dev edition on windows vista ultimate. I just bought a new hp notebook and installed visual studio 2005 pro and office 2007. Works very well. Then I'm trying to install sql server 2005 dev edition and get the error below. Please help
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'SAVIOURSQLServer2005MSSQLUser$SAVIOUR$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition.
I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel.
I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005.
1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over?
I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working...
2) What should I be doing to install SQLServer 2005 Developer Edition successfully?
I have been a strong supporter of Microsoft, but this is getting me very frustrated.
How to avoid a SQL Native Client Instalation (a corrupted package ? from MSDN Disc !?) during MS SQL 2005 Server Standard instalation on MS Windows Vista Ultimate RC1 ?!?
Generally after this error all instalation failed !
I was playing around with SQL2k5 Express, but decided to download Enterprise using my MSDN subscription. I installed it, but none of the services are running. I don't understand why?
I've checked the requirments and I notice that Vista x64 is not on the list for compatible OS's.
I do get this when trying to install:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Also, during the install, Componoents to Install: All the services are greyed out... is that because they can't be installed or because they're going to be installed by default?
Anyone else have it running on Vista Ultimate x64? Am I doing something wrong or does it just not install on this version of Vista?
I am having trouble installing disc number 2 on sql standard 2005( I installed disc one) I get the message my workstation components are already installed etc.It will not allow me to go any further It seem like everything installed Here is my summary.... I unistalled vs 2 express 2005---I never used it...... Here is my list on my vista ultimate computer sql server business intelligence, sql server management studio, analysis services installed configuration tools documentation pefmorance tools Did I need to install disc 2 instead of disc 1? one I am using vista Please help ? I tried opening business intelligence studio it says it has compability issues Here is my log: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Tue Apr 29 14:13:59 2008
Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_5.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_3.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_5.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_5.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_6.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_4.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU Product Version : 8.0.50727.42 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_PPESku_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_6.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BOL_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_6.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Integration Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_DTS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLXML4_1.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQL.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLXML4_2.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Analysis Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_AS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Notification Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_NS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Reporting Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_RS.log -------------------------------------------------------------------------------- Machine : BILLPREC690 Product : Microsoft SQL Server 2005 Tools Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_Tools.log --------------------------------------------------------------------------------
then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Wed Dec 06 13:01:54 2006
TJM-PC : The current system does not meet the minimum hardware requirements for this SQL Server release. For system requirements, see Hardware and Software Requirements, in the readme file or in SQL Server Books Online. TJM-PC : 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. Machine : TJM-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU Product Version : 8.0.50727.42 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_PPESku_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_OWC11_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BOL_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLXML4_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Tools Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_Tools.log --------------------------------------------------------------------------------
could any one tell my how could i intall the sql server database services and other services?
I've tried all I know in an effort to get SQL 2005 Express to allow remote connections on my customer's 2K3 server and I'm not having any luck. I've followed MSKB 914277, including adding the exceptions to their Windows firewall...even disabled the firewall altogether (for testing purposes), and I still can't get remote clients to connect. As suggested by various other posts, I used netstat -an to confirm that SQL is listening on port 1433 for the desired IP on the server.....and saw that it is listening. Here's a snippet:
TCP 192.168.0.2:1433 0.0.0.0:0 LISTENING TCP 192.168.0.2:1433 192.168.0.2:1738 ESTABLISHED TCP 192.168.0.2:1738 192.168.0.2:1433 ESTABLISHED TCP 127.0.0.1:1433 0.0.0.0:0 LISTENING
I can connect to the database locally (i.e. on the 2K3 server itself) using just the IP address .... tried with a DSN, UDL, ODBC, and SSMSE...all of which have no problems (as shown by the two, "ESTABLISHED" entries in the netstat results above which were from running SSMSE locally on the server at the time of the netstat). But if a remote computer on the network tries to connect, they cannot connect. Sorry, I don't have a copy of the error message the clients are getting yet.
I asked The customer's IT to confirm that the clients CAN can "see" the server (i.e. that there wasn't some kind of router or firewall blocking their path) and they sent me a copy of the server's pfirewall.log file. Here is an entry from the file that seems to show that client requests ARE getting to the server:
I'm starting to get in over my head here (I'm a programmer, not a DBA or Net Admin), but doesn't the above suggest that an incoming request came in from .4 on port 1213 and attempted to connect to .2 on port 1433, but the connection was denied or dropped by the server? If so, why? Is this related to another MS KB I read about connection pooling? I'm way over my head here and could use some help. Did I miss something subtle during configuration of SQL Express? Thanks in advance.
I am trying to install SQL Server Express - (the non ADV version) and get the following error.
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".
I have 64 bit Vista Ultimate running on an HP dv9000.
I am using the download from the bottom of the download page for SSX where it says 64 bit version.
Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.
I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.
I would appreciate being pointed at the right downloads for what seems to be a simple install.
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
