Hello Everyone.
I am facing a problem when importing organization with a production server database. The error in log file shows : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
Before this error, the info "Update users shows".
I have used oldtimeout,TCPIP,Maxuserport,TCPTimewaitdelay, Optimise optimizeorgImport, delete the reports tables and also checked this link "http://support.microsoft.com/kb/2003564".
But at last on luck.
I will highly appreciate who will solve this problem.
Please help on this.
Thanks in advance.