homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

Windows 2008

10+ Year Member

Msg#: 4334969 posted 5:17 am on Jul 5, 2011 (gmt 0)


We have a problem with some bespoke software that I cannot get to the bottom of.

Said software is for a production environment. When a user loads up a sales order to print and initiates the print process they get the error message: "Cannot open SQL server".

When I try logged in as Administrator it works.

Speaking with the author of the software, he suggests that it's because non-administrator users don't have permission to access ODBC (although they can read/write to the SQL database - so I'm not so sure about that).

The users are all members of a domain on Server 2008.

Any ideas what I should be checking to give all users access to ODBC? Could it be anything to do with ports?

Due to a situation the author won't come into the factory to assist and the IT support person is on holiday. I've been drafted in to assist.





WebmasterWorld Senior Member 5+ Year Member

Msg#: 4334969 posted 1:02 am on Jul 6, 2011 (gmt 0)

I have had to do this before as well.
This is what I did.
I installed a msi creator software (can't remember name, sorry) and then installed the user end software as an administrator.
Then I looked at the logs created by the msi creator software that just watched my entire computer, making note of every new file added or registry added, and compliling a list of files and registry keys that were changed or added.
Then I manually set the permissions on those keys and files (a lot of them were in c:\windows\system32\) to the user persmissions. As a software support tech, most companies will say its not supported, but as an admin, we have to find work arounds.


5+ Year Member

Msg#: 4334969 posted 11:25 pm on Jul 12, 2011 (gmt 0)

Might be totally wrong here, but is said software digitally signed? I know the registry is out-of-bounds for non-signed software unless authorised - might not allow access to ODBC either? Just a thought.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved