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

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

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 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;”

Method 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=

Method 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

Method 4

User Instancing (which allows the automatic creation of databases from code) is not supported on the full version of SQL Server, only on the Express version.

The solution is to manually create the
database in SQL Server and set the
connection string to point to it. You
will also need to run
aspnet_regsql.exe manually against
the database if you will be using any
of the new built-in database features
of ASP.NET v2.0.

Ref.


All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x