I Have installed following on win xp Home edition :-

1. SQL 2000 (Client and Connectivity option was allowed), installed this from Win 2003 SBS Server Premium technologies CD.

2. MSDE 2000 provided on VFP 9 CD. Installed with a SAPWD parameter and give password.

Finally using windows authentication i was able to detect the dummy server, SQL server Service is started and using Enterprise Manager i was able to create a dummy database also.

But my all attempts of connecting through VFP were failed, not sure where the things are wrong.

i'm using following lines to do this connection, username and password used are same of the admin user in which i'm logged in my computer and even i created a new user with same name and password and gave access of all the files :-

ConnStr = [Driver={SQL Server};Server=(vinodhome);Database=(vinod);UID=vinod;PWD=mypass;]
Handle = SQLStringConnect( ConnStr )

but it is again n again showing me following :-

Sql server doesnot exist or access is denied.

Pls help.