PLS HELP!!!!!!!!!! MEMBERSHIP/ROLES(CAN'T USE LOGIN ACCOUNT ON HOST SERVER BUT WORKS ON LOCAL HOST)

Good day, please I am a first timer with hosting a sql2005 database , the problem is my roles do not work on the host server when i use my login account but it works on my local host.

here is the login details - username=sysdba
password=masterkey

url = http://dicon-ordfac.com/Login.aspx


below is my web.config file.



<configuration xmlns='http://schemas.microsoft.com/.NetConfiguration/v2.0'>
<appSettings/>

PLEASE NOTE: --this below is the connection string i used for the host server

<connectionStrings>
<remove name='LocalSqlServer'/>
<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k506.discountasp.net;Initial Catalog=SQL2005_489160_romiwa;User ID=SQL2005_489160_romiwa_user;Password=xxxxxxx;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True' providerName='System.Data.SqlClient' />
<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k506.discountasp.net;Initial Catalog=SQL2005_489160_romiwa;User ID=SQL2005_489160_romiwa_user;Password=xxxxxxx;Integrated Security=false' providerName='System.Data.SqlClient'/>

</connectionStrings>

PLEASE NOTE---this below is the connection string i used for my local server that works

<!--<connectionStrings>
<add name='RomiwaConnectionString' connectionString='Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ROMIWA.mdf;Integrated Security=True;User Instance=True' providerName='System.Data.SqlClient'/>
</connectionStrings>-->
<system.web>
<roleManager enabled='true' />
<compilation debug='false' strict='false' explicit='true'>
<assemblies>
<add assembly='System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35'/>
</assemblies>
</compilation>
<pages>
<namespaces>
<clear/>
<add namespace='System'/>
<add namespace='System.Collections'/>
<add namespace='System.Collections.Specialized'/>
<add namespace='System.Configuration'/>
<add namespace='System.Text'/>
<add namespace='System.Text.RegularExpressions'/>
<add namespace='System.Web'/>
<add namespace='System.Web.Caching'/>
<add namespace='System.Web.SessionState'/>
<add namespace='System.Web.Security'/>
<add namespace='System.Web.Profile'/>
<add namespace='System.Web.UI'/>
<add namespace='System.Web.UI.WebControls'/>
<add namespace='System.Web.UI.WebControls.WebParts'/>
<add namespace='System.Web.UI.HtmlControls'/>
</namespaces>
</pages>

<membership>
<providers>
<remove name='AspNetSqlMembershipProvider'/>
<add name='AspNetSqlMembershipProvider' type='System.Web.Security.SqlMembershipProvider' connectionStringName='LocalSqlServer' minRequiredPasswordLength='7' minRequiredNonalphanumericCharacters='0' passwordStrengthRegularExpression=''/>
</providers>
</membership>

<authentication mode='Forms'/>
<siteMap defaultProvider='XmlSiteMapProvider' enabled='true'>
<providers>
<add name='XmlSiteMapProvider' description='Default SiteMap provider.' type='System.Web.XmlSiteMapProvider ' siteMapFile='Web.sitemap' securityTrimmingEnabled='true'/>
</providers>
</siteMap>
</system.web>
</configuration>

Please I need your help urgently, u can email me on - [email protected], thank you and God bless as u help me.

 

Thanks for replying Mr. Bruce, I tried it and it would'nt work still.

Do I have to change the connection string in all of my web forms (presently:'RomiwaConnectionString') to 'LocalSqlServer'?

I don't have any idea on what to do, kindly help me with a solution to this problem, I can't access anyother page on my site other than the 'home' and 'login' pages. Please let me know if you need any necessary information from me.

Please reply, thanks.