help fro access sql server2000 in LAN NETWORK USING asp.net

• pooja-254191

  Grasshopper

  Points: 19

  More actions

  August 22, 2005 at 12:57 am

  #68247

  sir 

  i need help to access  sqlserver in network using asp.net with vb.net.

  actually when i m accessing sql server2000 from local machine then it working .but when i m acessing it frim server machine (which has sqlserver )then  it giving error message in asp.net is that " SQL Server does not exist or access denied."

  please help me what should i do to make my sql server data to centralised data sothat i can access in asp.net with vb.net  

• Jo Pattyn

  SSC-Dedicated

  Points: 32430

  More actions

  August 25, 2005 at 10:44 am

  #585092

  How is the authentication to sql server set up?

  Windows authentication or sql authentication.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738160

  More actions

  August 25, 2005 at 11:35 am

  #585103

  What is your connection string? How is it different than local access? Perhaps an incorrect protocol?

• yogiberr

  Hall of Fame

  Points: 3679

  More actions

  August 29, 2005 at 8:34 am

  #585858

  hiya,

  have a look at the sqlServer conn strings here.Maybe there is one for you:

  http://www.connectionstrings.com/