Connection String on shared server- Almost there but need a little help
- From: DanWeaver <danofweaver@xxxxxxxxxxxxxx>
- Date: Sun, 13 Apr 2008 08:52:32 -0700 (PDT)
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/archive/2006/12/22/recipe-deploying-a-sql-database-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>
will try this on asp group too.
.
- Prev by Date: Re: difference between explicit inner join and implicit
- Next by Date: Re: SQL Assistance required
- Previous by thread: T-SQL Duplicate Record Help
- Next by thread: Secure Auditor, 30 security tools at the price of one.
- Index(es):
Relevant Pages
|