Re: How do I use sp_configure 'user instances enabled'
- From: "Henry Stock" <henry@xxxxxxxxxxxxxxx>
- Date: Thu, 5 Jun 2008 23:01:11 -0400
This is the entire error message...
System.Data.SqlClient.SqlException was unhandled by user code
Message="Generating user instances in SQL Server is disabled. Use
sp_configure 'user instances enabled' to generate user instances."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=14
LineNumber=65536
Number=15383
Procedure=""
Server=".\\SQLEXPRESS"
State=1
StackTrace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject)
at
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host,
String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection
connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables,
Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at NorthwindTableAdapters.ProductsTableAdapter.GetProducts() in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\aspnet
data tutorial 2 cs\2904722d\cf7db375\App_Code.pccbckdr.5.cs:line 2678
at ProductsBLL.GetProducts() in d:\Projects\ASP.NET 2.0
Tutorials\ASPNET Data Tutorial 2 CS\App_Code\BLL\ProductsBLL.cs:line 29
at AllProducts.Page_Load(Object sender, EventArgs e) in
d:\Projects\ASP.NET 2.0 Tutorials\ASPNET Data Tutorial 2
CS\AllProducts.aspx.cs:line 18
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object
sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
"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: How do I use sp_configure 'user instances enabled'
- Next by Date: Re: How do I use sp_configure 'user instances enabled'
- Previous by thread: How do I use sp_configure 'user instances enabled'
- Next by thread: Re: How do I use sp_configure 'user instances enabled'
- Index(es):
Relevant Pages
|
