troubleshooting Question

ASP.net Login failed. The login is from an untrusted domain

Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on
ASP.NETMicrosoft SQL Server
2 Comments2 Solutions14 ViewsLast Modified:
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/

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
Bembi
CEO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros