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.
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
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: email@example.com
with thanks from:
sanjitpatel : http://forums.asp.net/p/1090491/2802641.aspx#2802641
thomassamson : http://forums.asp.net/t/913172.aspx?PageIndex=2
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?