Login Functionality Almost working but not quite- connection string?

D

DanWeaver

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/arch...e-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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top