cannot access sql server express

Discussion in 'ASP .Net Web Controls' started by casper, Apr 22, 2006.

  1. casper

    casper Guest

    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.OnError(SqlException
    exception, Boolean breakConnection) +734867

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

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

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

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

    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnec
    tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    +28
    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
    owningObject) +424
    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
    owningObject) +66
    System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
    owningObject) +496
    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
    owningConnection) +82
    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
    outerConnection, DbConnectionFactory connectionFactory) +105
    System.Data.SqlClient.SqlConnection.Open() +111
    System.Data.Common.DbDataAdapter.FillInternal(DataSet 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.ExecuteSelect(DataSourceSelectAr
    guments arguments) +1770
    System.Web.UI.WebControls.BaseDataList.GetData() +53
    System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean
    useDataSource) +284
    System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +56
    System.Web.UI.WebControls.BaseDataList.DataBind() +72
    System.Web.UI.WebControls.BaseDataList.EnsureDataBound() +55
    System.Web.UI.WebControls.BaseDataList.CreateChildControls() +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
    casper, Apr 22, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Daves
    Replies:
    1
    Views:
    368
  2. =?Utf-8?B?Q2FybCBNLg==?=
    Replies:
    4
    Views:
    2,478
    sivlookingforu
    Aug 7, 2006
  3. casper

    cannot access sql server express

    casper, Apr 22, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    781
    casper
    Apr 22, 2006
  4. farseer

    SQL Server 2005 + SQL Server Express

    farseer, Aug 7, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    344
    farseer
    Aug 8, 2006
  5. Grey Alien

    SQL Server 2000 vs SQL Server Express

    Grey Alien, Jul 8, 2007, in forum: ASP .Net
    Replies:
    6
    Views:
    493
    Grey Alien
    Jul 9, 2007
Loading...

Share This Page