How do I use sp_configure 'user instances enabled'

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


.

Relevant Pages

  • Re: How do I use sp_configure user instances enabled
    ... Rick Byham, SQL Server Books Online ... 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. ...
    (microsoft.public.sqlserver.connect)
  • Need WAN/Branch OfficeSolution
    ... We are looking for the best recommendation for the following situation ... our server is Windows 2003 Standard Edition and it has network ... We have text documents & a database file for a program we ... currently sharing a cable Internet connection The workstations in BB ...
    (microsoft.public.windows.server.sbs)
  • Re: Hyperlink problem
    ... Did you change the extension to the database file - example: ... database.mdb to database.db as part of the upgrade? ... Adding the mime type to the server will be a better option. ... >>> user could download the file. ...
    (microsoft.public.frontpage.client)
  • Re: Attaching MDF with AttachDBFilename?
    ... The database file only needs to be attached one time -at the server. ... Clients only need to connect to the server and have access to the database. ...
    (microsoft.public.sqlserver.connect)
  • Re: KB960089 Breaks Sharepoint Services Web Sites
    ... removes the "Network Services" user from the permissions list for the Windows ... go to that database file as well as it's associated log file. ... security and removed the Network Services user from both the Windows Internal ... Sql server service does not wants to run. ...
    (microsoft.public.windowsupdate)
Loading