Hi! I am new to DNN and I am not a computer wizard. I am want to use DNN to host a website. I can setup DNN to access the SQL db with SQL mixed mode authN but I cannot accomplish a connection using WIA.

I am using DNN 6.1.5 and two 2008r2 servers (IIS 7.5 and SQL 2008r2) .

The IIS server will be placed in DMZ and the backend is the SQL db, which is a different server. Both IIS and SQL are standalone and they are not part of a domain (or authN/authZ by an AD) . IIS is directly connected to the SQL database. All I want is the DNN with WIA to connect to the database. But I am a bit lost.

I do have a .NET 4 apppool for DNN.
The connection string: <add name="SiteSqlServer" connectionString="Server=DBSQL2008R2,1433;Database=DNNbatman;Integrated Security=SSPI" providerName="System.Data.SqlClient" />

I tried following settings in the web.config file:
<identity impersonate="true"/>
<authentication mode="Windows">
</authentication>
and
<identity impersonate="true" userName="DBSQL2008R2\sqlusr_joker" password="TheBatMobil3"/>

The WIA should only be used for a DNN to SQL connection and potential users are just user registered in DNN, not AD users.

I am missing something but I am lacking experience with computers. I read some MS articles about impersonation but this is too much computer wizard magic at the moment. Please point me in a good direction to resolve my issue. Thank you in advance.

Greets,
JP