Hi,
Please confirm the following information:
-
Firstly, please make sure that the connectionstring is correct. You can try to reconnect to this database from Visual Studio.
-
Please also install the latest service packet for Visual Studio and Sql Server.
-
If we disable Add-ns (“Tools” | “Add-in Manager”) and run “devenv.exe /safemode”, do we still have the problem? This can eliminate the possibility that third party Add-ins are causing problems.
In addition, a log will be very useful for the trouble-shooting. We can consider the following log systems in this issue:
1. SQL Profiler and SQL error log.
Because our project fails when it tries to cooperate with the SQL server, we can utilize the log systems in SQL server to see what happens.
A. SQL profiler, available in SQL Server->Performance Tools->SQL Server Profiler, is able to record all the SQL requests and the result of the requests. So we can start SQL profiler recording, start VS solution, and see what it records when the VS error is popped up.
B. SQL error log.
SQL error logs can be found in the directory: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG... They are, in fact, txt files that we can open with notepad.
2. Windows Event Viewer.
In the Application section of the event viewer, it records the error of the applications. Thus, it'll also be a good choice for trouble-shooting if VS logs its errors into it.
I hope this helps.
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.