installtion program dies when installing Native Client

it's my laptop, i try to install sql server 2005. the installation program dies at the first stage.
the program seem cant finish the Native Client installation and stops for ever. theres no error msg.
the installation program works well on my desktop. does anyone knows what goes wrong?
Did you install any SQL Beta on the machine ? Then you will first have to deinstall and run the cleanup utility on your laptop. If not, try to install the SNAC client from a standalone installer.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Can you check C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txt

and post the error message

Also go inside the subfolder files and look for _snac.log

Thanks

Vishal

|||i reboot the system for a few times, and for the last time, the system did a hard disk error check. then the installation program goes on well.||| next time if you have this kind of a issue please refer setup bootstrap|||

thanks a lot of all ur helpssql

integer count

Im not at all familiar with sql programming text but i need to do something I cant find an example of. Im using the sql query inside of an access 2003 database. Basicall I have two tables. One that hold all the employees personal informaton AS WELL AS Total Days Worked AND TotalPoints.

A day worked is represented by a "w" form within my vb program.
I used to sql code:
SELECT COUNT(*) AS TotalDW
FROM TblEmpAttendance
WHERE Value="w" And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;

To get the "w" total or count in this case.

--This seems to work without a problem please let me know if you see a problem with it.

--Now on to my bigger problem.

The second table has 3 fields-- EmployeeID, Date,Value
The date comes from my vb program(a calendar with textfields to hold values)

However-- to limit the code I use in my vb program I wanted to take a point total for all points from the 2nd tbl

In vb I can use --IF Isnumeric --But I have no clue how to do it woth SQL code!!

A Point Value can only be 1 of 4 values(a 1,2,3 or a 7)

But how do I rewrite the below code(if below code is even close!) to count all of the numeric values for the field "Value" when not every entry for "Value is a numeric entry?

SELECT COUNT(*) AS TotalPoints
FROM TblEmpAttendance
WHERE Value= '1 or 2 or 3 or 7' And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;

Hopefully I explained sufficiently..Thanks In advance!Did you try:

SELECT COUNT(*) AS TotalPoints
FROM TblEmpAttendance
WHERE Value IN ('1', '2', '3', '7')
And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;
;)|||Nope but I will now..Thanks Much! it is highly appreciated..Just tried it...I only have 4 sample employees to check it with but it seems to work...
Many thanks!!!

Installing SQL Server 2005 - Vista help..

Ok ive tried looking everywhere for a solution but i just cant find one... please help me

I need to install SQL Server 2005 (for reporting services mainly) on Vista, but i have issues.

I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected.

The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..."

Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point.

A walkthrough or something would really help...

Thanks!

Robert Macnair

Try the suggestions from this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1301511&SiteID=1

Installing SQL Server 2005 - Vista help..

Ok ive tried looking everywhere for a solution but i just cant find one... please help me

I need to install SQL Server 2005 (for reporting services mainly) on Vista, but i have issues.

I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected.

The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..."

Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point.

A walkthrough or something would really help...

Thanks!

Robert Macnair

Try the suggestions from this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1301511&SiteID=1

Installing SQL Server 2005

Hello.
I have a DC with a member server. I attempted installation and repeatedly
receive the warning regarding admin user rights. Since I can't get past
this, I can't install. I tried everything under the sun: create a new
admin, use current admin, log onto the member server locally, sign onto the
DC. Nothing works.
How can I do an installation? My only other thought was to begin the
install on the DC and point it to the C: drive of the member server.
Any thoughts.
Hi Zig
Do you have any policy's running on the member server, have a look if the
user your trying to install with have the necessary permissions in the local
system policys.
Regards
Charl
http://www.sqlserver.co.za
"Zig" wrote:

> Hello.
> I have a DC with a member server. I attempted installation and repeatedly
> receive the warning regarding admin user rights. Since I can't get past
> this, I can't install. I tried everything under the sun: create a new
> admin, use current admin, log onto the member server locally, sign onto the
> DC. Nothing works.
> How can I do an installation? My only other thought was to begin the
> install on the DC and point it to the C: drive of the member server.
> Any thoughts.