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
2 comments
17:35 Feb 05, 2021
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
09:58 Feb 09, 2021
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