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...
<connectionStri ngs>
<remove name="LocalSqlS erver"/>
<add name="LocalSqlS erver" connectionStrin g="Data
Source=HYDROGEN ;Initial Catalog=thedb;I ntegrated Security=false; User
Id=blahuser;Pas sword=blahdebla h;"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>
....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' AspNetSqlProvid er in the providers section of the
Web Site Administration Tool I get "Could not establish a connection
to the database."
* 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:LoginStatu s ID="LoginStatus 1" runat="server" />
<asp:LoginVie w ID="LoginView1 " runat="server">
<LoggedInTempla te>
Logged in indeed
</LoggedInTemplat e>
<AnonymousTempl ate>
Not logged in ok
</AnonymousTempla te>
</asp:LoginView>
logged in as:<br />
<asp:LoginNam e ID="LoginName1 " runat="server" />
</form>
......
Login.aspx
......
<form id="form1" runat="server">
<asp:Login ID="Login1" runat="server" CreateUserText= "new un"
CreateUserUrl=" ~/newuser.aspx" DestinationPage Url="~/
Default.aspx">
</asp:Login>
</form>
......
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...
<connectionStri ngs>
<remove name="LocalSqlS erver"/>
<add name="LocalSqlS erver" connectionStrin g="Data
Source=HYDROGEN ;Initial Catalog=thedb;I ntegrated Security=false; User
Id=blahuser;Pas sword=blahdebla h;"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>
....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' AspNetSqlProvid er in the providers section of the
Web Site Administration Tool I get "Could not establish a connection
to the database."
* 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:LoginStatu s ID="LoginStatus 1" runat="server" />
<asp:LoginVie w ID="LoginView1 " runat="server">
<LoggedInTempla te>
Logged in indeed
</LoggedInTemplat e>
<AnonymousTempl ate>
Not logged in ok
</AnonymousTempla te>
</asp:LoginView>
logged in as:<br />
<asp:LoginNam e ID="LoginName1 " runat="server" />
</form>
......
Login.aspx
......
<form id="form1" runat="server">
<asp:Login ID="Login1" runat="server" CreateUserText= "new un"
CreateUserUrl=" ~/newuser.aspx" DestinationPage Url="~/
Default.aspx">
</asp:Login>
</form>
......