Re: How do I use sp_configure 'user instances enabled'
- From: "Rick Byham, \(MSFT\)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 6 Jun 2008 07:47:26 -0700
Did you RECONFIGURE?
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'user instances enabled', 1;
GO
RECONFIGURE;
GO
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Henry Stock" <henry@xxxxxxxxxxxxxxx> wrote in message news:O5Uz7S3xIHA.2384@xxxxxxxxxxxxxxxxxxxxxxx
I am trying to connect to a demo version of the Northwind.mdf database file that goes along with a Microsoft tutorial on ASP.NET
I have a running version of SQL SERVER Express on my system and whether I try to attach to the database file using Server Managment Studio Express or through Viusal Studio 2005 pro I am getting the same error message:
Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
I have tried to run this command from the server managment studio from a script window'
sp_configure 'user instances enabled'
The result say query executed successfully
name users instances enabled Minimum 0 Maximum 1 Config_value 0 run_value 0
But I STILL cannot connect to or attach this database file
So my question is what am I doing wrong? I can't use a database that I can't attach to the server, and I can attach the database file to the server until O figure out what the hell the dammed message is telling me.
Asking for help!
Sincerely Henry Stock henry@xxxxxxxxxxxxxxx
.
- References:
- How do I use sp_configure 'user instances enabled'
- From: Henry Stock
- How do I use sp_configure 'user instances enabled'
- Prev by Date: Re: How do I use sp_configure 'user instances enabled'
- Next by Date: Re: Unable to Generate SSPI Context w/ .Net 2.0 App and Windows 2000 Professional Client
- Previous by thread: Re: How do I use sp_configure 'user instances enabled'
- Index(es):
Relevant Pages
|
Loading
