Share via

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

Anonymous
2019-04-16T21:14:07+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2019-04-17T04:32:29+00:00

    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

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-04-17T03:01:12+00:00

    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

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-04-17T01:36:33+00:00

    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

    Was this answer helpful?

    0 comments No comments