ASP.NET membership db using integrated security problem
- by rem
I published ASP.NET MVC web site to a server on a virtual machine (Hyper-V). SQL Server Express installed on the same server.
The problem is that ASP.Net Membership system doesn't work in integrated mode. When Web.config file contains records as follows:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="MyDBConnectionString" connectionString="data source=vm-1\SQLEXPRESS;Initial Catalog=testdb;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
</connectionStrings>
I get an error when trying to register and login to the site.
If I change connection string this way:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="MyDBConnectionString" connectionString="data source=vm-1\SQLEXPRESS;Initial Catalog=testdb;User ID=XX;Password=XXXXXXX;" providerName="System.Data.SqlClient"/>
</connectionStrings>
I could register and login without any problem.
What could cause the problem with using ASP.NET membership database in integrated security mode?