I use SQL Server Management Studio and Visual Studio 2005.
I have several databases linked to Visual Studio 2005, but when I start the website (using "start without debugging"), the databases automatically disconnect. I've tried "test connection" several times, and it always comes back okay. Does anybody know what
the issue is?
Is there any error message prompted? How do you connect to the SQL Server? You may have a try to debug into the code to see which statement leads to the error and the detail information of the error message.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.