Post reply

explain how to make the database accessible to the outside world

  • July 14, 2008 at 2:38 am

    #126449

    Hi,

    Can anyone explain me to make the sqlserver database to the outside world.

  • July 14, 2008 at 4:04 am

    #842273

    Could you explain a bit more what you want? I'm not sure I understand your question.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 14, 2008 at 4:08 am

    #842274

    Hi,

    I want to access my local database through internet.

    Moreover i want to connect my database out of lan network

  • July 14, 2008 at 4:12 am

    #842277

    That very much depends on yout network infrastructure, not so much SQL. You may want to ask your network people about that

    Is the SQL server in an internet-facing portion of your network? Is there a firewall in place (very likely)? Do your company's IT policies allow access to their SQL Servers from the internet?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 15, 2008 at 6:46 am

    #843038

    Gail is right and also you need to make sure the SQL Browser service is started.

    Att,

  • July 15, 2008 at 7:00 am

    #843056

    Be very careful making your data base available to the outside world it will open the proverbial can of worms ... look at all the posting on SQL injection attacks, theft of data, modification / deletion of data. If your database contains employers data get your supervisors permission.

    With all that said review Security. When you think you have the best security in the world review it again and then again

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 15, 2008 at 7:09 am

    #843071

    If you mean INTERNET, do you mean working through a VPN. (not for external users).

    Again, whatever your thoughts, Talk to your infrastructure(Network / Security) Team. (if you have one).

    If this is the basic case of a standalone Database server managed by you.. Well you need to have a dedicated IP and Protocols enabled and working, in place and try connecting through that IP from your SSMS. There are and can be many more methods for access.. but think about security and other Questions/concerns some users have posted.

    Maninder
    www.dbanation.com

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

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