Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-04-21 : 08:05:32
|
Bill writes "There is a fatal error occurred when a web page tried to get data from SQL server. Also When we look at the database from the enterprise manager, there is no database there. However, I can run the SQL select statement from query analyze and get the data rightaway.C#System.Data.SqlClient.SqlException: Warning: Fatal error 9001 occurred at Apr 20 2005 10:26AMThe page uses Microsoft data access block to handle the connection and data retrieve. Thanks for your help," |
|
jhermiz
3564 Posts |
Posted - 2005-04-21 : 16:36:58
|
Post your code. Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-21 : 18:04:50
|
The sentence: "When we look at the database from the enterprise manager, there is no database there." concerns me greatly. When I Googled the error number, I found one item that suggested it might be a problem with the Log file not being available. Although I can't explain why you would be able to query it from QA if that were the problem. I strongly encourage you to run some diagnostics on your database to ensure its integrity.---------------------------EmeraldCityDomains.com |
|
|
networksolution
Starting Member
1 Post |
Posted - 2014-07-09 : 17:40:11
|
Hi. Hi saw your post. Here at Network Solution we had a long day with this issue, and finally we expertise and solved this specific error (Fatal Error 9001) at server configuration level. Result of our work is a shared server where newly created DB are 9001-free thanks to our config scripts (made in years of expertise), preconfigured with the SessionState DB, the ideal for Windows-IIS-ASP.NET-MSSQL shared hosting! Please contact me at marco.marsala@live.it to see if our solution is applicable in your case to definitely solve the root cause of this annoying issue. Best Regards,Marco MarsalaNetwork Solution srlI-16121 Genova, Italyhttp://www.realizzazionesitigenova.ithttp://www.genovaperte.it |
|
|
|
|
|