Sunday, February 12, 2012

cannot connect to database

i keep getting this error can anyone help me??

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