SimpleMembershipProvider WebSecurity.InitializeDatabaseConnection does not work with an empty sql database

Question

I just added sqlserver connection string. new new database. I checked the connection perfectly on the server explorer.

<add name ="club" connectionString="Data Source=server1;Initial Catalog=temp;Integrated Security=True"/> 

Then name it in InitializeSimpleMembershipAttribute as follows

 WebSecurity.InitializeDatabaseConnection("club", "Users", "UserID", "UserName", autoCreateTables: true); 

It works in an sdf file and creates tables. But crash with sql server. Has anyone seen this error before and can explain what is happening?

Error -

Keyword not supported: "start directory". Exception Details: System.ArgumentException: Keyword Not Supported: "Start Directory".

Answer 1

Add providerName="System.Data.SqlClient" to the connection string.

 <add name="club" connectionString="Data Source=server1;Initial Catalog=temp;Integrated Security=True" providerName="System.Data.SqlClient"/>