«

I have been running and testing stuff ok on my dev machine, but have been
forced to consolidate my databases at my hosting company - i created a db
there, and i ran the aspnet_regsql wizard. I filled that out, and sure enough
i created the tables etc on my remote database.

What i dont know and cant seem to understand or figure is how or where i
tell the system what db these tables are on; i have googled around a little
and cant find the answer - i am sure i need to do something simple.

When i run a createuser wizard and hit the button the system throws up an
error (i cant see the error, it drops me to a standard error page); i presume
the reason is that .net doesnt know the location of the login info.

Please help.

Hey

This took me awhile to find as well... add this to your config:

<connectionStrings>

<remove name="LocalSqlServer" />

<add name="LocalSqlServer" connectionString="Data Source=IP_ADDRESS;Initial
Catalog=DATABASE;Integrated Security=True"
providerName="System.Data.SqlClient" />

</connectionStrings>

That should help... this area doesn't seem to be well documented.


"Owen Richardson" <> wrote in
message news:66EEA4D4-5BE9-4A86-8FCE-...
>I have been running and testing stuff ok on my dev machine, but have been
> forced to consolidate my databases at my hosting company - i created a db
> there, and i ran the aspnet_regsql wizard. I filled that out, and sure
> enough
> i created the tables etc on my remote database.
>
> What i dont know and cant seem to understand or figure is how or where i
> tell the system what db these tables are on; i have googled around a
> little
> and cant find the answer - i am sure i need to do something simple.
>
> When i run a createuser wizard and hit the button the system throws up an
> error (i cant see the error, it drops me to a standard error page); i
> presume
> the reason is that .net doesnt know the location of the login info.
>
> Please help.
>

Thanks Hayden!