On-premise database. Login failed for user

Stack trace:

[SqlException (0x80131904): Login failed for user 'DEV\SRV-DEMO03$'.]


Connection string:

  <add name="db" connectionString="Data Source=SRV-DB01\MISC02;Initial Catalog=demo03_Creatio_717;Persist Security Info=True;Integrated Security=SSPI;MultipleActiveResultSets=True;Pooling=true;Max Pool Size=100; Async = true" />


I checked my connectionStings.config and web.config -files and I cant find the DEV\SRV-demo03$ user anywhere.

I have created a user in the database in SQL Server Manager. But I don’t think it’s used in the setup at the moment.

How can I modify connectionsting to use another dabase user?



Like 0



Hi Julius,

If you're wanting to specify a user in the connection string, remove:

Integrated Security=SSPI

and replace with:

User ID=username; Password=password

The current user context for DEV\SRC-DEMO03$ would be coming from the IIS app pool context.


Hi Julius,


Please check if you have the correct user login and password specified in IIS > Application pool > Advanced settings > Identity.


Best regards,

Bogdan S.

Show all comments