仅使用IP连接到没有实例名称的SQL Server 2008？ [英] Using only IP to connect to SQL Server 2008 without instance name?

问题描述

我没有与数据库维护任务相关联。我是应用程序开发人员。我在我的计算机上安装了SQL Server 2008 Express版本作为实例 localhost \sqlexpress 。

如何仅使用IP地址连接到此服务器，而不是 ip\sqlexpress ？

如果可能有多个实例并且我使用IP连接，那么如何选择任何服务器实例？

解决方案

您可以使用IP地址来引用实例。这将是 xxx.xxx.xxx.xxx\sqlexpress 。

如果你只是使用IP地址（或主机名），您必须在计算机上安装默认实例。

默认情况下，SQL Server Express是一个命名实例，并且将需要命名的实例实例数据源引用（ip / hostname后跟实例名称）。您将需要安装Express作为默认实例以仅通过ip引用。

换句话说，您不能使用IP连接到SQL Server Express实例除非您已将Express安装为默认实例。

I am not associated with database maintenance task. I am application developer. I installed SQL Server 2008 Express edition on my computer as an instance localhost\sqlexpress .

How do I use only the IP address to connect to this server rather than ip\sqlexpress ?

If multiple instances are possible and I am connecting with IP then how can I choose any instance of server?

解决方案

You can use an IP address to reference the instance. It would be something like xxx.xxx.xxx.xxx\sqlexpress.

If you were to just use the IP addess (or host name) you would have to have a default instance installed on the machine. If you have no default instance installed then you will not connect, and you'll return an error.

SQL Server Express is a named instance by default and will require the named instance datasource reference (ip/hostname followed by instance name). You will need to install Express as a default instance to reference by ip only.

In other words, no you cannot connect to a SQL Server Express instance with IP only unless you have installed Express as the default instance.

这篇关于仅使用IP连接到没有实例名称的SQL Server 2008？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！