hosted web server to access db servre on our network

microsoft.public.dotnet.framework.adonet

28 Mar 2006 11:28 AM

steven scaife

We have a hosted server and i have developed an ASP.net applciation that uses
this backend i have tested it and its ready for deployment on the hosted
server. However i cannot get it to see the server.

I have had this working with an ASP application, the .net application has
been redeveloped to take advantage of its features, and has had some new
features implemented so the old ASP app is no good now.

I use a ipaddress and port for the server eg. 192.168.1.2:9800

my connection string looks like

New SqlConnection("Data Source=192.168.1.2:9800;Initial
Catalog=Database;User Id=username;Password=password;")

obviously i have changed it. I have also tried with integrated security but
there is no corresponding account so it wont accept it. I have tried
impersonate user whihc is what i have to do in the office but it doesn't
recognise the domain\username on the webserver so errored when i had that in
my web config.

I have tried everything i know and have run out of ideas can someone offer
some advice please, if you need any more information please let me know

cheers