LIVE 04 : How to create multiple instances of SQL Server |User assign permisson
Channel: mr.rout299
Date: 2023-03-25

Welcome to mr.rout299 family👨‍💻

@This video I have explored briefly  about. 
How to Create a new login instance using SQL Server management studio | How to create a user for a particular database and Assign permission to the user.  Please watch the still end, definitely created video will help you a lot on this topic. ThankYou ! 

For a database login instance should include information about the purpose of the login, the level of access it has to the database, and any other relevant details. Here is an example description for a database login instance:

"This login instance provides read and write access to the customer database for the customer service team. It is associated with the 'customer_service' SQL Server login and is used by team members to view and update customer records. This login instance has been granted the necessary database roles and permissions to perform these tasks efficiently and securely."

In general, the description should be clear and concise, and provide enough information to help users understand the purpose and scope of the login instance. It should also be kept up to date as the permissions and access levels for the login instance are modified over time.
*To create a new login instance using SQL Server Management Studio, follow these steps:
{Open SQL Server Management Studio (SSMS) and connect to the server where you want to create the new login instance.

Right-click on the "Security" folder in the Object Explorer pane and select "New Login" from the context menu.

In the "Login - New" window, enter the login name for the new instance in the "Login name" field.

Choose the authentication method for the new login instance. You can choose "Windows Authentication" or "SQL Server Authentication". If you choose SQL Server Authentication, you'll need to enter a password.

Under "Default database", select the database that the new login instance should connect to by default when it logs in.

Under "Server Roles", choose the server roles that the new login instance should be granted. This will determine the permissions that the login instance has on the server.

Under "User Mapping", select the databases that the new login instance should have access to and choose the database roles that it should be granted.

Click "OK" to create the new login instance.

That's it! You have now created a new login instance in SQL Server Management Studio.}

Find the below social media link  and if you have any query related to IT please reach out to me. 

https://www.instagram.com/mr.rout299/
https://www.facebook.com/pareshranjan...
https://www.linkedin.com/in/paresh-ra...

#sql #sqlserver #microsoft #technology #dbd #database #databasemanagementsystem @Microsoft