If you don't already have it, install the SQL Server 2008 Client access tools.

I would be surprised if the host has not allowed remote access to the server. I mean, they are hosting.

And then make sure your firewall & proxy server allow you to go through port 1433

On Mon, Jan 18, 2010 at 10:42 AM, Ouya Obunga <write2ogush@gmail.com> wrote:


@Rad!

ASP.NET 2.0 and SQL Server 2008, all supported by the web host. Im not able to connect the database remotely. Apparently, my Sql server does not have a client network utility for setting up remote access to the web server. A friend tells me to use sql server 200. I want a connection first to the remote server then upload the run the sql script.
 

----------------------------------------------------------------------

Message: 1
Date: Mon, 18 Jan 2010 09:42:19 +0300
From: "Rad!" <conradakunga@gmail.com>
To: Skunkworks Forum <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] MS Sql Server
Message-ID:
       <911107611001172242v6c1318edk6968ee67bb7e0621@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

More information!


  - What version of ASP.NET
  - Does the host support the above?
  - What version of SQL Server
  - Does the host support the above?
  - Can you connect to the database remotely?
  - Have you been able tup upload the database data?
  - What error messages are you getting?


On Mon, Jan 18, 2010 at 9:32 AM, Ouya Obunga <write2ogush@gmail.com> wrote:

> I have a ASP.Net web application with a sql server backend. I have
> successfully uploaded the .Net files. I have issues with taking sql server
> to the web hosting server. I have tried to use client network utility and
> since im new to sql server, I would like some input.
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
> Skunkworks Server donations spreadsheet
>
> http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
> ------------
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
> Other lists
> -------------
> Announce:
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
> Science:  http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
> kazi:     http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
>





_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
Other lists
-------------
Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science:  http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi:     http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general