NET 2 - Membership og MSSQL-fejl
jeg har før spurgt om et relateret spørgsmål men er kommet lidt længere i min problemstilling.Det drejer sig om den famøse membership-klasse som jeg helt vildt gerne vil arbejde med. Når jeg har været i ASP.NET Configuration og database-filen er oprettet osv (altså aspnetdb.mdf) så skal jeg ha emigreret projektet til min host. Prepr.arbejdet - modificering af web.config så den overruler machine.config ser sådan her ud:
<connectionStrings>
<!--AspNetSqlMembershipProvider-->
<add name="ASPNETDBConnectionString" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf; " providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<membership>
<providers>
<remove name="AspNetSqlMembershipProvider" />
<add name="AspNetSqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="ASPNETDBConnectionString"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
applicationName="/"
requiresUniqueEmail="false"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="7"
minRequiredNonalphanumericCharacters="1"
passwordAttemptWindow="10"
passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<remove name="AspNetSqlProfileProvider" />
<add name="AspNetSqlProfileProvider"
connectionStringName="ASPNETDBConnectionString"
applicationName="/"
type="System.Web.Profile.SqlProfileProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</profile>
<roleManager>
<providers>
<remove name="AspNetSqlRoleProvider" />
<add name="AspNetSqlRoleProvider"
connectionStringName="ASPNETDBConnectionString"
applicationName="/"
type="System.Web.Security.SqlRoleProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
og sidste tilføjelse før spørgsmålet er at min host ikke har MSSQL-kørende i nogle afskygnninger.
Men når jeg så prøver skidtet af på hosten så fåkker det ud i en
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
"Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below."
... for mig virker det som om at MSSQL ikke kan startes og jeg skyder så på at det er fordi MSSQL ikke er installeret(?) - har jeg ret?
I såfald: findes der, lissom til mySQL en dll-fil jeg kan smide med over i projektet?
Og helt generelt: hvordan kan jeg løse problemet?