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/ManageConsolidatedProviders.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:<br />
<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>
......
