Office Excel 365 Get Data from SQL Server using UID/Password

Question

Office Excel 365

When importing data from SQL Server via

Data -> Get Data -> From Database -> SQL Server

It assumes I am the admin of the machine and thus I can see all databases and tables/views.

Is it possible to use a UserID/Password instead of the trusted admin connection? I can't find where to change this.  I have seen a connection box that has tabs on the left for trusted vs user name/pw but can't seem to find it on the new version.

Thanks in Advance

Stewart

Answer 1

Hi Stewart,

Thanks for posting back.

Sorry for the inconvenience the issue causes and I know that you are not take about VBA, but the question is related SQL Sever and the TechNet forum is a specific channel to solved. Also maybe this thread in the TechNet forum may given your few a information: Log in to SQL server using UserId and Password. In addition, in this article Excel sheet prompting for SQL Login Credentials a customer share a way to sign with userID and password to connect with SQL Sever

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​

Appreciate your understanding.

Best regards,

Clark

Answer 2

Clark,

I am asking about how Excel works when connecting in Excel to SQL. Form the menu system in Excel. Not VBA. Thus it is not a TechNet question.

Respectfully,

Stewart

Answer 3

Hi DataSort Software,

Welcome to Microsoft Community and thank you for posting your query.

Based on your description, as your query is related to SQL Server, we would like to suggest you post your description in the TechNet forums  where it is a specific channel to get a dedicated help for queries related to your description.

Appreciate your understanding.

Thanks,

Clark