Post reply

How to access my MS SQL server 2000

  • June 7, 2005 at 12:56 am

    #89386

    Hi to all,

    I just want to ask you guys, if theres a way to access my db server outside my company network. because I have one (1) server for database and web application (db and web apps in one machine)

    Here are the server info:

    database: ms sql server 2000 standard edition.

    IIS: IIS 5

    Note: This server has a live public IP address and has www domain for web application.

    And I just like to ask if theres a way to access my database directly outside my company network using internet connection or any other connection? and if theres a way how can I access it? and how can prevent it to secure my database from other unauthorized person?

    Thanks in advance. 

    Best Regards,

    Arnold (Philippines)

  • June 7, 2005 at 1:55 am

    #563410

    You can download SQL WEB Data Admin from Microsoft.

    Regards

    -Deni-

  • June 7, 2005 at 2:15 am

    #563415

    If there is no firewall restricting access to the server then yes, anyone can access it from the internet. They will of course need to login as usual, but that is probably the least problem for a hacker. To prevent this you should have a firewall blocking all outside access to the server except for port 80 which I assume your web application uses.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • June 7, 2005 at 4:37 am

    #563436

    Thanks guys,

    Thanks for immediate reply. OK, let me explain, I want my server accessed by authorized person, like "sa" login only can access. can some body help me or teach me how to access my server via internet? beacuse I think this the only way for me to access it if im not in the office or if im in out of town.

    Thanks alot.

    Best Regards,

    Arnold

  • June 7, 2005 at 4:45 am

    #563437

    The best way is to block access to the server using a firewall like I said, and then opening for SSH or similar. That way you can get a secure connection into the server. Another way is to only open access to SQL Server for your specific ip address.

    Check out SQLSecurity.com, where you will find a ton of information on how to secure your server.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • June 8, 2005 at 3:10 am

    #563756

    You can access Remote Sql Server by using public IP address of the server over Internet.

  • June 8, 2005 at 5:13 am

    #563766

    A secure method would be to have a VPN key to connect to your network from home.  Then your pc would be connected directly to the network.  The other methods offer security vulnerabilites.

Viewing 7 posts - 1 through 6 (of 6 total)

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