I got the username and password and I can open tables/select records in each database in SSMS.
User is getting an error...
Test connection unsuccessful (4) Unable to query mssql server (check Database Name)
The database name is correct.
The application is McAfee Enterprise Security Manager. The entries are IP Address, Instance Name, User Id, Password, Port, Database Name
One database he can connect to without a problem and he is using the same IP Address, Instance Name, User Id, Password, & Port
Thank you for your help