.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Installing SQL Server 2005 Enterprise in Windows 7 Professional

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server


i have Windwos 7 Professional Installed in my computer. also i have installed Visual Studio 2008 as well.

last week i wanted to install SQL Server 2005 Enterprise Edition in my computer so i came to know that u need the SQL Server 2005 Service Pack 3 for this as well.

after obtaining both the Enterprise Edition Setup and the SP3 Setup of SQL Server 2005, i began the installation. first i installed the server. and selected The Server and Workstation components. but when the installation was progressing, it gave a message that the workstation componenets could not be installed and hence only the MSSQLSERVER Service got installed. i take think this so seriously hoping that client tools (workstation componenets) can be installed after the SP3 is being installed. so after the setup completed, i installed SP3 as well. even there, the client tools were disabled.

after SP3 installation and System Restart, i couldnt find Managament Studio; so i again went to the SQL server 2005 setup and selected the client tools to be installed. but just before the installation started, an error message prompted saying that "one or more componenets could not be installed" and then exiting the setup..


please advise what i am missing. i tried the same thing using SQL Server 2005 Standard but the same thing happens.



View Complete Post

More Related Resource Links

Does SQL 2005 Enterprise Edition come preloaded on Windows Server 2003 Virtual Server.

Does SQL 2005 Enterprise Edition come preloaded on  Windows Server 2003 Virtual Server. I found this link http://www.microsoft.com/downloads/details.aspx?FamilyID=77f24c9d-b4b8-4f73-99e3-c66f80e415b6&displaylang=enMr Shaw

Installing SQL Server 2005 Developer Edition (64 bit) on Windows 7 Home Premium (64 bit)

Hello All, I would like to know if I can install SQL Server 2005 Dev Edition (64 bit) on Windows Home Premium (64 bit)? I have enabled the IIS via the control panel. Is there anything else that I need to do before I start the installation? Please assist. Thanks, CD

Installing SQL Server 2008 R2 Enterprise on Windows 7 - Setup Suport Files

The problem is when i try to install a new instance of SQL Server 2008 R2 Enterprise the wizard stops working when is trying to install Setup Support Files, and nothing happens. I cannot add the entire log file of the instalation, so i leave only the last lines. : ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping Action: FinishPage 2010-09-10 11:46:24 Slp: Action is being skipped due to the following restrictions: 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected. 2010-09-10 11:46:24 Slp: ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping property RequireMode of class: StopAction 2010-09-10 11:46:24 Slp: Input of property will not be set due to the following failed restriction(s): 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected. Can you help me?    

Problem Installing SQL 2005 Enterprise on Server 2008R2 Enterprise???

I am trying to install SQL Server 2005 Enterprise onto a new WinServer Enterprise 2008R2 box.  I am using my MSDN disk that contains the various flavors of SQL Server 2005.  When I select to install Enterprise (64 bit) version all that is available for installation are the client tools, no server tools.  When I install the Standard version, the server tools are available. Is there a problem installing SQL 2005 Enterprise on WinServer Enterprise 2008R2???

Installing SQL Server 2005 management studio express with Windows 7

I have bought a new laptop with windows 7 premium and i cannot install sql server management studio express. I have downloaded sp3 and i still reveive an error message that it is not compatible with the os. please help

Installing SQL 2005 in Windows 7 Professional 64-bit



I'm trying to install SQL 2005 Enterprise 32-bit on Windows 7 Professional 64-bit.  I get a message 'This program has known compatibility issues.....you must apply SQL server 2005 SP3 before you run SQL Server...'

Later on (in System Configuration Check), I get 3 warnings:

1- SQL Server Edition Operating System Compatibility (Warning)
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.

2- IIS Feature Requirement (Warning)
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.

3- ASP.Net Version Registration Requirement (Warning)

Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


installing SQL Server 2005 on Windows 7 with Visual Studio 2010 already installed



Last year I had Vista on machine with Visual Studio 2008 and SQL Server 2005 running fine. Last week I decided to wipe the hard disk, install Windows 7 and make the move to Visual Studio 2010. I still need SQL Server 2005 to be able to test code for clients using this.

Anyway, Visual Studio 2010 Professional went on OK. This installed SQL Server 2008 Epxress.

I then try to install SQL Server 2005. I know that there is a compatibility problem, so following advice from other sources, I want to install it without running the server, then install SQL Server 2005 SP3. Then I should be up and running.


