+ Reply to Thread
Results 1 to 3 of 3

Connect to online webhost MS SQL database

  1. Connect to online webhost MS SQL database

    Hello,

    I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
    this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
    filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
    not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
    from the online database.

    Thanks,
    Max.


  2. RE: Connect to online webhost MS SQL database

    Hi

    In general I would not expect you to work on a live database in this way! I
    would expect any changes to use a local copy to be developed and tested
    before going live. The live upgrade can either be packaged as scripts or a
    backup to be implemented on the live system. This would help prevent you
    implementing bad code and causing system problems by developing on live. You
    should also be able to implement source code control and have roleback
    strategies for any release.

    Your host should provide tools to manage/upgrade the database.

    John

    "Max" wrote:

    > Hello,
    >
    > I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
    > this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
    > filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
    > not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
    > from the online database.
    >
    > Thanks,
    > Max.
    >
    >


  3. RE: Connect to online webhost MS SQL database

    Hi

    In general I would not expect you to work on a live database in this way! I
    would expect any changes to use a local copy to be developed and tested
    before going live. The live upgrade can either be packaged as scripts or a
    backup to be implemented on the live system. This would help prevent you
    implementing bad code and causing system problems by developing on live. You
    should also be able to implement source code control and have roleback
    strategies for any release.

    Your host should provide tools to manage/upgrade the database.

    John

    "Max" wrote:

    > Hello,
    >
    > I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
    > this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
    > filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
    > not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
    > from the online database.
    >
    > Thanks,
    > Max.
    >
    >


+ Reply to Thread