Post reply

SQL Server 2008 Developer Edition easy question

  • May 14, 2009 at 7:22 pm

    #204802

    Does SQL Server 2008 Developer Edition allow for the remote connection to sql databases on remote servers such as DB that reside on Network Solutions?

    And allow for creating tables, data manipulation etc. Sorry I've been a PHP/MySql developer for many years and am now venturing out into the windows world.

    Also I am running Windows XP SP2 (uninstalled SP3 after a million failed attempts at installing SQL Express 2005 and 2008)

  • May 14, 2009 at 7:44 pm

    #995004

    this is actually a question for Network Solutions...if they expose their SQL Server to allow you to connect directly, then yes.

    If it is hidden behind a firewall, then no.

    I have two different web accounts,one with GoDaddy and another with IhostAsp;

    neither allow direct access, and instead provide Microsoft's Sql Web Data Administrator, which is a suite of web pages which replaces and emulates the GUI interfaces you might be used to.

    my login which they give me allows me to connect to just "my" database, although i have read access to master.

    edit and correction: Only my GoDaddy account is using the web interface; my ihostasp account allows me to connect directly, but on a different port. i just checked, and i can see all the databases on the server, can't edit any of them except my own, though. so there might be a chance you can connect directly.

    i doubt it is exposed, but I'm sure it's in their hosting FAQ somewhere.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 15, 2009 at 7:25 am

    #995307

    Yes it does but SQL Server the Developer edition and Express comes with most features disabled by default, so you need to enable both local and remote connection, both TCP/IP and named pipes in configuration manager before you can do remote connection. The link below is for SQL Server 2005 so there is no surface area configuration tool in 2008 so all you need to do is in configuration manager.

    http://support.microsoft.com/kb/914277

    Kind regards,
    Gift Peddie

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

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