Login Functionality Almost working but not quite- connection string?



Using asp and SQLserver2005 on shared server and with connection
string:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data
Source=HYDROGEN;Initial Catalog=dbred;Integrated Security=false;User
Id=theuser;Password=blahblah;" providerName="System.Data.SqlClient" />
</connectionStrings>

I am accessing the db from a page on the shared server - and trying to
use the login features of visual web developer...
I can create a new user, and login (it seems to work as I cannot login
as none registered user).
However- views do not work ie a user is directed to default page on
continue but is not recognised as being logged in- views dont function
correclty and option to login is offered etc.
Is it something to do with integrated security = false? The login
feature didnt work at all when I had it set to true (working from this
great blog:
http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx)

Any help appreciated- feel like Im almost there but would love to see
it working!

ps- here is the dafault page that logged in users are returned to:

<asp:LoginView ID="LoginView1" runat="server">
<LoggedInTemplate>
Logged in as :<asp:LoginName ID="LoginName1" runat="server" />
<br />
<br />
&nbsp;<asp:LoginStatus ID="LoginStatus2" runat="server" />
</LoggedInTemplate>
<AnonymousTemplate>
<asp:LoginStatus ID="LoginStatus1" runat="server" />
<br />
<br />
<a href="CreateNew.aspx">CreateNew.aspx</a>
</AnonymousTemplate>
</asp:LoginView>

posted also to sql newsgroup.
.



Relevant Pages

  • Login Seems OK but doesnt behave correctly
    ... Using MS SQL server on a shared host (www.joglab.com shows the ... login but not behaving on the pages ie LoginView/ Login Status not ... Web Site Administration Tool I get "Could not establish a connection ... <LoggedInTemplate> ...
    (comp.databases.ms-sqlserver)
  • Connection String on shared server- Almost there but need a little help
    ... Using asp and SQLserver2005 on shared server and with connection ... I am accessing the db from a page on the shared server - and trying to ... I can create a new user, and login (it seems to work as I cannot login ...
    (comp.databases.ms-sqlserver)
  • Re: Industry Standard Security and guest wifi access best practice
    ... usage policy and a login screen. ... Connection is simple for the end user and requires no VPN client ... Wireless subnet roaming would be really nice as well. ... implementing 802.1X as the complexity in supporting tennants would ...
    (alt.internet.wireless)
  • Re: Industry Standard Security and guest wifi access best practice
    ... usage policy and a login screen. ... Connection is simple for the end user and requires no VPN client ... Wireless subnet roaming would be really nice as well. ... implementing 802.1X as the complexity in supporting tennants would ...
    (alt.internet.wireless)
  • Industry Standard Security and guest wifi access best practice
    ... usage policy and a login screen. ... Connection is simple for the end user and requires no VPN client ... login pages (Authentication and then VPN) which would be necessary it I ... implementing 802.1X as the complexity in supporting tennants would ...
    (alt.internet.wireless)

Loading