when i run my .NET web application i'm getting this error ::
"Login failed for user sa"
can anyone help me

can you provide more details...are you using any database??

Do not use the SA account - This is a very bad idea.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

my code is as follows ::

Public Function exists(ByVal username As String, ByVal pwd As String)


        Dim con1 As New SqlConnection(" server=(local);uid=sa;pwd=;database=usersdb;")
        Dim myreader1 As SqlDataReader
        Dim eid
        Dim cnt, count As Integer
        Dim ex As Boolean
    

        Try
        con1.Open()
        Dim sqlcommand1 As SqlCommand
        sqlcommand1 = New SqlCommand("select eid,cnt as count(*) from userdetails where usrname = '" & username & "' and pwd=' " & pwd & "' ", con1)
        myreader1 = sqlcommand1.ExecuteReader()
        Do While (myreader1.Read())
            eid = myreader1("eid").ToString()
            ex = True
        Loop

        Finally

        If Not (myreader1 Is Nothing) Then
            ex = False
            myreader1.Close()
            con1.Close()
        End If

        End Try

             If ex Then
            Label2.Text = "user Exists"
        Else
            Label2.Text = "User does not exists"

        End If
    End Function

can u try giving ur sql servername insetd of (local).

again as Hal said, it is a very bad idea to use sa account ant that too without a password.

Your query also seems to be incorrect, You have a summary field and another field, but the sql statement does not contain a group by clause.

"cnt as count(*) " this doesnt make sence either

Regards
Ganesh

cross-post, see http://p2p.wrox.com/topic.asp?TOPIC_ID=19892