Re: sp_configure 'user instances enabled'
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Fri, 30 Mar 2007 10:24:01 -0400
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.
--
Andrew J. Kelly SQL MVP
"Billy B" <BillyB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48D270D3-FC1D-486A-8B13-AEA19E295C0E@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: guest User Activated?
- Next by Date: Re: SQL2005 Linked server authentication problem
- Previous by thread: guest User Activated?
- Next by thread: Re: add users in a transaction SQL Server 2000
- Index(es):
Relevant Pages
|
|