Restricting workstation access to SQL2000

Posted on 2005-04-25
Last Modified: 2012-05-05
I have 60 workstations on a W2K server LAN.  SQL2000 is loaded on a server along with some other programs that all users need access to.  Only about 20 of the workstations need to access data that is stored in SQL.  I don't want to have to purchase unnecessary device CALs for SQL.  Is there a way to restrict access to the SQL portion of the server to specific machines?  
Question by:levieux7
    LVL 30

    Expert Comment

    AFAIK, SQL only cares about logins. I don't know of any way to limit physical machines.

    You could put a a firewall up and limit TCP IP connectivity to given MAC addresses.


    Author Comment

    What would happen if I set permissions on the Windows folders where the SQL program and data are stored?  
    LVL 30

    Accepted Solution

    The security context for SQL server is defined by the Windows accounts that the SQL Server and SQL Agent services runs under.

    It will make no difference if you deny security for users, as the users are connecting to a service, not a network share.

    If you close port 1433 on these machines, that would stop them connecting.

    1433 is the default port.

    To find out exactly what the port is, Use the Server Network Utility.


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now