If your SQL Server is configured for Mixed Authentication, you may either create a dedicated SQL Server account and provide username and password in connection string or use same windows account, your website resides in:

- Check Advanced Settings of the IIS application, your IIS Website resides in (see Basic Settings of your IIS Website).
- You will find "ASP.Net Identity" setting, which needs Modify permission for the IIS website folder as well as a permission for the database.
- If ASP.Net Identity uses a machine account (usually "Network Service"), you may create a SQL Server account for "NT AUTHORITY\NETWORK SERVICE"
- If ASP.Net Identity uses "App Pool Identity", you need to create a SQL Server account per Application pool, called "IIS APPOOL\DNN" (if DNN is the name of your IIS App Pool).
- Right Click sql server login in the tree on the left of your SQL Server Management Studio and select Properties (or double click the item).
- on top left, select "user mapping" and check "Map" for your database, enter "dbo" as default schema and grant "DB Owner" role beneath.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

you should be able restore the database and get DNN working. You need to use same or newer version of SQL Server.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN