Results 1 to 6 of 6

Thread: Remote Manage

  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: Remote Manage

    Before I just manage the SQL serve in LAN.

    Right now i have a SQL server on internet I want to Remote manage

    Can I still use QA and Enterprise Manager ?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, you can use Query Analyzer and SQL Enterprise Manager to manage a server that is open to the Internet. I would consider making an exception at your firewall to allow that server to remain part of your NT domain, so that you can use NT Authentication instead of SQL Authentication.

    -PatP

  3. #3
    Join Date
    Nov 2003
    Posts
    6

    How can I do it?

    how can I set some config on my Enterprise manager or QA?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Huh? I don't understand what you are asking.

    -PatP

  5. #5
    Join Date
    Nov 2003
    Posts
    6

    Smile I mean How can i find out the SQL Server on internet?

    Sorry about confuse,

    I dont have this kind of experience. Before i just install client software like
    QA or Enterprise in my PC ,i can use this software manage my SQL Server on LAN.
    Right now another SQL server on WAN ,i dont know can i use QA to find
    SQL server or I have to get some remote software to log on remote server
    and use remote server's QA?

    Do i make me clearly?

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Now I understand the question better!

    When you are making the connection to the server in Query Analyzer, type either the server's name or IP address into the box labled SQL Server. Except for the lack of ability to enumerate remote servers (having Query Analyzer locate the SQL Servers and provide a list of them for you), the connection process is exactly the same as a "local" SQL Server.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •