Assuming you've installed SQL Server with the default settings, it should work like this: Data Source=(local);Initial Catalog=dnntest;Integrated Security=true;

Joe,

In addition to Brian's reply: the account that runs the application pool needs db_owner permission for the database (at least for installing DNN and extensions). Assuming your web server is called DNN-WEB and the application pool is called DnnAppPool, you have the following (Windows/integrated) logins to be created on SQL Server and assigned this role:

1. If IIS and SQL Server run on the same machine: IIS AppPool\DnnAppPool
2. If they run on different machines within the same domain: DNN-WEB$

If they run on different machines which are not in a domain or not in the same domain, you have to create an SQL Server login and assign the db_owner role to the database. In this case, the connection string would look like

Data Source=[DNNDatabaseSQLServerName];Initial Catalog=[DNNDatabaseName];User ID=[SQLServerLoginName];Password=[SQLServerLoginPassword]

It is not recommended to use the db_owner role in normal operation. Let me write a blog about this in the next days...

If you just want a test installation on a local machine, I recommend nvQuickSite for installing DNN. This saves a lot of headache.

Happy DNNing!
Michael

IIS and DB are on the same local machine. Here is my connection string in web.config.

add name="SiteSqlServer" connectionString="Data Source=(local);Initial Catalog=dnntest;Integrated Security=true;" providerName="System.Data.SqlClient"

and I get this - IIS Apppool\dnn is db owner for dnntest.

DNN Error

---

Connection To The Database Failed

Can you connect to the database using SQL Server Management Studio and using those EXACT credentials?

Is SQL Server set up for mixed mode authentication?

I ended up creating a SQL Server user and added it to web,config. Made this SQL server user owner of dnntest database and then I was able to install. Adding IIS APPPOOL\DNN application pool to SQL Server didn't resolve the issue. IIS APPPOOL\DNN couldn't access the database.

This connection string worked for me

add name="SiteSqlServer" connectionString="Data Source=(local);Initial Catalog=dnntest;User ID=sqluser;Password=sqluserpassword" providerName="System.Data.SqlClient"

Thanks eveyone for your time and help.

Your IIS AppPool identity user needs to have access to the database as a dbowner and also full privileges to the website directory. Without these two prerequistes, you are likely to have trouble.

Michael's suggestion to use nvQuickSite to do your local DNN installs is a good one. That way all of the connections between IIS, the database, and the website directory will be done correctly with no intervention required on your part.

Here is the promised blog article...

Happy DNNing!
Michael