none
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

    Wednesday, November 05, 2008 6:15 AM

Answers

All replies

  •  

    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

    Wednesday, November 05, 2008 1:00 PM
    Moderator
  • 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: roozbeh.n@live.com

     

    with thanks from:

    sanjitpatelhttp://forums.asp.net/p/1090491/2802641.aspx#2802641

    and

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

    Friday, December 12, 2008 1:40 AM