Wednesday, March 28, 2012

Having Problem With installation

Hi:
I have already installed QSL 2005 on a win 2003 machine. The installation was without erroe or something but when I open services I do not see any sql in there and when I open the management interface there is no machine detected there. Would you please help me to run this software. When in the management tool I try to connect to the server this is the error I get:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

and when I try to surface area configuration this is my error message:

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

Thanks

Go to Add/Remove Programs from the Control Pannel. You should find an entry for "Microsoft SQL Server 2005" select it and click "Change" Once the dialog comes up you should see a "Report" button, click it. This will show you all of the SQL Server 2005 features installed. Copy and Paste this back to this thread.|||

===================================

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
=================================

and my SQL SErver says no instance has been found or installed on ur PC... i tried installing and uninstalling this atleast 4 times...i need help... i am encountering the same problem on another machine tooo...plzzz help me out

The configuration of two machines on which SQL servers produce this ERROR are

p4 2.4 Ghz, 512 MB ram, 845 intel original motherboard ,52 x cd R/W 80 gb HDD

AMD Athlon 64 Bit 3000 +, 512 MB ram, Asus motherboard ,52 x cd R/W 80 gb HDD

Operating System installed on two machines are ~~~> Windows XP 2002 Service pack 2

REport File is as follows

System Configuration Check

- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed

- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed

- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed

- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed

- 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.

- Minimum Hardware Requirement (Warning)
Messages
* Minimum Hardware Requirement
* The current system does not meet the minimum hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- IIS Feature Requirement (Success)
Messages
* IIS Feature Requirement
* Check Passed

- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed

- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed

- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed

- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed

- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed

- ASP.Net Version Registration Requirement (Success)
Messages
* ASP.Net Version Registration Requirement
* Check Passed

- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed

|||For the error msg you're getting it sounds like you're attempting to install the Enterprise Edition on Windows XP SP2. Enterprise Edition is not supported on Windows XP - only Windows 2000 Server and Windows 2003 Server.|||

Hi Bobby62,

Your error "No SQL Server 2005 components were found on the specified computer" can be caused if you installed SQL Server 2005 using Disc 2 of 2. I actually did this myself accidentally. I didn't realize there were two "Premium Technologies" CD's (those shiny discs are hard to read)! So I had accidentally done the installation from disc 2. The setup process appeared legit, when in fact it only installed the client apps.

In short, make sure you're installing SQL 2005 from disc 1 of 2.

Regards,

Doug

No comments:

Post a Comment