Gusus please see this-SQL Server connection open in ASP.Net

• Jagan Kumar

  SSC Eights!

  Points: 805

  More actions

  January 19, 2004 at 5:56 am

  #65001

  Hi,

  Dim SQLConn As New SqlConnection()

  Dim strSQL As String

  strSQL = "data source=myserver;initial catalog=pubs;user id=user;password=pwd;"

  SQLConn.ConnectionString = strSQL

  SQLConn.Open()

  I am using this Vb.Net code in an Web form to connect to the server.

  But it was showing the error " SQL Server does not exist or access denied. "

  But the same code is working perfectly in the windows form.

  I checked the folder access rights also in the remote server.Everything is ok.

  What will be the problem?

   

  Jag

   

   

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  January 19, 2004 at 3:12 pm

  #490735

  suspect network connection issue.

  Make sure both client and server support the same network protocol.

  In case of IP,

  check if you can ping your server.

  or change server name to ip address and try.