Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Controls > cannot access sql server express

Reply
Thread Tools

cannot access sql server express

 
 
casper
Guest
Posts: n/a
 
      04-22-2006
Hi,

I use asp.net 2.0 and VWD on a windows 2000 server with IIS 5.0. This
computer is also the domain controler. The user who uses the aspx page is
the domain administrator. The aspx code is correct because it works when i
do F5 from VWD, but when i try to start the same page from the browser, i
get the error:

"failure of creation of sql server user instance ... Check that the user has
a local user profile on this computer .."

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Échec de la création
d'une instance d'utilisateur SQL Server en raison d'une défaillance
d'extraction du chemin d'accès aux données de l'application locale de
l'utilisateur. Vérifiez que l'utilisateur a un profil d'utilisateur local
sur l'ordinateur. Fermeture de la connexion.

Source Error:


An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.


Stack Trace:


[SqlException (0x80131904): Échec de la création d'une instance
d'utilisateur SQL Server en raison d'une défaillance d'extraction du chemin
d'accès aux données de l'application locale de l'utilisateur. Vérifiez que
l'utilisateur a un profil d'utilisateur local sur l'ordinateur. Fermeture de
la connexion.]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection) +734867

System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObjec
t stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean
enlistOK) +33

System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance) +628

System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentit
y identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) +170

System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOpti
ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection) +130

System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnec
tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)
+28
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+83

System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectAr
guments arguments) +1770
System.Web.UI.WebControls.BaseDataList.GetData() +53
System.Web.UI.WebControls.DataList.CreateControlHi erarchy(Boolean
useDataSource) +284
System.Web.UI.WebControls.BaseDataList.OnDataBindi ng(EventArgs e) +56
System.Web.UI.WebControls.BaseDataList.DataBind() +72
System.Web.UI.WebControls.BaseDataList.EnsureDataB ound() +55
System.Web.UI.WebControls.BaseDataList.CreateChild Controls() +63
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360





----------------------------------------------------------------------------
----

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42

Does it to do with the fact it's a DC and so the user is not a local user?
Any hints?
Thanks
Casper


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
SQL Server 2000 vs SQL Server Express Grey Alien ASP .Net 6 07-09-2007 09:40 AM
SQL Server 2005 + SQL Server Express farseer ASP .Net 3 08-08-2006 04:07 AM
cannot access sql server express casper ASP .Net 0 04-22-2006 04:03 PM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM



Advertisments