Jeg har brug for at bruger MemberShip klassen, derfor har jeg tilføjer en app.config fil hvori jeg har angivet en connectionstring...men når jeg kører programmet får jeg følgende fejl...
"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."
"ved System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)\r\n ved System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)\r\n ved System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString)\r\n ved System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)\r\n ved System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)\r\n ved System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)\r\n ved System.Web.Security.SqlMembershipProvider.GetUser(String username, Boolean userIsOnline)\r\n ved System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)\r\n ved System.Web.Security.Membership.GetUser(String username)\r\n…
Har googlet denne:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3964738&SiteID=1 Men kan ikke få det til at virke, har du en ide til hvad det kan være?
min app.config ser således ud:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="ScannetCS" connectionString="Server=XXXXXX; Database=XXXXXX; User ID=XXXXXX; Password=XXXXXX; User Instance=False;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<membership defaultProvider="AspNetSqlMembershipProvider" userIsOnlineTimeWindow="15" >
<providers>
<clear />
<remove name="AspNetSqlMembershipProvider"/>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="ScannetCS" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="false" applicationName="/" requiresUniqueEmail="true" passwordFormat="Encrypted" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
</providers>
</membership>
</system.web>
</configuration>