:::: MENU ::::

how to register new SQL Server instance through SQL Server management Studio(SSMS)

  • Feb 11 / 2009
  • 0
DBA best practices, dbDigger, SSMS tips and tricks

how to register new SQL Server instance through SQL Server management Studio(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 register new SQL Server instance through SQL Server management Studio(SSMS). Follow these steps in your SSMS

Register New Server Instance

Fill our required fields in this frame

Register New Server Instance 1

You may also change default connection properties under connection properties tab.

Register New Server Instance 2

Test the connection parameters through test button and save your settings. New instance would be get registered. Please note that above snaps have been taken from Management studio 2008, so you may get some minor differences in case of SSMS 2005. One of such differences is use custom color option under connection properties tab. This option is not available in SSMS 2005.

Consult us to explore the Databases. Contact us