I Have an Excel Sheet where i had created an pivot table which is taking data from Sql Table.I am downloading that Excel sheet from an Application to Client machine and when we try to open it in clint machine, it is asking for the SQl Server Login Credentials. Is there any way so that after downloading to client machine the sheet will not prompt for SQL Login Credentials and we will hardcode or Set in Excel itself. The User just open or download and as he open the pivot the Datasourse will not prompt for SQl Login and Refresh the Datasource automatically.
So if you open a spreadsheet that you know doesn't have a password, yet you get a screen like this, it means that Excel is trying to link to and get information out of a spreadsheet that is password protected. If it is purposeful then you need to get the password and work with it.
1. To avoid connection through Excel/ODBC, the way is to disable or not create the logins for the users that attempt to connect SQL Server through Excel/ODBC. Then, create the special logins for the users that connect SQL Server from the Access Front-end, the web application and Reporting Services respectively.
To save the SQL Server password for a Microsoft Query database connection, right click anywhere in the Excel table and select Table > External Data Properties. Click the Connection Properties icon, Definition and check Save Password.
To connect Excel to a database in SQL Database, open Excel and then create a new workbook or open an existing Excel workbook. In the menu bar at the top of the page, select the Data tab, select Get Data, select From Azure, and then select From Azure SQL Database.
I have solved it using the following the steps.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With