Post reply

how i can run query on SQL server 2000 remotely??

  • January 22, 2007 at 12:16 am

    #171925

    i have sql-server 2000 installed on one machine, connected on the internet using static IP address.

    is it possible to run sql query using VB or powerbuilder without having to setup the second machine from the same workgroup but by using the first machine IP address?

    if not what is the solution?

    thanks,

     

     

  • January 25, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • January 29, 2007 at 10:07 pm

    #686366

    You can run queries against a remote SQL server by IP address.  You'll need to connect via TCP/IP in this case, so make sure that protocol is enabled.  Since you're working remotely, you will most likely have to use SQL authentication.

    OF course, you should prepare yourself for the dangers of having a SQL Server machine directly connected to the Internet.  Make sure you know what you're getting into.

    hth

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • January 30, 2007 at 12:23 pm

    #686570

    Thanks for your contribution.

    i just found way by running sql query hosted on the web.

    that is much better for security reasons.

    thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply