Thanks Al

I have this part working now.


>>Hi All
>>
>>I have just installed the developer version of msSql2008R2. I can't seem to get VS2010 to connect using asp.net. I can add a connection using the server explorer. It seems that the problem is with the web.config connection string but I can't seem to get it working. This is what worked using sqlexpress.
>>
>>

>>    <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" 
>>         providerName="System.Data.SqlClient" />
>>  </connectionStrings>
>>

>>
>>This is the closest I have come to making it work with sqlserver except it won't recognize the trusted user.
>>
>>

>>    <add name="ApplicationServices"
>>         connectionString="data source=JIM3\MSSQL2008R2;Database=aspnetdb.mdf; Trusted_Connection=True"
>>        providerName="System.Data.SqlClient" />
>>

>
>http://connectionstrings.com/sql-server-2008