How to Access SQL Database Over the Web

  • "SQL instance purchased and running out in the "cloud" somewhere."

    As you said its in the cloud

    The below link would help ful for you I guess to manage your server.

    http://www.mssqltips.com/tip.asp?tip=2295&home

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • I've been reading about SQL Azure for an hour now. It seems like, since my company already has purchased SQL Server databases out on the net somewhere that we can administer, that we could simply open that server up to ONLY traffic in the IP range from the client's office and it will be alot like SQL Azure anyway..... yeah?

  • it's not that hard to pretend you're coming from a specific address (called IP spoofing). It's a sad statement of affairs , but there's a fair amount of shareware which will do a rudimentary job of just that for under 50$.

    So - while it can be of some help, it's certainly not foolproof. You STILL should have some authentication and authorization, and some form of encryption (i.e. you can't even talk to me unless you're encrypting according to my keys, etc...), and something scanning whatever is being run to be sure it's safe, and appropriate.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 3 posts - 16 through 18 (of 18 total)

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