Post reply

SQL Server 2000 not closing connections help!!

  • January 31, 2008 at 8:57 am

    #119804

    I am experiencing a strange problem on a new installation of SQL Server 2000, installed on Windows 2003 server. SQL server has been service packed to SP3a

    The users connect to the SQL database via an MS Access project front end, when they log out of the front end the SQL server still show them as connected in Management > Current activity > process info. I can kill the processes left behind but i am confused as to why this is happening.

    The database was recently moved from an SQL installation on a Windows 2000 server to this new Windows 2003 server, the problem didnt occur on the old server and no upgrades have been applied to the database or the front end since the move, which makes me think something is not right about the install.

    Any advice would be gratefully received

    Thanks

    Nick

  • January 31, 2008 at 9:30 am

    #773817

    I think it is an issue on the application interface. Before a user logoff, the application should close the connection. Otherwise, the session on SQL Server will remain there until timeout.

  • January 31, 2008 at 9:35 am

    #773823

    Thanks for the reply, I understand what you mean but the same version of the application is being used elsewhere on other servers and the same does not occur, i was wondering if it could be a licensing issue this install was setup per seat rather than per processor

    Thanks

  • January 31, 2008 at 9:42 am

    #773827

    Just personal point of view.

    I do not think that it caused by different versions. Did you check the timeout settings on other SQL Servers?

  • January 31, 2008 at 9:53 am

    #773833

    No i havent done that, i will compare the two.

    Cheers

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply