sql connection

Hot Topic

Recursive query?
SQL Server best practice with IIS
SQL server 2005 POOR performance on a good dev machine
Strange results when using parent child dimension
VWDExpress ASPNETDB.MDF SQL 2005 Express LOGIN CONTROLS
How to hide parameters information from URL
Qns on SQL Express Database
Intellisense..when?
Installation of Report Service Print ActiveX RSClientPrint.dll Question
Cascading parameters problem

SQL Server

How to use a Table Variable
Update table with result from Data Mining Query
Count of employees
Setting Global Variables in a Script Task, HOW?
Possible bug: Lose members of server role when changing DataDir server property
File Groups
How to send email using asp.net 2.0 and how to find the smtp mail server name?
Profiler Error data column
Cant's shrink tempdb in sql2k5
Is there a way to use an access export specification in Sql 2005 mgmt studio?

sql connection

hello,

Is it possible to use TELNET(from the client in LAN A) and access database instance at(sql Server at LAN B) . I meann to say is, can we use TElnet over the internet to access the instance.

can anybody helps me

Thanks in advance

Answer this question

sql connection

  • Computer-Desk

    YOu can open a port to SQL Server via telnet, it questionable what you can do with telnet on the instance. You can also use any query tool to access the appropiate port on the SQL Server. If the Server is behind a firewall you will have to do a port fowarding, opening the firewall and redirecting the request to the sQl Server.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • A. Brosten

    Hi,

    ok I thought that you wanted to do this. If you want to query / modify the database, you probably don’t want to do this with telnet, rather than a query tool like the SSMS in SQL 2005 or Query ANalyzer in SQL 2000, or SQLCMD or OSQL at the commandline.

    Try to establish first a connection which is pingable from the two location, then do the port forwarding to the SQL Server computer. This is not a specific SQL Server related problem rather than a infrastructure problem.


    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • MA2005

    hello sir,

    i want to access the instance over the internet, thats why i am thinking to move on telnet .

    using this i will access the intance over the internet.

    can u suggest me a best approach for the above case

    thanks for ur help

  • Sankar N

    hello,

    my database is available somewhere anothet city , so, i want to retrive , modify the records thru sql querries .

    so, iam using the concept telnet.

  • Dekay Kim

    WHat do you want to do while connected via telnet


    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • sql connection
Answer this question