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.

 All Forums
 Development Tools
 ASP.NET
 Fatal error 9001 when connect to SQL from aspx page

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:26AM

The 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]
Go to Top of Page

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
Go to Top of Page

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 Marsala

Network Solution srl
I-16121 Genova, Italy
http://www.realizzazionesitigenova.it
http://www.genovaperte.it
Go to Top of Page
   

- Advertisement -