Scenario 

Example if users have installed more than 1 instance as below:


But in SQL Management only show 1 instance, How can we Add Multiple SQL instances in SQL Management studio? Please refer below:


Solution 

To Add Multiple SQL instances in SQL Management studio for access connection.

Step 1 – Click <Browse for more…>


Step 2 – Click Network Servers, and wait system loading the instance list.

Note: all highlighted below, are the SQL Server Instance inside user network environment


Step 3 – Select the one you would like to connect > then Click OK.


Step 4 – After Click OK, the below screen will prompt, Select SQL Server Authentication


Step 5 – insert username and Password > Click Connect.

QNE Default username: SA

QNE Default Password: QnE123!@#


Connect Successfully.

End.



Discover : Attach Database in SQL Server manually with SQL Management studio

Know more about Microsoft SQL Server Product


Created By Cheng Kah Poh