Hello
I don't know the specific error message from the application - I was going back and forth in e-mail with the end user and he only said that the login created only worked on database1, but not database2, database3, etc
I checked the log and didn't see anything out of the ordinary.
Login uses SQL server Authentication.
Database Role membership: db_datareader (on all databases involved)
Server Role: public
I haven't heard back from the end-user. I was going to get the user and password and log into SSMS to see if I can then question the application.
Thanks
Dave