User login flag is not supported in this version of sql server

I created an Asp.net site using VS 2008 and SQL Express 2008 on one PC. with db files in | Data Catalog |.
When I copied these website files to another computer (having the same VS 2008 and SQL Express 2008), it gave me an error
with the login flag for a user instance not supported in this version of SQL Server

+3
source share
2 answers

Are you 100% sure that the new environment is really Express?

If so, you may need to configure the server to connect user instances. If you have administrator access, you can run this command.

-- Enable user instances.
sp_configure 'user instances enabled','1' 

-- Disable user instances.
sp_configure 'user instances enabled','0'

http://msdn.microsoft.com/en-us/library/ms254504.aspx

, SQL Server ( -) " " (.. / ) . SQL Server Express.

+4

, User Instance=true;

+4

Source: https://habr.com/ru/post/1749853/


All Articles