성태의 닷넷 이야기
홈 주인
모아 놓은 자료
프로그래밍
질문/답변
사용자 관리
사용자
메뉴
아티클
외부 아티클
유용한 코드
온라인 기능
MathJax 입력기
최근 덧글
[정성태] Java - How to use the Foreign Funct...
[정성태] 제가 큰 실수를 했군요. ^^; Delegate를 통한 Bein...
[정성태] Working with Rust Libraries from C#...
[정성태] Detecting blocking calls using asyn...
[정성태] 아쉽게도, 커뮤니티는 아니고 개인 블로그입니다. ^^
[정성태] 질문이 잘 이해가 안 됩니다. 우선, 해당 소스코드에서 ILis...
[양승조
] var대신 dinamic으로 선언해서 해결은 했습니다. 맞는 해...
[양승조
] 또 막혔습니다. ㅠㅠ var list = props[i].Ge...
[양승조
] 아. 감사합니다. 어제는 안됐던것 같은데....정신을 차려야겠네...
[정성태] "props[i].GetValue(props[i])" 코드에서 ...
글쓰기
제목
이름
암호
전자우편
HTML
홈페이지
유형
제니퍼 .NET
닷넷
COM 개체 관련
스크립트
VC++
VS.NET IDE
Windows
Team Foundation Server
디버깅 기술
오류 유형
개발 환경 구성
웹
기타
Linux
Java
DDK
Math
Phone
Graphics
사물인터넷
부모글 보이기/감추기
내용
<div style='display: inline'> <h1 style='font-family: Malgun Gothic, Consolas; font-size: 20pt; color: #006699; text-align: center; font-weight: bold'>SqlException (0x80131904): Unable to open the physical file</h1> <p> SQL Server LocalDB로 테스트하던 웹 사이트가 어느 순간부터 다음과 같은 오류가 발생하면서 SQL 실행이 안됩니다.<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Server Error in '/' Application. Unable to open the physical file "E:\WebApplication1\App_Data\TestDB.mdf". Operating system error 2: "2(The system cannot find the file specified.)". Cannot attach the file 'E:\WebApplication1\App_Data\TestDB.mdf' as database 'TestDB'. 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: Unable to open the physical file "E:\WebApplication1\App_Data\TestDB.mdf". Operating system error 2: "2(The system cannot find the file specified.)". Cannot attach the file 'E:\WebApplication1\App_Data\TestDB.mdf' as database 'TestDB'. ...[생략]... [SqlException (0x80131904): Unable to open the physical file "E:\WebApplication1\App_Data\TestDB.mdf". Operating system error 2: "2(The system cannot find the file specified.)". Cannot attach the file 'E:\WebApplication1\App_Data\TestDB.mdf' as database 'TestDB'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +133 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +913 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +6501 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +108 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +95 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) +549 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) +1942 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) +510 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken) +918 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +1448 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +115 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +1061 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +212 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +2698 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +233 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +1671 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +192 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +46 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +288 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +513 System.Data.SqlClient.SqlConnection.Open() +399 System.Data.Entity.SqlServer.<>c__DisplayClass1.<Execute>b__0() +34 System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +251 System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation) +197 System.Data.Entity.Core.EntityClient.EntityConnection.Open() +516 [EntityException: The underlying provider failed on Open.] System.Data.Entity.Core.EntityClient.EntityConnection.Open() +627 System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection() +173 System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) +645 System.Data.Entity.Core.Objects.<>c__DisplayClassb.<GetResults>b__9() +271 System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +251 System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +600 System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() +89 System.Lazy`1.CreateValue() +713 System.Lazy`1.LazyInitValue() +572 System.Lazy`1.get_Value() +249 System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() +40 System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +371 System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__2(IEnumerable`1 sequence) +83 System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable`1 query, Expression queryRoot) +107 System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +197 System.Data.Entity.Internal.Linq.DbQueryProvider.Execute(Expression expression) +149 System.Linq.Queryable.SingleOrDefault(IQueryable`1 source) +376 Microsoft.AspNet.Membership.OpenAuth.EFOpenAuthMembershipDatabase.GetMembershipUserName(String providerName, String providerUserId, Boolean updateLastUsed) +1526 Microsoft.AspNet.Membership.OpenAuth.OpenAuthManager.Login(HttpContextBase context, String providerName, String providerUserId, Boolean createPersistentCookie) +288 Microsoft.AspNet.Membership.OpenAuth.OpenAuth.Login(String providerName, String providerUserId, Boolean createPersistentCookie) +109 WebApplication1.loginProcess.Page_Load(Object sender, EventArgs e) in e:\WebApplication1\loginProcess.aspx.cs:64 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +159 System.Web.UI.Control.OnLoad(EventArgs e) +165 System.Web.UI.Control.LoadRecursive() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3610 </pre> <br /> 문제의 원인은, 에러 메시지에 나타난 것처럼 진짜로 "E:\WebApplication1\App_Data\TestDB.mdf" 파일이 존재하지 않았고 따라서 실제로도 그 파일을 열 수 없었기 때문에 문제가 발생한 것입니다. 그런데 이상한 것은, 지난번에 쓴 글처럼,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > OpenAuth 사용 시 System.Data.SqlClient.SqlException 예외가 Output 창에 출력되는 문제 ; <a target='tab' href='http://www.sysnet.pe.kr/2/0/10811'>http://www.sysnet.pe.kr/2/0/10811</a> </pre> <br /> 저는 분명히 LocalDB를 사용했고, 없는 경우 자동으로 생성하는 구조였기 때문에 파일이 없다는 것만으로 오류로 빠지는 것은 말이 안되었습니다. <br /> <br /> 그러다가, 얼핏 연결 문자열을 살펴보게 되었는데,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > <connectionStrings> <add name="DefaultConnection" connectionString="Data Source=<span style='color: blue; font-weight: bold'>.\SQLEXPRESS</span>;AttachDbFilename=|DataDirectory|\TestDB.mdf;Initial Catalog=TestDB;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> </pre> <br /> 웬일인지, LocalDB가 아니라 SQLExpress가 사용되고 있었던 것입니다. 따라서 연결 문자열을 다시 LocalDB용으로 바꾸는 것으로,<br /> <br /> <pre style='margin: 10px 0px 10px 10px; padding: 10px 0px 10px 10px; background-color: #fbedbb; overflow: auto; font-family: Consolas, Verdana;' > Data Source=<span style='color: blue; font-weight: bold'>(LocalDb)\mssqllocaldb</span>;AttachDbFilename=|DataDirectory|\TestDB.mdf;Initial Catalog=TestDB;Integrated Security=True; </pre> <br /> 문제를 해결했습니다. 가만 생각해 보니, 해당 프로젝트를 LocalDB가 아닌 SQL Express가 설치된 PC에서 열었던 적이 있었고 그 와중에 뭔가 연결 문자열이 LocalDB에서 SQLExpress로 변경된 듯 했습니다. (여러 컴퓨터에서 작업하다 보니 이런 문제도 발생하는군요. ^^)<br /> </p><br /> <br /><hr /><span style='color: Maroon'>[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]</span> </div>
첨부파일
스팸 방지용 인증 번호
4336
(왼쪽의 숫자를 입력해야 합니다.)