Hi,  My client wants to use a domain account in the connection string to the SQL Server database (i.e. create a login on the SQL Server using Windows authentication - and use this login to access the database used by the website).

So I tried this on localhost - creating an login for local machine user Al-Laptop-2008\Al in Security/Logins.

I then added a new user named al to the DNN database which is tied to thge server login Al-Laptop-2008\Al - and added him to the db_owner role.

In the connection string, I am using al as the user id, and the password for this local machine account as the password - but I am not able to connect to the database used by the DNN site.

Here is the connection string I'm using.

. <add name="SiteSqlServer" connectionString="Data Source=AL-LAPTOP-2008\SQLEXPRESS;Initial Catalog=blahblah;User ID=al;Password=mypassword" providerName="System.Data.SqlClient" />
 

What am I missing?

Thanks for the feedback.

Not being too proficient in IIS - what is the procedure to "set the username and password as the identity of the application pool"? 

Thanks in advance.

Thanks guys - it works like a charm !

Al