When I start my browser and try to open my (SQL Server 2000) database, using the 'Integrated Windows Authentication' method, I get the following error msg:
[SqlException: Login failed for user 'MYDOMAIN\ASPNET'.].
Where DOMAIN = MYDOMAIN
and USER = ASPNET
I have made this user known to the SQL Server 2000...
I opened my browser and executed the following function, which is in my default.aspx.vb file:
Public Function checkuser(ByVal userName As String, ByVal password As String) As Boolean
Dim strConnection As String = _
"Data Source=localhost;Initial Catalog=dbo; Integrated Security=True"
Dim sqlconQCards As SqlConnection = New SqlConnection(strConnection)
sqlconQCards.Open()
End Function
Rather than opening the database, the error message, shown above, is displayed.
I'd appreciate any help.
Thanks,
PatDid you add the user in the database itself ?!
Rudy|||Hi Rudy,
I finally got it to work by changing to 'SQL Server Authentication'. It requres that the user/pswd be supplied.
The 'Integrated Windows Authentication', which does not require the user/pswd, is not working for me...This is the Microsoft recommended method...
I am using Microsoft SQL Server 2000...
Thanks,
Pat
No comments:
Post a Comment