Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: Login Seems OK but doesn"t behave correctly

Posted on 2008-04-17 00:42:04 by DanWeaver

Hi,

Any pointers much appreciated- I just don't know how to progress from
here.

Using MS SQL server on a shared host (www.joglab.com shows the
problem) I am having a problem with logins- login appears to work and
is registering in the members database (also on a shared server) as a
login but not behaving on the pages ie LoginView/ Login Status not
functioning (behaves as if no user is logged in).
I hope this is an appropriate forum for this question- I have tried on
asp.net too but to no avail so far- this problem may be due to the way
I am treating my MSSQL db.

The code for the pages is below but Im not sure which code is germane.
I have written absolutely no vb/c code- just trying to sort out the
basic login behavior first.
The only thing Ive changed in web.config (from standard visual web
developer startup) in web.config is the connection string...

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

....the rest of the web.config file is standard as created by Visual
Web Developer 2008.
Is it to do with Integrated Security=false (*see below)?

OTHER INFO...
When I hit 'test' AspNetSqlProvider in the providers section of the
Web Site Administration Tool I get "Could not establish a connection
to the database."
http://localhost:50812/asp.netwebadminfiles/providers/Manage ConsolidatedProviders.aspx
* If I set Integrated Security=false on logging in I get:
Login failed for user ''. The user is not associated with a trusted
SQL Server connection

Default.aspx
......
<form id="form1" runat="server">
<asp:LoginStatus ID="LoginStatus1" runat="server" />

<asp:LoginView ID="LoginView1" runat="server">
<LoggedInTemplate>
Logged in indeed
</LoggedInTemplate>
<AnonymousTemplate>
Not logged in ok
</AnonymousTemplate>
</asp:LoginView>

logged in as:

<asp:LoginName ID="LoginName1" runat="server" />
</form>
......

Login.aspx
......
<form id="form1" runat="server">
<asp:Login ID="Login1" runat="server" CreateUserText="new un"
CreateUserUrl="~/newuser.aspx" DestinationPageUrl="~/
Default.aspx">
</asp:Login>
</form>
......

Report this message