Question

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.

https://prnt.sc/ydul7n

How can I modify connectionsting to use another dabase user?

 

 

Like 0

Like

2 comments

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.

Ryan

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