Community discussion forum

sql server dns problem

• • Reply

  7 months ago

  by bishnu

  Bishnu Hari Paudel

  Chitwan Nepal, Nepal

  Joined 3 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
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  6 months ago

  by joe90

  J Alan

  , United Kingdom

  Joined 3 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