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

Question

Hi I am using sql server fulll edition.

any idea how should I solve this issue, I search on net but not found any helpful answer.

Thanks

Answer 1

SQL Server 2005(Full Version) does not support the "user instance"(automatic creation of databases from code) directive in the connection string. Its a feature of sql server express edition.

Also if your connection string has user Instance attribute, then try removing the "User Instance=True;"

Answer 2

Automatic creation of databases from code is a feature of the SQL Express Edition. Try modifying your connection string after having manually created the FOO database:

server=SERVERNAME;database=FOO;uid=sa;pwd=

Answer 3

User instancing is a feature of Sql Express only and is not available in full Sql Server. You need to construct your connection string to point at the DB server without any USer Instancing defined