Member Avatar for _tim

Hi All -

Unfortunately I don't have code to paste for you, but I'm hoping perhaps someone will be able to narrow my focus a bit on this one...

I developed a windows forms app that has a very strong data dependency. When deployed, it works as expected if the user has admin rights to the PC. If, however, it's a non-admin user, the connection to the database never happens and the app crashes.

I've tried deploying both through ClickOnce and a true Setup and Deployment project, and both have the same result. This has to be a permission issue - but I'm not sure where (app or PC - or both). That's where I need some assistance.

So - based on this very loose explanation, do any ideas come to mind?

Thanks in advance for your help!
Tim

  • 2 Contributors
  • 5 Replies
  • 72 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

Definitely a permissions issue. When you say data dependency, do you mean database or file based?

Member Avatar for _tim

It's a SQL Server database. Thanks for your help!

Member Avatar for dickersonka

There will most likely be two permissions issues then.
There will be a permission to be allowed to connect to the database. Especially if you use integrated security.
The other will be the permission to use the connector, which most likely is fine if you use the .net one.
Try connecting in sql server management studio with that user and you'll most likely see the same results and appropriate troubleshooting message.

Member Avatar for _tim

Thanks! That gives me plenty to try - and make a ton of sense.

Member Avatar for dickersonka

Interested to know, did you get your connection working?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.