Re: permission problems running SQLExpress under terminal server

Hi

The programm connects to SQL Server via a login that you defined on the
server. So non admin users are running the programm in context of the login
the application connects to. You mentioned that program is crashed, what is
the error?

Okay, I see you set up SQL Server with Windows Authentication mode only.
Create a group on the machine where SQL Server run and add those users tio
the group. It is up to you wether or not not the users are member of syadmin
server role.







<astroboyfusion@xxxxxxxxxxxx> wrote in message
news:46806b20$0$46400$c30e37c6@xxxxxxxxxxxxxxxxxxxxxxxxx
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: SQL Server 2005 login with Windows Authentication
    ... I obviously installed SQL Server using my Francois (admin) local user ... So having stated that I chose windows authentication as ... And the reason for this is that a Windows login also can have access ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE password change for "sa"
    ... I login to the machine as a local admin and connect via the ... > Upgrading to SQL Server isn't too bad. ... You will be asked if you want to upgrade ...
    (microsoft.public.sqlserver.server)
  • RE: Linked server issue
    ... SQL Server logins to the Admin account of the Access database. ... Add a new linked server using SQL Server Enterprise Manager. ... Remote login: Admin ...
    (microsoft.public.sqlserver.tools)
  • Re: Clustering and SA Role
    ... It helps if your Domain/Enterprise Administrators, Server Administrators, ... > I guess the issue is that in SQL2000 one could remove local admin group ... > legitimately getting into SQL Server. ... Trust for sure simplifies management in many ...
    (microsoft.public.sqlserver.clustering)
  • Re: Capture IP Address
    ... I have some MS Access front end databases linked to SQL Server 2000 ... logins for every user that requests access to the database and capture every ... The interesting part is that the Login Failed attempt ... any of our databases named 'Admin' especially to our Master. ...
    (microsoft.public.sqlserver.security)