Error in remotely access sql server 2000

• mahakaalrudra

  Newbie

  Points: 1

  More actions

  April 25, 2008 at 10:34 pm

  #189817

  Dear Forum Member,

  I've a problem to access sql server remotely from my program it give an error "Server does not exist or access denied". I've a program that remotely access the data from server when I tried to connect the server through client machine it give the above error. I've tried my level best but I can't configure the sql server for remotely access. Please help me to out this problem. Any body give me the configuration for sql server 2000 that I remotely access the server.

  Please Reply ASAP.

  Thanks & Regards,

  Mahakaal Rudra,

  India

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  April 25, 2008 at 10:51 pm

  #807484

  [font="Courier New"]Hi,

  Welcome to sqlservercentral 🙂

  Make sure SQLserver port is unblocked in firewall

  Make sure to create correct alias in the client machine

  If possible try connecting as SERVERNAME,Portno Eg.)mymachine,1433

  If you are using ODBC connection inside the app connection, test the odbc connection string

  Try connecting the same using sql client tools[/font]

  Regards..Vidhya Sagar
  SQL-Articles