在SQL Express 2005中启用远程连接 [英] Enable Remote connection in sql express 2005

问题描述

如何使用sql查询在sql express 2005中启用TCP/IP连接?
或
如何使用.net 2008在sql express 2005中启用TCP/IP连接?

How can I enable TCP/IP connection in sql express 2005 using sql query ?
Or
How can I enable TCP/IP connection in sql express 2005 using .net 2008 ?

推荐答案

尝试以下解决方案手动进行:-

为了远程连接到Microsoft SQL Server 2005，需要启用TCP/IP.默认情况下，在Microsoft SQL Server 2005 Express版本上禁用此功能.在其他版本的Microsoft SQL Server 2005上，也可能手动禁用了TCP/IP.

本文介绍了如何在Microsoft SQL Server 2005上启用TCP/IP:

从Microsoft SQL Server 2005->配置工具，打开"Microsoft SQL Server配置管理器".

展开"SQL Server 2005网络配置"，然后单击<实例名称="=">的协议.
<实例名称>是GFI产品使用的Microsoft SQL Express实例的名称.

右键点击"TCP/IP"，然后点击启用".该协议的图标将更改为表明该协议已启用.


此链接将有助于显示如何在SQL Server 2005中启用远程连接的图形表示形式.

http://www.webxpert.ro /andrei/2009/05/31/enable-tcpip-on-sql-server-2005-express-edition/ [

Try this solution to do it manually:-

In order to connect to the Microsoft SQL Server 2005 remotely, TCP/IP needs to be enabled. This is disabled by default on Microsoft SQL Server 2005 Express edition. TCP/IP may also be manually disabled on other editions of Microsoft SQL Server 2005.

This article explains how to enable TCP/IP on Microsoft SQL Server 2005:

From the Microsoft SQL Server 2005 -> Configuration Tools, open the ''Microsoft SQL Server Configuration Manager''.

Expand ‘SQL Server 2005 Network Configuration’, and then click ‘Protocols for <instance name="">’.
<Instance Name> is the name of the instance of Microsoft SQL Express being used by the GFI product.

Right-click ‘TCP/IP’ and then click ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.


this link will be helpful showing the pictorial representation of how to enable remote connection in SQL Server 2005

http://www.webxpert.ro/andrei/2009/05/31/enable-tcpip-on-sql-server-2005-express-edition/[^]

I hope the above solution works for you.

这篇关于在SQL Express 2005中启用远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！