MATLAB Answers

Database Explorer App Username/Password

2 views (last 30 days)
Ricardo Rodriguez
Ricardo Rodriguez on 3 Feb 2021
Answered: Kojiro Saito on 29 Mar 2021
Hello:
I am trying to connect to an MS SQL ODBC database. I already have the data source configured (can open in Access and Excel) and am trying to create connection in Matlab. Everytime I try to make connection I am prompted for a username and password. To make connections in Excel, for example, I use are my normal Windows authentication credentials. I have tried these in the Matlab prompt to no avail.
Has anyone had issues with this and found the credentials were something different? I run into this issue for databases both stored locally on my computer and on servers.
Thanks in advance.

Answers (1)

Kojiro Saito
Kojiro Saito on 29 Mar 2021
In your ODBC Data Source Adminstrator, did you select "With an Integrated Windows authentication"?

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!