Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Connection Stri...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 10958 of 11265
Post > Topic >>

Connection String on shared server- Almost there but need a little

by DanWeaver <danofweaver@[EMAIL PROTECTED] > Apr 13, 2008 at 08:52 AM

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

will try this on asp group too.
 




 1 Posts in Topic:
Connection String on shared server- Almost there but need a litt
DanWeaver <danofweaver  2008-04-13 08:52:32 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 25 5:25:06 CDT 2008.