MS SQL Server 2005 Express x86 - 其端口不可达 - 帮助 [英] MS SQL Server 2005 Express x86 - its port is unreachable - help

问题描述

我刚刚安装了MS SQL Server 2005 Express，当然，我试图连接它与我的测试应用程序，但事情是由于某种原因，我不能连接它
我已经检查过它的端口与CPnetstat -an但出口列表不包含任何1433端口:( SQL服务正在运行我可以检查它与操作系统服务，但其端口不可用:(我已经安装MS SQL Server 2005 Express Management Studio，但由于某种原因，它连接到MS SQL成功（

I have just installed the MS SQL Server 2005 Express and, of course, I am trying to connect it with my test app but the thing is ... for some reason I cannot connect it I have already checked its port with the CP "netstat -an" but the outcoming list does not contain any 1433 port at all :( The SQL service is running I could check it with the OS Services but its port is unavailable :( I have installed MS SQL Server 2005 Express Management Studio but for some reason it connected the MS SQL successfuly :(

所以问题是...如何安装MS SQL能够连接它客户端（Java）应用程序？

So the question is... How to install the MS SQL to be able connecting it with a client (Java) app?

有关详细信息：
操作系统：Windows XP x86 SP3
MS SQL Server 2005 Express

For more information: OS: Windows XP x86 SP3 MS SQL Server 2005 Express

感谢任何有用的意见

感谢

推荐答案

在Windows开始>所有程序> Microsoft SQL Server ????>配置工具> SQL Server配置管理器

In Windows Start>All Programs>Microsoft SQL Server ????>Configuration Tools>SQL Server Configuration Manager

在左侧的树中，选择以下列出的节点，并确保TCP / IP的状态为enabled。事实上，我不知道他们是否必须启用或只有一个。

In the tree on the left, Select the nodes listed below and make sure that the Status of TCP/IP is "enabled". In truth I'm not sure if they both have to be enabled or just one.

SQL Server Configuration Manager>SQL Server Network Configuration>Protocols for MSSQLSERVER

SQL Server Configuration Manager>SQL Native Client 10.0>Client Protocols

如果未启用，只需右键单击它们，单击启用。
我不肯定这将解决你的问题，因为它是一段时间，因为我遇到'我'的问题，但它听起来像一样的东西。

If they aren't enabled, simply right click on them and click "Enable". I'm not positive that this will fix you're problem, because it's been a while since I ran into 'my' problem, but it sounds like the same thing.

这篇关于MS SQL Server 2005 Express x86 - 其端口不可达 - 帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！