restrict acces to server from lan

Hello,
I got a new SQL 2000 server running. Now we have some clients with local
msde's who are not allowed to connect to that server with their client. Can
this be done? they need network acces and they need to be able op connect to
that server using another application. So it's strictly their local engine
what they are not allowed to use to open that database on their local system
Sincerely
evbHi
I am not quite sure what you are asking here. You don't say how they are
connecting to the database server. Usually the connection string will
specify which server you are going to connect to. Access to your database
server/database will depend on the security that you put in place and you
can restrict the access to your own application by using an application
role.
If the MSDE instance does not contain a copy of your database then there
will not be able to run your application.
John
"E van Bergen" <evanbergen.no.spam@.modderkolk.no.spam.nl> wrote in message
news:co7cmj$jj$1@.reader08.wxs.nl...
> Hello,
> I got a new SQL 2000 server running. Now we have some clients with local
> msde's who are not allowed to connect to that server with their client.
> Can
> this be done? they need network acces and they need to be able op connect
> to
> that server using another application. So it's strictly their local engine
> what they are not allowed to use to open that database on their local
> system
>
> Sincerely
> evb
>sql