Users working in local DB but not in the remote one!

Forum to post any database related questions or issues: MS SQL, mySQL, MS Access, ...

Users working in local DB but not in the remote one!

Postby isafa » Sun Jun 27, 2010 12:08 pm

I'm using membership that created by asp.net configuration when you create users with roles when you create a user for your website using asp.net configuration in Visual Studio
Image


After uploading my project and creating the Database, I can't login using the users that i have created, i'm 100% sure im using the right username and password but still can't login but they are working 100% in my local DB

after few search in google i found the solution is to execute the following command:
Code: Select all
exec sp_configure 'user instances enabled', 1


I have contacted the support and they executed the command for me in my DB
But I still can't login

here is my web.config file
Code: Select all

<configuration>
   <appSettings/>
   <connectionStrings>
        <remove name="ConnectionString"/>
        <add name="ConnectionString" connectionString="Data Source=174.0.0.0;Initial Catalog=MyDBName;Persist Security Info=False;User ID=MyDBUserName;Password=DBPassword"
   providerName="System.Data.SqlClient" />
</connectionStrings>
   <system.web>
      <membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">
   <providers>
    <add connectionStringName="ConnectionString" requiresQuestionAndAnswer="false"
     minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0"
     name="SqlProvider" type="System.Web.Security.SqlMembershipProvider" />
   </providers>
  </membership>
      <roleManager enabled="true" />
      <compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
         <assemblies>
            <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
            <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

            </assemblies>
      </compilation>
      <pages theme="SkinFile" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
         <namespaces>
            <clear/>
            <add namespace="System"/>
            <add namespace="System.Collections"/>
            <add namespace="System.Collections.Generic"/>
            <add namespace="System.Collections.Specialized"/>
            <add namespace="System.Configuration"/>
            <add namespace="System.Text"/>
            <add namespace="System.Text.RegularExpressions"/>
            <add namespace="System.Linq"/>
            <add namespace="System.Xml.Linq"/>
            <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>

        <customErrors mode="Off"/>
       
      <authentication mode="Forms" />
   </system.web>
<system.net>
  </system.net>
</configuration>



Any help would be much appreciated
isafa
 
Posts: 5
Joined: Sat Jun 26, 2010 9:54 am

Re: Users working in local DB but not in the remote one!

Postby mafid » Mon Jun 28, 2010 5:01 am

Hi,
User instance configuration is not allowed as it is applicable for SQL Express Editions only.
There are several ways of making aspnet_regsql for SQL database locally and then restoring it on server

1. On local computer make aspnet_regsql.exe for sql database (e.g. aspnet_regsql.exe -S localhost -E -A all -d DATABASE_NAME)
2. Backup SQL database from SQL Management Studio locally
3. Upload SQL db on hosting space using FTP
4. Restore SQL database using Dotnetpanel


Do write us at support@dotnetpark.com for further assistance.

Regards,
Mafid
mafid
 
Posts: 60
Joined: Wed Mar 23, 2005 12:53 pm

Re: Users working in local DB but not in the remote one!

Postby isafa » Mon Jun 28, 2010 5:08 am

OK Thanks for reply I'll try today and update you

Thanks again
isafa
 
Posts: 5
Joined: Sat Jun 26, 2010 9:54 am

Re: Users working in local DB but not in the remote one!

Postby isafa » Wed Jun 30, 2010 5:35 pm

I did same as you said but unfortunately it did not work :(

any other ideas?
isafa
 
Posts: 5
Joined: Sat Jun 26, 2010 9:54 am

Re: Users working in local DB but not in the remote one!

Postby mafid » Sat Jul 03, 2010 6:49 am

Hi,
Please upload complete backup of your SQL database to your FTP root and email support@dotnetpark.com with details.
mafid
 
Posts: 60
Joined: Wed Mar 23, 2005 12:53 pm

Re: Users working in local DB but not in the remote one!

Postby isafa » Sat Jul 03, 2010 7:03 am

done
isafa
 
Posts: 5
Joined: Sat Jun 26, 2010 9:54 am

Re: Users working in local DB but not in the remote one!

Postby isafa » Sun Jul 04, 2010 4:07 pm

isafa
 
Posts: 5
Joined: Sat Jun 26, 2010 9:54 am


Return to Databases

Who is online

Users browsing this forum: No registered users and 0 guests

cron