With local user i can connect, but i don't know, how to add domain user format, or what can i to work this.
When i add domain user whit this format:
i get this error message:
Error Code: 18456
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'exampledomain\mdleapp-01-svc'.
Thanks your reply. Yes, I tried whith this, and from SSMS it works, but in Moodle install gui, it doesn't work. Any idea?
Hi, any idea?
Someone can connect to database with domain user?
Not worked. I tried this version:
The result: "
Error: Database connection failed
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php
Is anybody, who has working exmaple for domain user, or everybody user SQL local user?
guessing no one is using the Windows Authentication on MSSQL.
If you want to give it a try, please run your IIS site under the user able to login to MSSQL and do not specify anything as credentials: if both the servers hosting IIS and MSSQL are under the same domain, it should work.
Otherwise, enable the SQL Authentication on your MSSQL, create a SQL Account and use that account for explicitly connecting the Moodle instance to its Database.
Thanks for your response! The following solution worked! :
On Moodle's config file comment out dbuser and dbpass parameters with // char. And on IIS, set in the Sites / Auth module enable anonymous authentication with a specific user, where i set the domain/user.