Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: Alternative for user instance login flag ?

Thread Tools

Re: Alternative for user instance login flag ?

Mel Weaver
Posts: n/a
I copied this from somewhere but forgot where

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 configuration in your project.

define your users and roles.

"SnapDive" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have SQL Server 2008 Developer Edition only installed on development
> PC, have 2008 Standard Edition on the production server. The DBAs have
> the production environemnt locked-down.
> I created a VS.NET 2008 web application and setup a MDF to use my Dev
> Edition DB instance. When I run the app, I try to connect and get
> "
> The user instance login flag is not supported on this version of SQL
> Server. The connection will be closed.
> "
> I understand that only SqlExpress supports this functionality. The
> professional DBAs are not going to let me just install another
> instance on the DB farm. So what is a good workaround or technology to
> use something like user instances on Dev Edition and Standard Edition?
> Thanks.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Failed to generate a user instance of SQL Server. Only an integratedconnection can generate a user instance. Harlan Messinger ASP .Net 2 03-28-2010 06:51 PM
Cannot open user default database. Login failed. Login failed for user 'HEMPC\ASPNET' Tony Johansson ASP .Net 3 01-02-2010 04:09 PM
Failed to generate a user instance of SQL Server due to a failure instarting the process for the user instance. The connection will be closed Homer ASP .Net 1 05-26-2009 12:36 AM
Setting "User Cannot Change Password" Flag from ASP.NET/C# John Beard ASP .Net 1 09-06-2006 06:07 PM
Quicktime Alternative, RealPlayer Alternative & Media Player Classic John Capleton Computer Support 3 12-05-2005 07:41 AM