I'm doing some work on a VB Web Form and am having trouble connecting to my SQL Server.

In the connection string, I have the following:

Dim connSQL As SqlConnection = New SqlConnection("Data Source=(local);Integrated Security=SSPI;Initial Catalog=AFX")

However, I get an error message saying ... Login failed for user 'BS-LTIBM-02475\ASPNET'

I'm not sure why this doesn't work. In all the VB6 stuff I've done I have no problem connecting to my SQL Server using windows authentication. Also, I'm a bit confused by the error message - my username is not "ASPNET".

Any assistance would be appreciated.

Al