I have a couple WindowsServer08 R2 (both running same IIS/SQL versions) within my VPN. I'm looking for a connection string that will access the db on the other machine. I have the connection working via MSSMS but not via IIS.
I'm editing my web.config's db connection property to point at the remote sql server expecting that if i use the same 'computerName' property that I see from MSSMS my web app should gain access.
Here's the connectionString's properties - should I be including other properties to ensure I connect the same way MSSMS is connecting?
<add name="dbConnection" connectionString="
Persist Security Info=True;