MS SQL Server 2005 Express Edition installation problem - Help!

During installation, I get a warning message that the hardware doesn't meet minimum requirement. But I'm running it on a laptop with 30 gigs of free space and running Windows XP home edition.

When I click on install anyway, I end up getting an error message that I need a "sqlncli.msi" file that can't be found.

Could it be because I have both 2.0 NET and 3.0 NET installed?

Thanks in advance for your help.

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 (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot 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

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

What Edition of SQL Server 2005 are you attempting to install?

As you can see from the chart at this reference, only Developers' Edition and SQL Server Express will install on XP Home -and only if XP Home is Service Pack 2 (SP2).

|||

Thanks for your reply.

Express, and my laptop already has SP2.

Anything else I should check for?

If not, where exactly do I find "sqlncli.msi" and how do I run that? Would that solve the issue?

Thanks again.

|||

hi,

ExpressionWeb wrote:

Thanks for your reply.

Express, and my laptop already has SP2.

already checked http://msdn2.microsoft.com/en-us/library/ms143506.aspx ?

Anything else I should check for?

If not, where exactly do I find "sqlncli.msi" and how do I run that? Would that solve the issue?

Thanks again.

http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

regards

|||

I tried to download the sqlncli.msi file (second link), but got an error message saying that it can't be read?!?

Not really sure what to look for in the first link. In your opinion, what tends to be the usual culprit? I have a Toshiba Tecra from late 2005 and I'm running IE7.

Thanks. I've been up all night on this and am fried. I'll catch some shut eye and be back. Any additional insights/best guesses/advices would be greatly appreciated.

Thanks

|||

Please 'walk' through this checklist to gather information that may better assist us in helping you.

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

MS Search

We have problem on our 2 original sql instances in a 4-node cluster.
Both the 2 old instances get one warning and one error message in the
event log.
This is the warning message for one of the instances:
****
Source:Microsoft Search
Category:Gatherer
Event ID:3055
Description:
The Gatherer property mapping file cannot be opened. Error: 80070002.
The default values are being used. You may have to copy the property
mapping file from the setup CD, or reinstall the application.
****
Here comes the error message for the same instance:
****
Source:Microsoft Search
Category:Gatherer
Event ID:10006
Description:
An error occured during the online operation for instance <SQL Server
Fulltext (Inst2)>: 80070002 - The system cannot find the file
specified
****
The service Microsoft Search is running, it's the cluster resource
that freak out. Since the full text is not used we removed the
resources from the clustergroups. without them it all works as it
should.
We have 2 new sql instances and they run the SQL Server Fulltext in
the cluster on whatewer node of the 4 witch the group is moved to. The
account used for sql is the same in all 4 instances and it's in the
administators group on all 4 nodes. The same goes fore the account
that runs the cluster.
What I would like to know is what file is the event message pointing
to? We can't se anything odd.
What is the default values?
If I copy it from the install CD, what directory?
If I reinstall, what will I have to reinstall?
In both cases. what about servicepack and hotfixes after?
/Peter
Hello Peter,
Please refer to the following Knowledge Base article concerning this issue:
304282 PRB: Full Text Resource Fails to Come Online on a Cluster with
"Event ID
http://support.microsoft.com/?id=304282
Regards,
Farooq Mahmud [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|||Hi there Farooq!
I have checked out that article already.
Since we have 2 instances that work we compare them with each other.
We found no differenses. That's why I ask the questions about
reinstalling from the CD.
I.E how to do the part I quote, what about the reinstall from CD or
rebuild. Where can I find the steps, and if I take it from the CD what
about SP and hotfixes? I hope you can help me.
"
From Knowledge Base-artikel - 304282
MORE INFORMATION
If the files in the FTDATA folder are replaced, corrupted, or deleted,
or if the FTDATA folder itself is deleted, the SQL Server Fulltext
cluster resource may have to be rebuilt to be restored to a stable
state.
"
/Peter
On Tue, 11 May 2004 13:08:15 GMT, farooqm@.online.microsoft.com (Farooq
Mahmud [MS]) wrotc:

>Hello Peter,
>Please refer to the following Knowledge Base article concerning this issue:
>304282 PRB: Full Text Resource Fails to Come Online on a Cluster with
>"Event ID
>http://support.microsoft.com/?id=304282
>Regards,
>Farooq Mahmud [MS SQL Support]
>This posting is provided "AS IS" with no warranties, and confers no rights.
>Are you secure? For information about the Strategic Technology Protection
>Program and to order your FREE Security Tool Kit, please visit
>http://www.microsoft.com/security.