sp_configure 'user instances enabled'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Billy B - 30 Mar 2007 04:36 GMT

I am not sure whether this should be posted on VB.net group or here but here
goes. I am creating a VB2005.net project using Express Edition SQL Server
database. When I try to make the connection to the db I get an error telling
me the user instance needs enabled. I have found the following command to use
but have not been able to find out where I go to input the command or enable
it: sp_configure 'user instances enabled'

Can someone point me in the right direction? Thank you.

Reply to this Message

Andrew J. Kelly - 30 Mar 2007 15:24 GMT

http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8
-5a0f62bf7796&DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx
Backing up Express

I think the User Instances one has what you need but it is worth looking
over each if you are venturing into Express territory.

Signature

Andrew J. Kelly SQL MVP

>I am not sure whether this should be posted on VB.net group or here but
>here
[quoted text clipped - 8 lines]
>
> Can someone point me in the right direction? Thank you.

Reply to this Message