SQL

How To Create Login In SQL

In this article, we will learn how to create a login in SQL.

Let’s follow the below steps to create a new login in SQL Server.

Step 1:

Firstly, Open Microsoft SQL Server Management Studio and then expand your instance and Security directory.

Step 2:

Now, Right-click on Logins directory and click on the New Login… option.

Step 3:

Now, ‘Login – New‘ dialogue box will open. Select SQL Server authentication and then enter your new Login name (TestLogin) and Password and then click on the OK button.

Step 4:

Now, refresh Object Explorer and check new login (TestLogin) is created.

 

Also, check How To Generate Script in SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.

Recent Posts

Testing hk

Testing

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

Operation

Testing

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

TETS NEW

test

3 years ago