SQL Server基础远程登录

SQL Server for Windows在安装完成之后如果需要账号远程登录，需要做以下步骤

SQL Server 远程账号登录

首先去SQL Server Configuration Manager将Shared Memory, Named Pipes和TCP/IP启用才可以远程登录。

然后如下新建账号

或者通过SQL新建账号“localuser”

USE [master];
GO

CREATE LOGIN [localuser] WITH PASSWORD = 'password';
GO

-- Step 2: Create a user in your database
USE [AdventureWorks2022];
GO

CREATE USER [localuser] FOR LOGIN [localuser];
GO

-- Step 3: Assign to db_owner role
ALTER ROLE [db_owner] ADD MEMBER [localuser];
GO