Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 613
  • Last Modified:

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
0
Varshini
Asked:
Varshini
  • 2
1 Solution
 
50calCommented:
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.
0
 
NormanMainaCommented:
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
0
 
louisreevesCommented:
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.
0
 
NormanMainaCommented:
were you successful?

50cal's idea of using Telnet is very useful if you want to test if two machines can communicate through a certain port - this is because some posts may be blocked by firewall etc

You can mix with using OSQL or SQLCMD(for sql server 2005 onwards) to check if you can actually connect to an instance of SQL Server using some credentials either integrated security or through mixed mode authentication using sql server log ins.
For OSQL to work you need to have an instance of sql server in both machines being tested.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now