x

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.

Thanks,

Oran

more ▼

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

orandov gravatar image

orandov
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 ♦♦
53k 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1948
x46

asked: Feb 12, 2010 at 05:31 PM

Seen: 1356 times

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