ASP.net Login failed. The login is from an untrusted domain
Hi
I am using the code below to load a GridView. My SQL database is on a server in South Africa and the web app is in Azure. I get the following error Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. dr2
Imports System.Data.SqlClientPublic Class Contact Inherits Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load If Not IsPostBack Then Call Bind_Grid_to_Dataview(Me.GridView1, "Select * From Customers") End If End Sub Sub Bind_Grid_to_Dataview(ByVal oGridView As GridView, ByVal oSQL As String) Try Dim cs As String = ConfigurationManager.ConnectionStrings("PSQL").ConnectionString Dim objCon As New SqlConnection 'Declaring connection object objCon.ConnectionString = cs 'opening connection If objCon.State = ConnectionState.Closed Then objCon.Open() End If 'declaring new Data Adapter Dim objDA As New SqlDataAdapter objDA.SelectCommand = New SqlCommand(oSQL, objCon) Dim objDS As New DataSet objDA.Fill(objDS) 'Call oCheck_DataSet_For_Blank_Columns(objDS) 'Below i am creating a default view of the Data Set Dim objDV As DataView = objDS.Tables(0).DefaultView Session("objDV") = objDV oGridView.DataSource = objDV oGridView.DataBind() Catch ex As Exception Response.Write(ex.Message & " dr2") End Try End SubEnd Class