SQL - Opening a session

[Jules10010]

I have received this error message

"Can't open session to target database" - Anybody now why and how it can be prevented from happening again??

 

[tlbroadbent]

Tell us the program or post the code that produces the error. It will also be good to know the version of SQL Server, type of connection, and whatever details you can provide to help us analyze the situation. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm