sql server dns problem

• • Reply

  12 years ago

  by bishnu

  Bishnu Hari Paudel

  Chitwan Nepal, Nepal

  Joined 15 years ago
  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
  Report abuse
• • Reply

  12 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  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 

  Report abuse