SSMS asks me to connect for every query in my project. Is there a way to connect only once per connection for all of the queries using it in my project?
The answers below (March 2014) don't answer the question. Still looking for a solution.
Sql-server – How to connect once for all queries in SQL Server Management Studio
sql serversql-server-2012ssms
Related Question
- SQL Server Management Studio 2016 – Fixing Crashes
- SQL Server Permissions – Create a User Account Login That Cannot Login from SSMS
- Visual Studio 2017 vs SQL Management Studio – Comparison
- SQL Server – How to Collapse Schemas in SQL Server Management Studio
- SQL Server – How to Enable Identity Insert for All Tables During Import
- SQL Server – How to Fix SSMS Connection Issues Due to Common Algorithm
Best Answer
It has nothing to do with the Remember password option. It is just easier to reconnect when this option is checked because you only have to hit ENTER.
You have to go to this menu in SSMS: Tools / Options
In the Options window, go to this node:
At the bottom, uncheck Disconnect after the query executes:
It won't change a thing on existing connection and already opened query windows.
Open a new New Query window and connect to your server. It should not request login and password or AD user anymore, or just once.