Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 26th, 2007, 05:51 PM
Authorized User
Join Date: Oct 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Express User Instance...avoiding


Newbie here! I've lurked before but just now signed up. Great site and forum.

I bought the book "ASP 2.0 Security" and have been reading about SQL and SQL Express. It's a very good book and I've learned a lot from it.

I'd like to know if you can tell me how to use a connectionString that DOES NOT utilize "user instances". Also can you tell meything else I might need to know for attaching a membership database.

I've been using SQL Express for a while and am fairly familiar wit it.

I want to run two membership site databases (ASPNETDB.mdf) created with VWD Express on one "SQL Express Instance" and avoid the memory overhead and security issues of "user instances".

Many Thanks

Old October 27th, 2007, 10:12 PM
Authorized User
Join Date: Oct 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

Hi again,

I solved the problem by attaching the APSNETDB.MDF file in SSMSE and adding a SQL Authenticated login which I'm using to connect.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Failed to generate a user instance of SQL Server naeem.net SQL Server 2005 3 December 11th, 2009 02:45 PM
User Instance=True dpkbahuguna ASP.NET 3.5 Professionals 6 January 22nd, 2009 11:02 AM
SQL user instance error ckerin BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 April 28th, 2008 12:30 AM
C# and SQL express 2005, multi-user access ?? Boudy C# 2005 4 February 27th, 2007 04:43 AM
Accessing a SQL Server Express DB thru VB Express djelavic SQL Server 2005 2 February 21st, 2006 07:53 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.