How to test a connection to a remote SQL 2005 without SSMS?

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.



more ▼

asked Feb 12, 2010 at 05:31 PM in Default

orandov gravatar image

15 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

My favourite is create a new text document on your desktop. Change the file extension to '.udl' - this creates a Universal Data Link file. Double click it and fill in the properties and use that to check for connectivity.

Obviously requires you to have the relevant client side network libraries installed.

more ▼

answered Feb 12, 2010 at 06:04 PM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 49 76

always reliable, no particular applications needed at the client. My preferred option too.
Feb 12, 2010 at 06:13 PM Fatherjack ♦♦
That technique has been helpful on many MS CRM deployments
Feb 15, 2010 at 09:44 PM Scot Hauder
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 12, 2010 at 05:31 PM

Seen: 1389 times

Last Updated: Feb 12, 2010 at 05:38 PM