Restrict login to one instance

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Fred Payne
    #1

    Restrict login to one instance

    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?


    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: Restrict login to one instance


      "Fred Payne" <fpayne@ryerson .ca> wrote in message
      news:bnohcm$u46 $1@news.ryerson .ca...[color=blue]
      > 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?
      >[/color]

      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.

      [color=blue]
      >[/color]


        Comment

        • Greg D. Moore \(Strider\)
          #3
          Re: Restrict login to one instance


          "Fred Payne" <fpayne@ryerson .ca> wrote in message
          news:bnohcm$u46 $1@news.ryerson .ca...[color=blue]
          > 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?
          >[/color]

          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.

          [color=blue]
          >[/color]


            Comment

            • Simon Hayes
              #4
              Re: Restrict login to one instance

              "Fred Payne" <fpayne@ryerson .ca> wrote in message news:<bnohcm$u4 6$1@news.ryerso n.ca>...[color=blue]
              > 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?[/color]

              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

                Comment

                Previous template Next
                Working...