Link to home
Start Free TrialLog in
Avatar of Varshini
Varshini

asked on

How do i test my remote sql server connection?

How do i test my remote  sql server connection  ?, i have ip address and port number.
( Like ping utility).  os is windows xp
Avatar of 50cal
50cal
Flag of United Kingdom of Great Britain and Northern Ireland image

If you just want to test connection's to the port/ip of the server/machine you could try the command line
telnet ip.of.sql.server port

50cal.
from the command prompt:

OSQL -S SERVERNAME -U USERNAME -p password

or
 (if you using intergrated security to connect to sql server)

OSQL - S SERVERNAME - E
Here is a tool which i found on a Dell Management Console CD. You can test for anykind of connection you like. IT will work with SQL and much more. it is called troubleshoot.msi. IT is a general tool to troupleshooot any kind of connection issue. you have to rename the file from .PDF to MSI. It work very well and DELL also has great support.
ASKER CERTIFIED SOLUTION
Avatar of Norman Maina
Norman Maina
Flag of Kenya image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial