[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

Excel 2007- SQL table - How to protect connection details?

Hi Experts,

I've been disrtibuting my reports in MS-Excel (2000/2003) which are refreshed from SQL Server data. For connecting SQL Server a File DSN is used and the password is saved in Connection properties. The login details are not visible to the user.
But, in MS-Excel 2007 user can see the 'Definition', Connection String details and many more...
I want to hide the connection string details from the user, is it possble?

Thanks in advance,
1 Solution
Gary DewrellSenior Network AdministratorCommented:
nbp I do not beleive this is possible. Hopefully someone smarter than me will come along and prove me wrong but I do not believe the functionality exist in excel 2007 to do what you are aksing.

Wish I had a better answer for you.
As I see it you have two options:
1: Set up the users you need at server side. (SQL users or eventually with Active Directory groups) and remove the password from the connection.
2: Remove the connection before distribution. It will require a setup where you will need to distribute the report each time fresh data is available but you can control what you have out there.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now