Re: Access Project Deployment
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Thu, 20 Sep 2007 10:57:48 +0300
If you and your clients are in a trusted domain environment, how about using Windows Authentication method to authorize your users?
Create a Windows Group and make your clients member of that group and then go to SQL Server (2005\2000?).
If it's SQL Server 2005:
Then fire up SQL Server Management Studio and go to Security\Logins. Create a login for that Windows Group and give them necessary rights and permissions so that they will be able to connect to the mentioned database.
If it's SQL Server 2000:
Then fire up Enterprise Manager and go to Security\Logins. Create a login for that Windows Group and give them necessary rights and permissions so that they will be able to connect to the mentioned database.
--
Ekrem Önsoy
"MUSIWA" <MUSIWA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3523D34A-AA74-4899-98AE-7C454480AFDA@xxxxxxxxxxxxxxxx
I appologise if this is silly but I am trying. I upsized my access mdb
database to access project (adp) sql. It works very well now. my is I now
copy it and I palce it in myclients and if I am logged into the clients the
program works just fine but if my users are logged in it cannot connect to
the data base. I know I have to authorize them to logg in but I do not know
how. Please can someone walk me there slowly. I am using server 2003 and the
full installation of SQL. My clients are using office XP and windows XP
proffesional. Thankyou in advance
.
- Prev by Date: Re: SQL server connection problem
- Next by Date: Symmetric and Asymmetric
- Previous by thread: Re: A full log
- Next by thread: Symmetric and Asymmetric
- Index(es):
Relevant Pages
|
