I'm not sure on that one but I had to replace (local) with localhost in order to have my connections working.


>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