Re: permission problems running SQLExpress under terminal server

(astroboyfusion@xxxxxxxxxxxx) writes:
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.

And the error message is?

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.

It appears that you implemented your program without thinking or knowing
about security. Well, here are the bad news: you need to learn that now.

Exactly what you need to do, depends on what your application is up to.
If all you do is to access tables, it's only a matter of granting
table permissions. Of course, had you used stored procedure, all you
would need would be to grant rights to run the procedure. But if your
application also bulk-load files etc, you may need heftier stuff.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: auto file transfer to sbs
    ... The remotely hosted SQL Server ... is not going to be trusted by the SBS domain. ... > 2000 and I have admin access, but the firewalling is outside my control. ...
    (microsoft.public.backoffice.smallbiz)
  • auto file transfer to sbs
    ... We have an SQL server on a remote hosted machine that is accessed by the ... 2000 and I have admin access, but the firewalling is outside my control. ...
    (microsoft.public.backoffice.smallbiz)
  • Re: Permissions to allow DTS create/edit
    ... Guest is a user in MSDB and has the perms to create packages. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > Has anyone worked out the minimum set of permissions required to allow SQL users to create and/or edit DTS packages, without giving them admin access to SQLServer? ...
    (microsoft.public.sqlserver.dts)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)