The problem is that even though I make sure the 'Start SQL Server' check box is UNchecked, part way through the installation it throws up an error saying it can't start the server and this part of the installation is unrolled.

I've tried running 'setup.exe SKUUPGRAGE=1' which gets rid of the only warning I was getting up to this point, but the setup seems to insist on running the server even though I tell it not to. So I don't get a chance to run SP3 on it.


I wonder if the problem is that SQL Server 2008 Epxress is already installed but can't see an easy way of uninstalling it. It doesn't appear as an uninstall option using the Visual Studio 2010 disk and if I look at uninstall programs I get the f

sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Error 2908 while installing sql server 2005 management objects collection on Win 7

I have SQL Server native client 2005 installed on Win 7 64-bit machine. While installing SQL Server XMO 2005 it gives error 2908 and aborts installation. Any suggestion on the error?

SQl server 2005 install failed on Windows XP pro sp3 due to msxml 6 sp2

Summary log: Microsoft SQL Server 2005 9.00.4035.00 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600) Time            : Tue Aug 24 20:16:01 2010   Machine         : D3F2LN81 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.4035.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_D3F2LN81_SQLSupport_1.log -------------------------------------------------------------------------------- Machine         : D3F2LN81 Product         : Microsoft SQL Server Native Client Product Version : 9.00.4035.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_D3F2LN81_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine         : D3F2LN81 Product&nb

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

Can't install SQL Server 2008 Enterprise on Windows 2008 Enterprise

A new fresh Windows 2008 installed and install all avaliable updates. Then install SQL server 2008, it firstly install some update too. Then reboot and run setup.exe again, it always give me the following message:Managed SQL Server Installer has stopped workingWhat's wrong with it? how to solve this issue?

How should I configure Asp.NET on IIS 6, Sql Server 2005 and SSRS 2005 across 2 Windows Server 2003

I was running a MIS reporting solution on a single server running MS Windows 2003 Server and Sql Server 2005. The solution was built using ASP.NET 2.0 on IIS 6.0, Sql Server DB & SSRS. I now have purchased a 2nd server running MS Windows 2003 Server and Sql Server 2005. What is the best configuration to split the following application components across the 2 physical servers? ASP.NET web application SQL Server 2005 Datawarehouse SSRS Web Applications (Reports & ReportServer) SSRS Databases (ReportServer & ReportServerTempDB) The hardware configuration of the 2 servers are as follows Server 1 MS Windows Server 2003 Enterprise Edition SP2 Intel(R) Xeon(R) CPU 5150 @2.66GHz 16 GB RAM Sql Server 2005 SP3 Standard Edition Smart Array P400 in Slot 1 (SAS Array A with Spare / SAS Array B with Spare) Drive C: 68.33 GB | Drive D: 273.40 GB Server 2 MS Windows Server 2003 Standard Edition SP2 Intel(R) Xeon(R) CPU X5570 @2.93GHz 4 GB RAM Sql Server 2005 SP3 Standard Edition IBM ServeRAID-MR10i SAS/SATA Controller Drive C: 135GB | Drive D: 556 GB | Drive E: 271 GB Any suggestions would be of great help

SQL-Server 2005 x64 / windows server 2003 x64 crashes during file copy

Hi We are running: Microsoft SQL Server 2005 Standard - 9.00.4294.00 (X64) Microsoft Windows Server 2003 R2 Enterprise x64 We have gigabit interface. Today we copied a file (using robocopy) from our databaseserver to another server (backup-server). The copy was started from the backup-server and source were specified using UNC. The copy were using about 20% of the bandwith (about 200Mbit). During the copy, sql-server reported several errors, for example: AppDomain 15 (mp.dbo[runtime].14) is marked for unload due to memory pressure. The client was unable to reuse a session with SPID 75, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. ***Stack Dump being sent to [PATH\SQLDump0005.txt Resource Monitor (0x1384) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 0 KB. Approx CPU Used: kernel 15 ms, user 218 ms, Interval: 428541. So to me it appears that sql-server crashed during a file copy. We have 27 GB ram. With 24.5 GB dedicated to SQL-Server. The files we copied were quite large, some over 50GB. I found a similar issue about this: http://support.microsoft.com/kb/920739/ Do you think the issue above could be the cause of the sql-server crash? ///Patrik

ODBC connection to SQL Server 2005 Standard (on windows xp) with Windows authentication does NOT wor

I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend