将静态IP分配给Sql Server2008 R2 [英] Assign static ip to Sql server2008 r2

问题描述

我想为sql server 2008 r2分配一个静态IP，以便可以从客户端访问数据库.因此，plzzz应该如何告诉....

I want to assign a static ip to sql server 2008 r2 so that i can access the database from a client.So how should i do that plzzz tell....

推荐答案

通常来说，您不会通过PC分配静态IP.
这取决于您在说什么IP:
本地(在您的局域网内)
公共(互联网IP地址).

您可以在某些系统上通过PC设置前者-这取决于网络(尤其是DCHP)的配置方式.

稍后您将无法选择自己-它是由ISP分配的，通​​常，如果您要使用静态IP地址而不是动态IP地址，则将不得不支付额外的费用.

Generally speaking, you don''t assign a static IP via the PC.
It depends on what IP you are talking about:
Local (within your LAN)
Public (internet IP address).

The former you can set via the PC on some systems - it depends on how the network and particularly the DCHP are configured.

The later you cannot select yourself - it is assigned by your ISP, and generally you will have to pay extra if you want an static IP address rather than a dynamic one.

SQL Server不是Oracle:您不需要静态IP.
当您要连接时，请确保服务器名称可以由DNS解析，并使用正确的实例名称.
还要检查运行SQL Server的计算机的防火墙是否不会阻止传入呼叫.
接下来，可以将SQL Server配置为不接受来自其他计算机的呼叫-检查是否未配置.

SQL server is not Oracle: you do not need a static IP.
When you want to connect, make sure that the servername can be resolved by DNS, and use the correct instance name.
Also check that the firewall of the computer where your sql server is running does not block incoming calls.
Next, the SQL server can be configured not to accept calls from other computers - check that that is not configured.

这篇关于将静态IP分配给Sql Server2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！