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

Question

 

Hi

while i am connecting to the database and querying in my Win. App,, i am getting following Error.

 

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

 

Thanks

 

parth

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.

May be following thread will help you

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=609077&SiteID=1

Answer 2

if you have sql server2008 developer edition :

 

1)create "aspnetdb" database with "aspnet_regsql" in vs command prompt.

2)find location of " aspnetdb.mdf" and " aspnetdb_log.ldf " files with right click on database name in mss management studio.

3)stop sqlserver service.

4)copy two files .mdf and .ldf in App_Data folder of your site.

5)start sqlserver service.

6)attach aspnetdb database from files to sqlserver.

6)chang in machine.config file instance to false:instance=false.

7)press asp.net configuration in your project.

8)define your users and roles.

 

make sure to create ur website project in "C:\Documents and Settings\username\My Documents\Visual Studio 2008"

 

roozbeh noroozy GIS Developer in IRAN -Tehran: [e-mail]

 

with thanks from:

sanjitpatel :  http://forums.asp.net/p/1090491/2802641.aspx#2802641

and

thomassamson :  http://forums.asp.net/t/913172.aspx?PageIndex=2