As I know that, we can set up user login & password for the Database connection string. Under the ODBC microsoft access setup interface, after hitting the "Advanced" Button, we can insert login name & password. At the same time, we have to apply the same login name (characters) & password(numbers) under the Database connection string (Data source name)

However it comes up with an error message "Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WebServerName\IUSR_computername'.

Even though I removed the database connection string and try to add a new one without using the login name and password. The above error message still exists. Is there any thing wrong with the procedures, please advice.

Thank you