Skip to content
  • Home
  • blog
    • How to list all file names from a folder and sub-folders? | SQL Server Query to List Files
    • How do I create a disk space alert in SQL Server? | How to solve disk space issue in SQL Server?
    • How to configure database mail SQL Server? | How to Configure Database Mail on azure SQL managed instance
    • Detach And Attach Database in SQL Server | Detach multiple databases using sp_detach_db | detach attach database sql server
    • How To Resolve : Login failed for user ”. (Microsoft SQL Server, Error: 18456) | Cannot connect to XXXXXX.database.windows.net
    • How to shrink log file in SQL server? | Shrink SQL log file | SQL log file too big and won’t shrink
    • How to eliminate duplicate records into result set in SQL? | Clear duplicate records from SQL server table | SQL drop duplicate in table
    • Get azvm size using PowerShell | How to get VM size on AZURE?
    • How to create Linked Server on SQL Server for azure SQL database? | create linked servers on SQL Server for in azure SQL database
    • Interview Questions
    • Certifications
  • SQL DBA Training
  • Contact Us
  • ABOUT US
  • Privacy Policy
  • Disclaimer
  • Terms and Conditions

SQL server create user

How to create SQL login in SQL Server? | SQL server create user and grant permissions in SQL server 2022 | How do I grant login permissions in SQL Server?

April 23, 2023December 24, 2022 by fitomkarofficial@gmail.com

This Article guides, How to create SQL login in SQL Server? 3. Assign required permission from Server Roles or User Mapping tab. There are multiple default Server role exists in SQL Server. Sysadmin is highest privilege permission on SQL Server. Note: Do not assign Sysadmin to user. Grant minimum access to use based on requirement. … Read more

Categories blog Tags How to Create Login, SQL DBA, SQL Server, SQL server create user 1 Comment

Recent Posts

  • How to resolve Microsoft SQL Server, Error 47073? | Cannot connect to DBServer.database.windows.net?
  • How to compress XML data in SQL 2022? | SQL Server 2022 new features | Can SQL 2022 XML compression save disk cost with XML data?
  • How SQL Server Always ON can help to achieve RPO and RTO? | Achieve three in One Solution using SQL Server Always ON
  • How to resolve SQL Server Error 15343? | Troubleshoot, Could not drop login
  • Database recovery is slow due to log file issue in SQL Server Always ON failover | How to troubleshoot database startup slowness in SQL Server Always ON?

Recent Comments

  • How to resolve Microsoft SQL Server, Error 47073? | Cannot connect to DBServer.database.windows.net? - omkarclouddba.tech on microsoft sql server error 1412 always on | Always on Error – The remote copy of database “DB Name” has not been rolled forward to a point in time that is encompassed in the local copy of the database log.
  • fitomkarofficial@gmail.com on How to get deadlocks history in SQL Server using system_health extended events?
  • sagar on How to get deadlocks history in SQL Server using system_health extended events?
  • How SQL Server Always ON can help to achieve RPO and RTO? | Achieve three in One Solution using SQL Server Always ON - omkarclouddba.tech on Availability Group database stuck in Not Synchronizing | Log file full due to Availability Replica
  • fitomkarofficial@gmail.com on How to create bacpac file from SQL server? | export bacpac file sql server | How to create a BACPAC file from SQL Server database?
© 2025 omkarclouddba.tech • Built with GeneratePress