Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsWindows Server 2003Windows 2000Windows NTSmall Business ServerVirtual ServerExchange ServerIISHost Integration ServerISA ServerSMSWSUSMOMWindows Media ServerSecurityCertification
Related Topics
SQL ServerMS WindowsMS OfficePC HardwareMore Topics ...

Windows Server Forum / Small Business Server / SBS 2000 / June 2008

Tip: Looking for answers? Try searching our database.

Disable SQL Server access from a client

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jhunter@huntercomputerinc.com - 06 Jun 2008 16:25 GMT
How do I disable SQL Server access, from one login name on one
computer?

Basically, I need to setup a Guest account on a computer where other
people login. I want to strip access to our mission critical SQL
application from this Guest login.
Larry Struckmeyer [SBS-MVP] - 07 Jun 2008 00:04 GMT
Hi:

Not clear to me what the problem is.  If there is a front end to this
application, don't install it on the "guest" computer.  If there is a
program.exe file that lives on the server, create a security group that has
access to that file, put your regular users in that group, but not the
"guest" user.  Then remove all other security access to that file/folder,
leaving only the security group.

Do not do this with individuals, as it gets too messy to control.  Every
time you add or subtract a user from your network, or promote a new employee
to a "regular user" all you have to do is add them (or remove them) from the
security group.

--
Larry

> How do I disable SQL Server access, from one login name on one
> computer?
>
> Basically, I need to setup a Guest account on a computer where other
> people login. I want to strip access to our mission critical SQL
> application from this Guest login.
Duncan McC - 11 Jun 2008 04:12 GMT
In article <11a1be10-b2cc-4337-bb8b-40c7c56ffda0@
34g2000hsh.googlegroups.com>, jhunter@huntercomputerinc.com says...
> How do I disable SQL Server access, from one login name on one
> computer?
>
> Basically, I need to setup a Guest account on a computer where other
> people login. I want to strip access to our mission critical SQL
> application from this Guest login.

Surely this all depends on how the user gets access to the SQL Server
database.

Many apps use Windows Authentication, and some don't, while others
provide both (either or) - in which case you could change away from WA
to using SQL Server authentication, and given that user doesn't exist in
SQL Server, they won't be able to start the app.

Another way, just remove the front-end SQL Server app from the
workstation.

Signature

Duncan

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.