Connection to SQL Server db stays open, after the reports are closed.

[LinPro]

Crystal 9, SQL Server 2000, Windows 2003,

We have just moved the reporting database to a new server and made changes to the reports to reflect this. During this process, I would open several reports to make the changes at the same time there are several sessions opened in the database as well. However, when I finished making the changes, the sessions in the database stay open - could you explain why does this happen?

Is there a way to closed the sessions after the changes are made and the reports are closed?

 

[synapsevampire]

They should close out after a bit. One thing you might do is select database->log off server or some such and select the database conection and close it. I can't recall exactly where it is as I don't have Crystal here.

-k