I'm newbie in IIS and MSSQL using php. I got problem connecting to my host and selecting database. Could you please help me how to connect using php.
I got problem when mssql_select_db is executed, i can't select db.
Here is what it prompt me...
MSSQL error: The server principal "NT AUTHORITY\IUSR" is not able to access the database "mrbiweb" under the current security context.
Where should i look for this? Thanks
I fix it by doing this steps
1. Open SQL Server Management Studio.
2. On the left menu, expand Security then Logins. Check if 'NT AUTHORITY\IUSR' exists. If not then that is the cause of the problem.
3. Right-click on Logins then click New Login...
4. On the General page, click Search...
5. On the next popup window, click Advanced...
6. Then on the following window, click Find Now and find IUSR on the Search Results. Then click OK.