By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Login Seems OK but doesn't behave correctly

P: n/a

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

Using MS SQL server on a shared host ( 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 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...

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

....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)?

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."
* 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

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

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

logged in as:<br />
<asp:LoginName ID="LoginName1" runat="server" />

<form id="form1" runat="server">
<asp:Login ID="Login1" runat="server" CreateUserText="new un"
CreateUserUrl="~/newuser.aspx" DestinationPageUrl="~/
Jun 27 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.