DNN8 and SQL Server 2014 connection issue

Question

I have SQL Server 2014 installed as a default instance MSSQLSERVER. My computer's name is DHAVAL-PC.

So I used to connect SQL Server database engine with DHAVAL-PC.

Coming to DNN 8 Installation, I used to type my server name as DHAVAL-PC and the empty database that I have created. But I am getting the following error:

Even I tried with MSSQLSERVER, DHAVAL-PC/MSSQLSERVER, ./MSSQLSERVER, .. None of the server names worked.

Answer 1

What identity is your site running under? Assuming you are using IIS look at the identity field of your application pool. If it is an application pool identity make sure you have granted owner permission on the database to that application pool.

To do that, add IIS APPPOOL\<application_pool_name> as a user/logon in sql server

Answer 2

My best guess is that DNN 8 service is not running with your identity (account). This identity can not login to the database server.

So figure out under which identity does this process/service run and then add this service account to the database, configure access rights too.

... or just create an SQL server account, with username/password and then set security to "User defined".