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
Al Williams
Anola MB, CANADA