creating ap database in sql server management studio 17

That's it, we have created a new database (Expand 'Databases' by clicking '+' icon on the left of it and you will see new database name there.), let's add some tables and sample data in it. Once you have selected 'New Database', a new Window Pop-up will appear, where you can name your database (SampleDatabase) and click 'OK' to generate new database, as shown below. So to create new database, right-click on 'Database' and then select 'New Database' Step 2: As you can see in the above Gif image, once we are connected to Local database Engine, we have got options like 'Database'. Step 1: Open SQL Server Management Studio and then connect it to local database engine using Windows Authentication or SQL Server Authentication,as shown in the below image.įor easier configuration, we will be using Windows Authentication for now, as shown in the below Gif Image. Let's begin creating our new database easily using SSMS. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and SQL Data Warehouse.Ĭreate SQL Server Database using SQL Server Management Studio (SSMS) SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Once you have downloaded and installed SQL Server, you will also need SSMS and yes SQL Server management studio is a free to use software. Before we begin, I hope you have downloaded and installed SQL Server on your local machine, if not check here to ' Download and Install SQL Server step by step' and Download and Install SQL Server Management Studio (SSMS) also.

If you are a database developer or Full-stack developer working with SQL Server database, then you might need to create database in SQL Server, which we can do it easily using SQL Server managment Studio (SSMS), so in this article, I have provided step by step details on how to create sql server database using SSMS (SQL Server Management Studio).

Creating ap database in sql server management studio 17