Most of beginner think, how can we connect with SQL server, after installation of SQL server and SQL server management studio instant on local machine.
Below is easy steps you can follow to connect your SQL server with SQL management Studio.
You can go through below Tutorial in details:
Steps: Connect with SQL server
Step #1:
Start Microsoft SQL Server Management Studio from the Start menu. once you will search management studio in search option of start menu, you will see below list
Step #2:
- Once you will click on “SQL server management studio“, it will ask you to select Server type and Server name.
- Server Type= “Database Engine”
- Server name = click on “Browse for More …” Option,
- It will show another window and from that window from option “Database Engine” , select your machine name as Server name (as marked as 3 in below screenshot).
Step #3:
Now next step to enter username or Password and you can also use window Authentication as well
Step #4:
- Once you will get connected to SQL server via Management Studio you will se below screen with Object
- Object Explorer is the navigation bar which show you your Database, Table and Views. learn How you can create database from Management Studio.
SQL management studio is very powerful instant which you can use to connect with SQL server and also Microsoft Azur Server easily. and almost all SQL query and task you can perform. you can learn more about SQL – Data Manipulation command s which can be helpful to enhance your skills.