Here is the connection string I have in one of my test:

data source=EMOREAU2800;initial catalog=Northwind;integrated security=SSPI;persist security info=True;workstation id=EMOREAU2800;packet size=4096

>I get the exact same results using (local) and localhost.
>
>>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