报错“由于目标机器积极拒绝，无法连接”怎么解决？
在我们有时连接sqlserver数据库时，通过本地端的数据库去连接别的机器的数据库，或者是服务器上的数据库，一般会出现“由于目标计算机积极拒绝，无法连接”的字样，那到底是什么原因呢？怎么解决？
1、如果出现这样的情况，首先我们要排查对方的机器ip或者服务器的ip是否拼得通，如果拼不通，那肯定连接不上了，那就要看看是防火墙有没有阻止ip的拼接。如果ping得通，那就与这个无关了。
上面能拼得通，就说明能够连接得上对方的电脑了，接下来就在数据库上找原因了，出现这种情况，一般是对方的电脑或服务器的电脑禁止 别的电脑的连入。
这个时候，我们不妨到对方机器上或服务器上去查找数据库是否禁止别的电脑连入。这个时候，我们应该如何操作呢？打开数据库配置管理，然后从中去查找原因。
在左边的单机栏中找到MSSQLSERVER的协议，然后点击选取，然后在这个右边的空白处就会跳出协议名称和各自的状态，这个时候我们发现TCP/IP的状态是禁用的。
接下来我们要做的事情就是邮件TCP/IP这一栏，然后选择去启用它，让其状态由原来的禁用状态变为启用状态，这样的话，我们就完成了操作。
接下来我们连接的时候，发现还是出现一开始出现的错误，按道理说我们已经完成了设置了，这时候我们遗忘了做一件事情，就是重新启动数据库的服务，我们找到图中选中的服务，右键重新启动就可以了。
这样的话，我们就解决了上面链接服务器或其他人机器数据库时出现的错误。
更多相关知识，请访问 PHP中文网！！
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
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to import mdf file into sqlserver
Apr 08, 2024 am 11:41 AM
The import steps are as follows: Copy the MDF file to SQL Server's data directory (usually C:\Program Files\Microsoft SQL Server\MSSQL\DATA). In SQL Server Management Studio (SSMS), open the database and select Attach. Click the Add button and select the MDF file. Confirm the database name and click the OK button.
How to recover accidentally deleted database in sqlserver
Apr 05, 2024 pm 10:39 PM
If you accidentally delete a SQL Server database, you can take the following steps to recover: stop database activity; back up log files; check database logs; recovery options: restore from backup; restore from transaction log; use DBCC CHECKDB; use third-party tools. Please back up your database regularly and enable transaction logging to prevent data loss.
How to delete sqlserver if the installation fails?
Apr 05, 2024 pm 11:27 PM
If the SQL Server installation fails, you can clean it up by following these steps: Uninstall SQL Server Delete registry keys Delete files and folders Restart the computer
How to change sqlserver English installation to Chinese
Apr 05, 2024 pm 10:21 PM
SQL Server English installation can be changed to Chinese by following the following steps: download the corresponding language pack; stop the SQL Server service; install the language pack; change the instance language; change the user interface language; restart the application.
What is the difference between mysql and sqlserver syntax
Apr 22, 2024 pm 06:33 PM
The syntax differences between MySQL and SQL Server are mainly reflected in database objects, data types, SQL statements and other aspects. Database object differences include the storage engine and how filegroups are specified, and the creation of indexes and constraints. Data type differences involve differences in numeric types, character types, and date and time types. SQL statement differences are reflected in result set limitations, data insertion, update and delete operations, etc. Other differences include how identity columns, views, and stored procedures are created. Understanding these differences is important to avoid errors when using different database systems.
How to delete database in sqlserver
Apr 05, 2024 pm 11:00 PM
To delete a SQL Server database, please perform the following steps in sequence: 1. Log in to SQL Server Management Studio; 2. Expand the database node; 3. Right-click the database to be deleted; 4. Select "Delete"; 5. Confirm the deletion. Note: Deleting the database is irreversible, please make sure you have backed up important data and disconnected other objects.
How to recover data deleted from sqlserver
Apr 05, 2024 pm 10:45 PM
SQL Server deleted data can be recovered through transaction rollback (rolling back uncommitted transactions). Database log (restore data from log). SQL Server native backup (restore database from backup). Third-party recovery tools (use advanced technology to recover data). Contact Microsoft Support (for dedicated help).
Where is the navicat database file?
Apr 23, 2024 am 10:57 AM
The location where the Navicat database configuration files are stored varies by operating system: Windows: The user-specific path is %APPDATA%\PremiumSoft\Navicat\macOS: The user-specific path is ~/Library/Application Support/Navicat\Linux: The user-specific path is ~/ .config/navicat\The configuration file name contains the connection type, such as navicat_mysql.ini. These configuration files store database connection information, query history, and SSH settings.
