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

avatar image

15 1 1 4

(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

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(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: 1497 times

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

Copyright 2018 Redgate Software. Privacy Policy