Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to link to the web in the SQLServer database. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

How to use SQLServer Database for Network Link

If you use SQLServer2005

The concepts and discussions about SQLServer2000 apply equally to SQLServer2005 and SQLServerExpress.

Each SQLServer2000 instance or MSDE2000 instance can be configured to listen on a specific set of network protocols and addresses. If an instance does not require a network connection, turning off unused network support reduces the security dependency of the instance. You can do this by configuring the instance not to listen on any network protocols. In general, you should only configure the version of SQLServer2000 that runs as a local data store:

SQLServer2000PersonalEdition

SQLServer2000DesktopEngine (MSDE2000)

When an SQLServer instance is configured not to listen for network protocols, all applications on the same computer communicate with it using a shared memory network library.

Turning off network protocol support does not mean that network protocols are inherently insecure. Whenever a program accesses an external resource, the program acquires a dependency on the security of the external resource, even if the external resource is very secure. By closing unused resources, the program can reduce its security dependencies.

Note: all management of this instance must be done on the computer on which it is running.

When instances of SQLServer2000SP3a or MSDE2000SP3a are configured not to listen on any network protocols, they will stop listening on UDP port 1434. Earlier versions of SQLServer2000 or MSDE2000 always listen on UDP1434 regardless of configuration.

If the instance is running in Windows Authentication mode, one of the Windows accounts on this computer must be a member of the SQLServersysadmin fixed server role. If the instance is running in mixed mode, the administrator can log in using the sa account or a Windows account in the SQLServersysadmin fixed server role.

To configure an existing SQLServer2000 or MSDE2000 instance not to listen for network connections using the SQLServer2000 Server Network utility, follow these steps:

1. If you have SQLServer client tools installed on your computer, open the MicrosoftSQLServer program group, and then start the Server Network utility. If the SQLServer client utility is not installed, run the Svrnetcn.exe file in the SQLServerTools\ Binn folder. In general, the reason for not installing the SQLServer client utility on a computer is that the computer runs only MSDE2000 instances, which do not provide users with permission to use the SQLServer client utility.

two。 On the General tab, select the name of the SQLServer instance in the instances on this computer list box. Click the Server name of the default instance to select it, or select Server name / instance name for any specified instance.

3. To restrict instances of SQLServer to allow only local connections, click disable until no more protocols are listed in the enabled protocols list. If you need to change this setting later to allow remote connections, reverse this process and enable one or more protocols.

4. Click OK.

How to use SQLServer Database for Network Link

5. Restart the SQLServer instance for the changes to take effect.

For a SQLServer2000 instance that is currently configured not to support network connections, you can use the SQLServer2000 Server Network utility to enable network connections to it.

DISABLENETWORKPROTOCOLS switch

The SQLServer2000DesktopEngine (MSDE2000) ServicePack3 installer introduces a new DISABLENETWORKPROTOCOLS switch that you can use to install a new instance of MSDE2000 without any network connections enabled.

For SP3, the behavior of this switch is that if DISABLENETWORKPROTOCOLS is not specified, the instance will be installed to enable network protocol connections. If you specify DISABLENETWORKPROTOCOLS=1, no network protocols will be enabled for this instance.

In SP3a, there are two changes to the behavior of DISABLENETWORKPROTOCOLS:

The default behavior when installing a new instance of SP3a is to disable network protocol support, making the instance more secure by default.

When upgrading an existing MSDE2000 instance, you can specify that network protocol support be turned off.

The following table describes this behavior:

New installation of MSDE2000SP3a:

Currently sets the network protocol specified by the user to set the network protocol result

No disable

No enablement

No no user-specified settings are disabled

Upgrade to MSDE2000SP3a: current settin

User-specified network protocol settings network protocol results

Disable

Disable enable enable

Disable without user-specified settings disable

Enable

Enable disable disable

Enable with no user-specified settings enabled

Note: when you run MSDE2000setup.exe with the "/" switch to list the switches it supports, the / DISABLENETWORKPROTOCOLS switch is not listed.

After reading the above, do you have any further understanding of how to link to the web in the SQLServer database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.