I develop a Web service that uses a SQL Express database, it does very well in Visual Studio host , But when I deployed it to IIS 7.5, I exception please help me Stack trace: ..
System.Data.EntityException: The underlying provider fails on the Open --- & gt; System.Data.SqlClient.SqlException: Failed to retrieve the user's local application data path to generate a user instance of SQL Server, due to failure. Please make sure that the user has a local user profile on the computer. The connection will be closed. System.Data.SqlClient.TdsParser.Run on System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (TdsParserStateObject stateObj) on System.Data.SqlClient.SqlInternalConnection.OnError (SqlException Exception, Boolean Break Connection), RunBehavior Run Behavior, SqlCommand cmdHandler, SqlDataReader datastream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin (Boolean enlistOK) on System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin (serverInfo on serverInfo, string newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) system. Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover (String host, String newPassword, boolean redirect user interface, SqlConnection Maliking object, SqlConnectionString Knekshnupakrn, Int64 Taimrstart) System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist (SqlConnection OwningObject, SqlConnectionString ectionOptions) on conn, string newPassword , Boolean redirectedUserInstance) System.Data.SqlClient.SqlInternalConnectionTds..ctor at (DbConnectionPoolIdentity Identity, SqlConnectionString connectionOptions, ProviderInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) System.Data.SqlClient.SqlConnectionFactory.CreateConnection (DbConnectionOptions Object System.Data. ProviderBase.DbConnectionFactory.C System.Data on System.Data.ProviderBase.DbConnectionPool.CreateObject (on DbConnection OwningConnection, DbConnectionPool Pool, DbConnectionOptions option), Object Pool Group Provider Info, DB Connection Pool Pool, DB Connection Poll Pool, Owner Connection of DB Connection) . ProviderBase.DbConnectionPool.UserCreateRequest System.Data.ProviderBase.DbConnectionFactory.GetConnection at System.Data.ProviderBase.DbConnectionPool.GetConnection (DbConnection owningObject) (DbConnection owningConnectio N) System.Data.ProviderBase.DbConnectionClosed.OpenConnection (DbConnection External connection, DbConnectionFactory connection Factory) was attempted on System.Data.SqlClient.SqlConnection.Open (System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf on) (Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection original connection string Apwadkod, string operation, Boolean & CloseStoreConnectionOnFailure) --- Interval Exception Stack Trace --- Terminated on System Ren- Data.EntityClient.EntityConnection.OpenStoreConnectionIf (Boolean open condition, DbConnection storeConnectionToOpen, DbConnection original connection string Apwadkod, the string has been attempted operation, Boolean and off Story connection) System.Data.EntityClient .EntityConnection.Open () System on .Data.Objects.ObjectContext.EnsureConnection () .Generic.IEnumerable & LT on System.Data.Objects.ObjectQuery`1.GetResults (Nullable`1 forMergeOption) on System.Data.Objects.ObjectQuery`1.System.Collections; T & gt; .GetEnumerator () System.Linq.Enumerable.FirstOrDefault [TSource] (IEnumerable`1 source) on WSCinema.CinemaService.Movie (D): \ Documents \ My Dropbox \ projects \ sd.v0910 \ Trab3 \ code \ WSCinema \ CinemaService.asmx.cs: row 46
account application pool of your app in IIS Running is the reason to write the requirements of the App_Data folder where your database file (MDF) is stored. As if the App Pool is configured to run as a network service, then allow it in the App_Data folder for that account.
When you run in a VS host, your app is running as your user account, which has access to App_Data.
Comments
Post a Comment