Hi, I have a aspx page that I designed in web matrix and it works fine. however when i try to put it in visual studio I get the following error Login failed for user 'HOME\ASPNET' . While I don't know what that means it sort of looks like it is looking for a database called aspnet. The code for the connection goes as follows and calls the error at objadapter
  Dim objConn As New SqlConnection("server = '(local)';trusted_connection = true; database = 'tryagain'")
        Dim objAdapter As New SqlDataAdapter("SELECT [tblslots].* FROM [tblslots]", objConn)
        Dim Ds As DataSet = New DataSet()
        Dim objTable As DataTable
        Dim dv As DataView
        dim DRow
        objadapter.fill(ds,"tblslots")
Any help would be greatly appreaciated

Hello,

ASP.NET uses an ASPNET account to run under. This is the very problem you are having. What you can do is add the HOME\ASPNET user to your database and give it permissions, or set up impersonation in your account.

Brian

Further to Brians reply, I had a similar problem see:
Edward Stephen 1 22 06/29/2004 9:49:07 PM on Page two of the Topics list for the outcome.

Edward.

when i added this account i also had to grant permissions. I just granted them all and it worked. Took me three days to figure this out.