restrict login to one instance

From: Fred Payne (fpayne_at_ryerson.ca)
Date: 10/29/03 

Date: Wed, 29 Oct 2003 10:57:19 -0500

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?

Relevant Pages

  • VPN into 2ns domain?
    ... The easiest answer is to create a user login based in the ... >I am using VPN to connect my laptop to a second domain at ... >domain/account to get into SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Denying Remote SQL Server Access
    ... You simply restrict the IP address going to the internet ... Where is your SQL Server? ... Software or hardware firewall? ...
    (microsoft.public.sqlserver.security)
  • IIS on server 2000
    ... When you access a asp page from the website - it ... domain authentication - The SQL server requests a user id ... asp page is running on the IIS webserver it sends the ... Is there a setting in IIS to pass the user login ...
    (microsoft.public.inetserver.iis.security)
  • Re: Query Analyzer Connect Cption
    ... An user get access to SQL Server only after successful authentication. ... you restrict the user by changing the password or removing ... the user id from SQL server will ultimately restrict him not to create a new ... Query analyzer session with a different user id. ...
    (microsoft.public.sqlserver.security)
  • Licenseing
    ... I have a SBS 2003 Premium edition and I use SQL Server as ... the backend database for an application that uses ... Sqlserver authentication for user login. ... licence for the clients and if so, ...
    (microsoft.public.windows.server.sbs)