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