Re: Membership Provider



Hi Denn,

You need Sql 2005 for dynamic database attachment ("Registration") to the
server.

Best Regards,
Parag.

"DenniLi" <DenniLi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D389D631-97F8-4EA5-BBE6-DE4B52BE27A5@xxxxxxxxxxxxxxxx
I have a perfectly working aspnet v2 website on my local machine with the
following connection strings:
<connectionStrings>
<add name="ClubSiteDB" connectionString="Data
Source=.\SQLExpress;Integrated Security=true;
AttachDBFileName=|DataDirectory|Club.mdf;
User Instance=True" providerName="System.Data.SqlClient"

<add name="LocalSqlServer" connectionString="Data
Source=.\SQLExpress;Integrated Security=True;
User
Instance=True;AttachDBFilename=|DataDirectory|ASPNET.mdf"
providerName="System.Data.SqlClient" />
/>
</connectionStrings>

when i upload it to my remote web host with SQL 2000, it doesnt work. I
called the support and said just
restore the database. i use sql server mgmt studio but it wont restore or
attach the dbs. DO i need a sql 2005
server on the remote to able to attach the sqlExpress. do i need to copy
each tables (I tried and it give s error).

i have a simpler pages develop using access mdb drag and drop located in
the
app_data folder and it is working like magic.
i am used to asp.net 1.x where even there is some code needed, i have the
sql server ready even without the
app_data folder and just connect direct to sql 2000. Is there something
wrong in how i utilize the
above connection string or the app_data folder? How can i deploy the
aspnetdb.mdf on my remote sql 2000
only capable web host so i can use the new membership features in v2? I
have some aspnet 2 books and all samples
work except no sample on deploying to a remote server.
Can someone please enlighten me with my ignorance? thanks a lot.


.



Relevant Pages

  • SQL 2005 Express Connection Problem
    ... The remote site is not a company ... this remote site and try to log in I get this error: ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central o
    ... Looking for a SQL Server replication book? ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2005 Express Connection Problem
    ... sql2005 support auto attaching a database in the connect string. ... The remote site is not a company ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: C# - connection to a remote SQL server
    ... remove server ... want to authenticate with trusted auth or sql auth. ... storing a token for access to the remote pc. ... understand a lot about nt authentication and tokens. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Variable server names
    ... My initial desire was to do this in a single stored proc. ... Then I realized that mixing dynamic SQL and a table variable was going ... executing the remote from the local. ... but I understood it as management wanted to connect to a server ...
    (microsoft.public.sqlserver.programming)