SSMS asks me to connect for every query in my project. I know I can let it save the password, but I'm asking if there's another way - so I'll have to type in the password only once per session.
migrated from stackoverflow.com Aug 24 '12 at 12:19
Click View --> Registered Servers Right-click Local Server Groups --> New Server Registration
Then you can store the connection info, name it what you want, and just double-click then when you want to use it.
|show 1 more comment|
Do you have a connection configured for your project within SSMS?
If not right-click under Connections and create a new connection to your instance. Then to create a new query simply right click the connection you created and select "new query". It will then use that connect for your query.
It is by design it does this because the query you create has to be associated to some connection, which clicking cancel will obviously create the query with no connection.