i am trying to deploy ASP.NET CORE API Version 3.1 to local IIS Hostiing but can not connect to SQL Server

Question

I have deployed asp .net core api app on local IIS Manger when i call action that need to retrieve data from sql database does not work,i opned C:\inetpub\logs\LogFiles\W3SVC3 found 404 not found error , i found another error in my log as Login failed for user 'IIS APPPOOL\service' , but when i call another action that returns local data it works fine here is my connection string

"ConnectionStrings": {

    "ERPConnection": "server=.; user Id=ssa;password=12345678;database=dbname;trusted_connection=true;MultipleActiveResultSets=true"
},

and my application pool is not manged code :

score 1 · Answer 1 · answered Jun 17 '20 at 14:56

1

Where is your SQL Server instance hosted? If its localhost try using the full local host domain name.

answered Jun 17 '20 at 14:56

Connor Willoughby

86
1
1
10

i did it but the same issue is still – Ȝlaa A. Saleh Jun 17 '20 at 15:04
Where is your instance? – Connor Willoughby Jun 17 '20 at 15:16
i tried to put logs to know what comes in catch block and i found this Login failed for user 'IIS APPPOOL\service' – Ȝlaa A. Saleh Jun 17 '20 at 15:50

i am trying to deploy ASP.NET CORE API Version 3.1 to local IIS Hostiing but can not connect to SQL Server

1 Answers1