1.JPG

4.JPG

2.JPG

3.JPG

<div>
Very helpful. &nbsp;Thank you!
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a Windows 7 Professional workstation.<br />
<br />
I am running Crystal Reports on it and need to connect to a SQL 2014 database.<br />
<br />
I was able to create an ODBC connection via Data Sources (ODBC) in Control Panel. &nbsp;Connectivity works fine. &nbsp;However I am prompted for credentials. &nbsp;I am able to connect successfully when I enter the database SA password. &nbsp;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).<br />
<br />
I'm hoping I'm explaining this adequately. &nbsp;<br />
<br />
Can you offer advice?<br />
<br />
Thanks in advance.<br />
<br />
Rudy
</div>
</div>


Hello,

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.

Rudy

SQL 2014 connection from an ODBC client | keeps requiring credentials.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.