Hello All,
I'm using SQL Server 2000 and wish to restrict the user login to one
instance only. Is this possible? Is this wise?

"Fred Payne" <fpayne@ryerson.ca> wrote in message
news:bnohcm$u46$1@news.ryerson.ca...
> Hello All,
> I'm using SQL Server 2000 and wish to restrict the user login to one
> instance only. Is this possible? Is this wise?
>

Not sure what you mean. You can sit a database to single user, but that's
generally only for maintenance purposes.

Without knowing more, I can only say it's probably NOT wise.


>

"Fred Payne" <fpayne@ryerson.ca> wrote in message news:<bnohcm$u46$1@news.ryerson.ca>...
> Hello All,
> I'm using SQL Server 2000 and wish to restrict the user login to one
> instance only. Is this possible? Is this wise?

Assuming that you mean 'instance' as in 'named instance' (see Books
Online), then each instance is a separate installation, so you manage
security separately for each one. If a user doesn't need access to one
of the instances, then you simply don't grant access to that one. If
this doesn't help, perhaps you could clarify exactly what you want to
achieve?

Simon