hi all, I have installed sql server 2000 personal on a pc running Windows XP service pack 2. I have set authentication to sql server and windows. When I created a system dsn on the same machine it's working fine. But when I try to create a dsn from another machine on the same network, its giving error like "connection faile , error 10061, sql server does not exit or access denied." I have truned off firewall on the server machine. How can I get rid of this prbolem? Please help me Thank you

Have you given access to your machine to the person / entity trying to connect to the sql server instance on your loacl machine?

I've generally found these issues to be wrapped around "security" on the local machine.

Joe