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
( Like ping utility). os is windows xp
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
telnet ip.of.sql.server port
50cal.