Google Analytics İzleme

05 Nisan 2012

Sql server - The user instance login flag is not supported on this version of SQL Server. The connection will be closed.

The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
hatasının nedeni:
User Instance özelliği sadece SQL Server Express sürümlerinde desteklenmektedir. Tam sürümlerde bu özellik desteklenmemektedir.

Connection string'de user instance kullanımı şu şekilde:
Data Source=.;AttachDbFilename=E:\ishak_opensource-projects\NerdDinner\nerddinner-70027\Branches\VS2010-MVC3-Razor\NerdDinner\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True

<add name="NerdDinners" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|NerdDinner.mdf;User Instance=true;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />


Kaynak:
http://softwarld.blogspot.com/2009/09/user-instance-login-flag-is-not.html
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/0738cb01-106f-4376-b92d-a977a022ece8/

Hiç yorum yok: