Re: User SQL access problem

Jens,

Thank for your reply.

I am using window Authentication
and yes they are on the same Domain

What I want is to allow them to use the Application which uses the SQL
server
but minimal user Rights

So they can't add or remove or change local computer setting

TIA

Sam
"Jens" <Jens@xxxxxxxxxxxxxxxx> wrote in message
news:1168085142.725664.215010@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

do you want to use SQL Server authentication or Windows authentication
? Is the Sql Server and the users connecting in the same domain ?


HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---



.

Relevant Pages

  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... permission to all usersand create table or schema as database ... Rick Byham, SQL Server Books Online ... What is purpose for set "Window Authentication" or "Sql Server ... for DBA to login to do dabase management in future? ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... Now connect to SQL Server using the SQL Server Management Studio program. ... Once a login is connected to the SQL Server Database Engine, ... Is there possible under window authentication, ...
    (microsoft.public.sqlserver.security)
  • RE: Linked server with mirrored database 2
    ... So SQL Server consider ... the connection use window authentication as by default. ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.setup)
  • Why is SQL Server account used?
    ... But vendors want to use SQL Server account to install products. ... The vendor said that I should use SQL Sever login before I install a product. ... I used Window Authentication to install the product. ...
    (microsoft.public.sqlserver.server)
Loading