+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, CMIS won't run as user account, runs fine under Admin account in Technical; Over the summer, we have rebuilt the network at a partner school. They use CMIS Facility. Since the rebuild we ...
  1. #1

    Join Date
    Dec 2007
    Location
    Derbyshire. Ish.
    Posts
    264
    Thank Post
    29
    Thanked 22 Times in 15 Posts
    Rep Power
    24

    CMIS won't run as user account, runs fine under Admin account

    Over the summer, we have rebuilt the network at a partner school. They use CMIS Facility.

    Since the rebuild we have noticed users are struggling to run CMIS Facility in the context of their own user accounts. If I log on to a PC as the domain administrator and start Facility, the application starts fine and I can use it. If the user logged on to the PC as themselves, despite having the same mapped drive letter to the Facility share on the server, and the same permissions on that share as the administrator (I was testing, I know this is not a good idea long-term), the application struggles to start - often flashing up an ODBC connection timeout error message. They can click through this and the application starts, but they can't do simple stuff like backup the database. The backup operation fails with an "unspecified error".

    I know this will be related to permissions but I am at a loss to explain where. File and share permissions are - as best I can see - correct (aside from when I slackened them off to eliminate them), the SQL setup is - as best I can see - correct, but still a normal PC user can not seem to run this application correctly.

    Any thoughts? We installed MS SQL 2008 R2 Express Edition to run Facility in as it's a small school and only one or two staff ever need access - but I've done this before without issue even though I'm aware other schools use full-fat SQL Server. The choice of SQL Express edition was a cost-saving measure for this small school.

    We used to be a Facility school ourselves before moving to SIMS, but this was four years ago and I've all but forgotten the caveats needed to get Facility to do what you want it to so I've probably missed something blindingly obvious - hoping someone can point me in the direction of just what

    Thanks in advance!

  2. #2

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    627
    Thank Post
    96
    Thanked 131 Times in 102 Posts
    Rep Power
    67
    Doesn't sound like you're really missing anything. Ensure that the db ports are open in the firewall, that's the most common issue, but if it's connecting at all you'd assume they're correct. Is it just Facility? Or are you only noticing with Facility due to the amount of network throughput? Could it be something like flakey NIC drivers? Try an open ping to the server, or copying a few huge files from / to it as a test to rule out the app / db.

    Keep us posted.

  3. Thanks to michael2k6 from:

    TheCrust (15th September 2013)

  4. #3

    Join Date
    Dec 2007
    Location
    Derbyshire. Ish.
    Posts
    264
    Thank Post
    29
    Thanked 22 Times in 15 Posts
    Rep Power
    24
    I'm not on here that often and I've been that busy I completely forgot I posted this thread up, but thanks for the thoughts - all appreciated.

    I have resolved this issue now. In our case it turned out that the configuration of the DSN on the client was at fault.

    Even though it would work configured to connect over TCP/IP for administrative users, it really wasn't happy connecting that way as a normal user. I discovered that the work-around is to regenerate the DSN but configure it to connect over named pipes.

    Quite why this was needed on this install escapes me at the moment. Having checked the server, it is configured to allow connections on both named pipes and TCP/IP. There doesn't appear to be any security set on this aspect of the configuration, so anyone with appropriate permission to access the database engine should have been able to do so over either connection type - but still it would baulk at allowing a non-admin Windows user to connect via TCP/IP even if the credentials being used belonged to a valid SQL logon.

    Setting the DSN to use Named Pipes instead of TCP/IP has resolved this problem for us in this instance.

  5. Thanks to TheCrust from:

    robk (15th September 2013)

  6. #4

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    627
    Thank Post
    96
    Thanked 131 Times in 102 Posts
    Rep Power
    67
    Nice work, that's a new one on me.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 5th March 2012, 08:36 AM
  2. Replies: 13
    Last Post: 30th January 2012, 07:07 PM
  3. Adobe CS5 - Problem with running as standard user
    By kcymer in forum AV and Multimedia Related
    Replies: 21
    Last Post: 27th January 2012, 04:41 PM
  4. Software will not run as user with locked down account
    By Edu-IT in forum Educational Software
    Replies: 28
    Last Post: 9th September 2010, 06:09 PM
  5. What user should the RPC service run as?
    By fooby in forum Wireless Networks
    Replies: 3
    Last Post: 30th March 2006, 03:37 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •