Share via

Excel 2010 SQL Server Connection

Anonymous
2013-11-13T03:25:47+00:00

Hi All,

I have created a report using Microsoft query in excel.

This report will be use by a few user and it pull out data from the database store in our sevrer.

Noticed when the report is refresh, excel will prompt for the SQL server login.

Is there anyway that we can save the login detail as we will not want to provide the sevrer login to the users.

Thanks.

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

1 answer

Sort by: Most helpful
  1. Anonymous
    2013-11-13T16:58:08+00:00

    Hello Mavis

    For issues related to SQL server, you may post your question in the SQL forum link below:

    http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/

    For any other Office related queries, you may always post here and we are happy to assist.

    Thank you.

    Was this answer helpful?

    0 comments No comments