Restricting workstation access to SQL2000

Posted on 2005-04-25
Medium Priority
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
  • 2
LVL 30

Expert Comment

ID: 13862944
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

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

Accepted Solution

nmcdermaid earned 1000 total points
ID: 13871616
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

807 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