sql server connect: Win2003 Server R2 Sql2005

My problem is unless I Login as a user with administrator permissions I
cannot
connect the SQL DB on the main server.
I want setup users as USERS on the local domain
with minimal access and have use of the Application which uses the Sql
Server

TIA

Sam

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
---

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
[quoted text, click to view]