I. User Logins SQL Server cho phép người dùng có thể tạo tài khoản và đăng nhập vào. Mỗi người dùng đều truy cập vào trong SQL Server qua 1 tài khoản riêng. Khi tạo 1 tài khoản người dùng mới, quản trị viên sẽ cấp cho tài khoản này các quyền(Server Roles) và phạm vi có thể truy cập(Database Schemas). Tạo tài khoản Đăng nhập thử tài khoản mới II. Server Roles Để giới hạn mức độ truy cập…
When you try to connect to a SQL Server instance from a remote computer, you might receive the following error message: Cannot connect to SQL Server.An error has occurred while establishing a connection to the server. When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server) After installing SQL Server,…
Although the words logins and users are often used interchangeably, they are very different things in Microsoft SQL Server. There has always been confusion over logins and users, especially for most new SQL Server users. Here I’ll explain the difference between SQL Server logins and database users. Part 1: Logins vs. Users Logins are created at the server level, while users are created at the database level. In other words, a login allows you to connect to the SQL Server…
How to Create New Login in SQL Server Here is how to create login in SQL Server: Step 1) To create login SQL server, Navigate to Security > Logins Step 2) In the next screen, Enter Login Name Select SQL Server authentication Enter Password for MySQL create user with password Click Ok Step 3) Login is created You can also create a login using the T-SQL command for SQL server create login and user. CREATE LOGIN MyLogin WITH PASSWORD = ‘123’; How to…
One thing that I see a lot of administrators ask about is transaction log size and how to truncate it. Log records that are not managed correctly will eventually fill up the disk causing no more modifications to the database. Transaction log growth can occur for a few different reasons. Long running transactions, incorrect recovery model configuration and lack of log backups can grow the log. Log truncation frees up space in the log file so the transaction log can…
If you want to connect to Microsoft SQL Server, but the SA password is successfully forgotten and there is no user with the SQL Administrator rights — don’t worry! If you have local Administrator rights on the Windows operating system, you have the opportunity to get Administrative rights on the MS SQL Server and reset SA password. How to Reset SA Password on MS SQL Server 2012? As is known MS SQL supports 2 types of authentication: Windows Authentication and SQL Server…