如何测试到没有SSMS的远程SQL 2005的连接？ [英] How to test a connection to a remote SQL 2005 without SSMS?

问题描述

我们在连接到远程SQL Server 2005（命名实例）的客户端应用程序中存在一些连接问题。

有些方法可以测试客户端没有安装SSMS或查询分析器的计算机（Windows XP）？

我想查看问题是否与特定应用程序相关，一般连接到从特定客户端的远程sql服务器。

解决方案

您可以通过管理工具创建ODBC连接到SQL Server，并使用测试连接 / p>

We are having some connectivity issues from a client application connecting to a remote SQL Server 2005 (named instance).

What are some ways to test connectivity from the client machine (Windows XP) that doesn't have SSMS or Query analyzer installed?

I would like to see if the issue is related to the specific application or is it a more general connectivity to the remote sql server from the specific client.

解决方案

Can you create an ODBC connection via admin tools to the SQL Server and use the "Test Connection" function in there?

这篇关于如何测试到没有SSMS的远程SQL 2005的连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！