We have a problem with some bespoke software that I cannot get to the bottom of.
Said software is for a production environment. When a user loads up a sales order to print and initiates the print process they get the error message: "Cannot open SQL server".
When I try logged in as Administrator it works.
Speaking with the author of the software, he suggests that it's because non-administrator users don't have permission to access ODBC (although they can read/write to the SQL database - so I'm not so sure about that).
The users are all members of a domain on Server 2008.
Any ideas what I should be checking to give all users access to ODBC? Could it be anything to do with ports?
Due to a situation the author won't come into the factory to assist and the IT support person is on holiday. I've been drafted in to assist.