How to restrict SQL Server to only allow specified machines to connect (transfer)

Home

Backend Development

PHP Tutorial

How to restrict SQL Server to only allow specified machines to connect (transfer)_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 pm 05:01 PM

accesscanrestrictsqlserverhowtalentmachinechangeconnectlimit

Q. How can I restrict access to my SQL Server so that it only allows certain machines to connect?
(v1.0 19.10.1998)
How can I restrict access to my SQL Server so that it only allows certain machines to connect?
A. SQL Server has no built-in tools/facilities to do this. It also does not have the facility to run a stored-procedure on connection that could be written/used to do this. Therefore you have the following choices : -
SQL Server does not have such a function, nor does it provide the function of executing a specific process when connecting. Here are several implementation methods
1. Put the SQL Server behind a firewall and use that to restrict access. This is the most secure and functional way to do what you want.
Using a firewall, it provides security and the tools you want to use.
2. Write your own ODS Gateway and point the clients at that instead of the SQL Server - the ODS Gateway will then do the checking. However, there is nothing stopping clients figuring out the correct SQL client-config entries to point straight at the SQL Server. There are examples of ODS code in the SQL Programmers Toolkit - available for free download from the MS website.
Write your own ODS gateway instead of SQL Server client - check in ODS Gateway. However, this does not stop normal client connections to SQL Server. There is an example of this in the SQL Programmers Toolkit, which can be downloaded for free from the Microsoft site.
3. Write a constantly running/scheduled stored-procedure that checks the relevant column in sysprocesses (net_address), and then issues a KILL command for any processes that should not be running. Note that this only works for MAC addresses. This way allows people to connect and possibly make changes before they are spotted and killed.
Write a stored procedure to check the corresponding column (net_address) in sysprocesses
　

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Java连接SqlServer错误如何解决May 01, 2023 am 09:22 AM

问题发现这次使用的是SqlServer数据库，之前并没有使用过，但是问题不大，我按照需求文档的步骤连接好SqlServer之后，启动SpringBoot项目，发现了一个报错，如下：刚开始我以为是SqlServer连接问题呢，于是便去查看数据库，发现数据库一切正常，我首先第一时间问了我的同事，他们是否有这样的问题，发现他们并没有，于是我便开始了我最拿手的环节，面向百度编程。开始解决具体报错信息是这样，于是我便开始了百度报错：ERRORc.a.d.p.DruidDataSource$CreateCo

如何解除视频号评论限制？视频号评论限制多少字数？Mar 22, 2024 pm 02:11 PM

随着视频号在社交媒体上的普及，越来越多的人开始利用视频号分享他们的日常生活、见解和故事。然而，一些用户可能会遇到评论被限制的情况，这会让他们感到困惑和不满。一、如何解除视频号评论限制？要解除视频号评论限制，首先必须确保账号已正常注册并完成实名认证。视频号对评论设有要求，只有完成实名认证的账号才能解除评论限制。如果账号存在异常情况，需要先解决这些问题才能解除评论限制。2.遵守视频号的社区规范。视频号对评论内容有一定的规范要求，如果评论涉及违规内容，会被限制发言。要解除评论限制，需要遵守视频号的社区

Win11无法安装SQL Server的原因及解决方案Dec 27, 2023 pm 07:48 PM

有网友反馈，在win11上无法安装sqlserver这款软件，不知道是怎么回事，根据目前的测试来看，win11存在硬盘问题，部分接口硬盘无法安装这款软件。win11为啥不能安装sqlserver：答：win11不能安装sqlserver是硬盘的问题。1、据了解，win11存在对于硬盘的检测bug。2、这导致sqlserver无法在“三星m.2接口”硬盘上安装。3、因此，如果我们要安装的话，需要准备一块其他硬盘。4、然后将该硬盘安装到电脑里，如果没有额外插槽的话就要换掉之前的硬盘。5、安装完成后，

sqlserver和mysql区别是什么Aug 11, 2023 am 10:21 AM

sqlserver和mysql区别是：1、Server适用于Windows操作系统，而MySQL适用于多个操作系统；2、Server需要购买许可证才能使用，而MySQL可以免费下载和使用；3、Server适用于大型企业级应用程序，而MySQL则适用于中低规模的应用程序；4、Server提供了丰富的安全功能，而MySQL的安全功能相对较少；5、Server使用自己的存储引擎等。

Linux怎么安装ODBC连接SQLServer数据库May 16, 2023 pm 12:19 PM

操作系统：Centos7.21、下载ODBC安装包unixODBC-2.3.9.tar.gzfreetds-1.3.9.tar.gz2、安装步骤第一步：上传两个安装包到服务器上第二步：安装unixODBC，先安装这个，后安装freetds注意：这里如果安装顺序不一致，就不会产生libtdsodbc.so驱动文件（非常重要）2.1、操作系统先安装gcc:yuminstallgcc2.2、安装odbctar-xvfunixODBC-2.3.9.tar.gzcdunixODBC-2.3.9./conf

如何设置CentOS系统以限制用户对系统日志的修改Jul 05, 2023 pm 03:43 PM

如何设置CentOS系统以限制用户对系统日志的修改在CentOS系统中，系统日志是非常重要的信息源，它记录了系统的运行状态、错误信息、警告等。为了保护系统的稳定性和安全性，我们应该限制用户对系统日志的修改。本文将介绍如何设置CentOS系统，实现对系统日志的修改权限限制。一、创建用户组和用户首先，我们需要创建一个专门负责管理系统日志的用户组，以及一个用于管理

wps会员最大可上传多大文档超过限制怎么办Mar 20, 2024 pm 06:40 PM

wps是一款集综合性操作的办公软件，现在可以下载wps进行使用，但是要想拥有更多的使用功能是需要注册会员的。有的人会疑惑wps会员最大可上传多大文档？如果是wps会员用户，上传文件时每次最高可以超大1G，而所有的文件加起来可以达到365G，不同的终端可能会存在部分差异，但总体显示是基本相似的。如果超过限制无法上传怎么办？接下来我们就进行讲解。1、上传文件，例如云文档，空间是存在一定大小的，超过了就无法再上传。2、点击会员标识，按照自己的需要购买会员，扩充空间。3、偶尔会出现优惠券，不要忘了使用。

JavaScript 如何实现图片的拖动缩放同时限制在容器内？Oct 20, 2023 pm 04:19 PM

JavaScript如何实现图片的拖动缩放同时限制在容器内？在Web开发中，经常会遇到需要对图片进行拖动和缩放的需求。这篇文章将介绍如何使用JavaScript实现图片的拖动缩放，并限制在容器内的操作。一、拖动图片要实现图片的拖动，我们可以使用鼠标事件来跟踪鼠标位置，并将图片的位置随之移动。下面是一个示例代码：//获取图片元素varimage

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Repo: How To Revive Teammates

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hello Kitty Island Adventure: How To Get Giant Seeds

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

How Long Does It Take To Beat Split Fiction?

3 weeks agoByDDD

R.E.P.O. Save File Location: Where Is It & How to Protect It?

3 weeks agoByDDD

Hot Tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

SublimeText3 Linux new version

SublimeText3 Linux latest version

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.