permission problems running SQLExpress under terminal server

Hi all,

I've installed SQLExpress under terminal server, and everything worked
great.

Except, when the terminal server users don't have admin access, my program
crashes.

I noticed when I used Microsoft SQL Server Management Studio express on the
non admin accounts, I couldn't view the tables.

I went to the standard folder C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data
and windows denied me acess to that folder.

My question is, How can I let the users with non admin access run my program
without having them access to the data folder.

Also, is there a quick fix for my problem above to get it working? giving
admin access to everyone isn't an option.


p.s I've installed sqlexpress in Authentication Method = "Windows
Authentication"
p.s.s I've research on user instances, but felt that it didn't solve my
problem. Every user must access the same centralised data.

cheers

Astro



.

Relevant Pages

  • Re: This is why I find it hard to stay away from iRacing...
    ... need admin access. ... I don't install any games to that folder ever. ... I know the browser needs to ...
    (rec.autos.simulators)
  • Re: This is why I find it hard to stay away from iRacing...
    ... Ah, yes, that folder is a protected folder so is no good for any games that ... need admin access. ... I don't install any games to that folder ever. ...
    (rec.autos.simulators)
  • Re: Recent Folder
    ... I lost administrator access to my own ... account. ... I know I can create another with Admin access, ... The folder may have been recreated somewhere else. ...
    (microsoft.public.windowsxp.general)
  • Re: Installing games in Program Files(x86)
    ... Most games work from that folder fine but some that need admin access will have issues. ... I use Vista64 and never install any games to that folder. ...
    (microsoft.public.windows.vista.games)
  • User able to view other users private documents
    ... Windows XP we could not view other users info under their ... Douments Settings //My Documents ... We both have admin access on the computer but I wonder ... Also when I go to My Computer folder showing the ...
    (microsoft.public.windowsxp.security_admin)