Prev: Image Handling
Next: modify default xml sitemap provider to allow images
From: SnapDive on 28 Apr 2010 14:41

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.
From: Mel Weaver on 28 Apr 2010 16:46
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 asp.net configuration in your project.

8) define your users and roles.


"SnapDive" <SnapDive(a)community.nospam> wrote in message
news:b60ht5pcn8scvqbilm44l5fv35pcifn3cs(a)4ax.com...
>
> 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.

 | 
Pages: 1
Prev: Image Handling
Next: modify default xml sitemap provider to allow images