:::: MENU ::::

how to connect to a service or instance within SSMS

  • Jan 29 / 2009
  • 0
dbDigger, SSMS tips and tricks

how to connect to a service or instance within SSMS

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to connect to a service or instance within SSMS. Follow these steps in your SSMS

Connect to Service or instance

From here you can choose any service to log on into. Your current session in SSMS will be remain active as long as you disconnect it.

Consult us to explore the Databases. Contact us