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