I've come across a problem with SQL Server 2005.When I make changes to my table design, I tend to adjust the .aql file myself and re-execute it. (Maybe this is not a good idea?) I have found that when I re-execute the script in SQL Server 2005 Developer edition then I get the following error when I try to access the database using coldfusion
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
I have not exceeded the number of connections allowed.Everything seems ok.
Any ideas?
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
I have not exceeded the number of connections allowed.Everything seems ok.
Any ideas?