Sql-server – Save Connections in SSMS

sql serversql-server-2008-r2ssms

Can I save some sort of session or profile in SSMS (2008 r2) that will open up connections to a saved list of database servers when I open SSMS?

So for example I frequently will open up SSMS and then connect to SQL Servers NY-DB01, NY-DB02 etc… Can I have some sort of shortcut just to open all of these at once?

Best Answer

Using SSMS, register the servers you're interested in and group them in a folder. Then you can connect to them all at once like this:

SSMS registered servers.

Related Solutions

Sql-server – limit to how many credentials SSMS can remember

It is still a bug (sql server 2008 - 2014 (version 12.0.2000.8 still affected)) as highlighted below :

SQL Server 2012 Management Studio spuriously forgets password, despite being set to remember it.

You can vote up the connect item to get it HOPEFULLY fixed if you are experiencing the bug as well.

%UserProfile%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

might have a limit but I don't know of any kind of hard limit.

BTW, how big is your sqlstudio.bin file now ?

Sql-server – Cannot Connect Using SSMS to Local SQL Server 2008 R2

As I posted in the comments, a couple of possibilities exist for that error, mainly lack of memory for additional TCP connections (generally in conjunction with 32-bit OSes), or lack of TCP ports. Both issues (and possible solutions) are outlined here on the SQL Protocols blog:

Understanding the error "An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full."

Best Answer

Related Solutions

Sql-server – limit to how many credentials SSMS can remember

Sql-server – Cannot Connect Using SSMS to Local SQL Server 2008 R2

Related Question