Cannot open database requested in login 'Match1'. Login fails. Login failed for user 'DURON\ASPNET'.
i used WINT Integrated security
code as following
Dim MySQL As String = "Insert into UserData ([UserName],[Password]) values (@.user, @.pass)"
Dim myConn As SqlConnection = New SqlConnection("data source=DURON\NETSDK;initial catalog=Match1;integrated security=SSPI;workstation id=DURON;packet size=4096")
Dim Cmd As New SqlCommand(MySQL, myConn)
Cmd.Parameters.Add(New SqlParameter("@.user", tbUser.Text))
Cmd.Parameters.Add(New SqlParameter("@.pass", tbPass1.Text))
myConn.Open()
Cmd.ExecuteNonQuery()You need to make DURON\ASPNET a user in SQL Server. Do you have Enterprise Manager?|||I do. I also have this problem.
settings:
winXP
iis5.1
sql2000 eval
mixed mode
No comments:
Post a Comment