[RESOLVED] Connect to SQL dbase

[staticbob]

Guys,

I am trying to read from my SQL dbase on my page load event. I am using connection string and code that I have working in a VB.net windows app, but I am getting the following error . .

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

If I do this on my windows app it works fine. Can somebody enlighten me on this please ?

Here is an example of my code . . .

Dim myConnection As New SqlConnection("server=(local);persist security info=False;initial catalog=ProjectWorkbookV3Live;integrated security = sspi")
        Dim myCommand As New SqlDataAdapter("select * from staff where id = '11714'", myConnection)
 
        myCommand.Fill(DataSet11, "staff")

Thanks in advance,
Bob

SORRY - I resolved this myself by adding this to web.config.....

<authentication mode="Windows" />
<identity impersonate="true" />