Murray Brown
asked on
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
The published web page is office2web.azurewebsites.net/contact
The strange thing is that another azure web app of mine works just fine with a database on the server so it must be something to do with the web app. The web app is http://steelyard.azurewebsites.net/
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
The published web page is office2web.azurewebsites.net/contact
The strange thing is that another azure web app of mine works just fine with a database on the server so it must be something to do with the web app. The web app is http://steelyard.azurewebsites.net/
Imports System.Data.SqlClient
Public 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 Sub
End Class
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.