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 serv
er explorer and tried to create a new data connection,
filled in the database server, uid, password and database name but was not a
ble 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 li
ke to make some data sets and populate them with data
from the online database.
Thanks,
Max.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 w
hich 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 se
rver 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.
>