Invalid Connection Error ,when Trying To Acces My Database

Hi friends,

            I have developed a website and uploaded the database to Remote server through Export wizard in Sqlserver 2005.everything is working fine in Sqlserver enterprise manager,  but when i tried to connect this database via web.config file to my website it is giving me error...


Server Error in '/Sales_offer' Application.


Invalid connection. 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: Invalid connection.

Source Error:





Line 29: {
Line 30: SqlCommand mycmd=new SqlCommand("select distinct(city) from master order by city asc",myconn);
Line 31: myconn.Open();
Line 32: SqlDataReader sdr=mycmd.ExecuteReader();
Line 33: ArrayList arr=new ArrayList();
Source File: d:inetpubwwwrootsales_offerindex.aspx.cs    Line: 31

Stack Trace:





[SqlException: Invalid connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Sales_offer.WebForm1.bind() in d:inetpubwwwrootsales_offerindex.aspx.cs:31
Sales_offer.WebForm1.Page_Load(Object sender, EventArgs e) in d:inetpubwwwrootsales_offerindex.aspx.cs:67
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()





Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

 

 

After that when i tried to access the database through Qury analyzer it is giving me error

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'salecumoffers'. No entry found with that name. Make sure that the name is entered correctly.

But it is showing me the tables and their Contents from Remote server in enterprise manager...

waiting for ur quick response

Neeraj