Fresh install in SQL Server, IIS, php, windows 10 - Db connection problem

SuiteCRM Forum - English Language Installation & Upgrade Help
1

I cannot connect to MS SQL Server on my laptop. and I got these error.

  • The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password

Current setup
windows 10
SuiteCRM-7.10.29
PHP php-7.3.27- thread safe
IIS 10
Microsoft sql server express 2019.

i have the php driver install and configured in php.ini.

right now i just trying to connect to my local sqlserver db but unable to establish connection.

I guess the problem is with the connection to the SQL Server database. but I’m not sure what to put as my database user. Or I need to create a new user? and if so how do I do it?

Screenshot (69)
Screenshot (69)1831×1027 66.3 KB

Screenshot (70)

Any guide or help with this is appreciated.

2

Finally managed to solve this problem. Seems like i need to create a database user in sql server and then restart the sql server for the user to work.