I have a Windows 7 Professional workstation.
I am running Crystal Reports on it and need to connect to a SQL 2014 database.
I was able to create an ODBC connection via Data Sources (ODBC) in Control Panel. Connectivity works fine. However I am prompted for credentials. I am able to connect successfully when I enter the database SA password. However, I would like the connection to take place either saving the SA password so it does not have to be entered; or using an Active Directory user account (which is okay for user to have to enter).
I'm hoping I'm explaining this adequately.
Can you offer advice?
Thanks in advance.