How do I connect to SQL Server with a different user?

How do I connect to SQL Server using different Windows Authentication?

Open SQL Server Management Studio. In Connect to Server, select Database Engine, enter your SQL Server name, and enter administrator credentials to connect to the server. Select Connect. In Object Explorer, expand the SQL Server, expand Security, right-click Logins, and then select New Login.

How do I connect to a SQL Server username and password?

To create this user:1In SQL Server Management Studio, right-click Security > Logins; then select New Login.2Enter the username (for example, papercut).3Change the Server Authentication to SQL Server and Windows Authentication mode.4Enter the user's password.5Disable password expiration.6Click OK.Configuring Microsoft SQL Server - PaperCut

How do I connect to a local SQL Server user?

In Windows, click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager. Expand the node for the server, and then expand the node for the database for which you want to grant user rights. Right-click Users, and then click New Database User.

How do I run SQL Server as another user in Windows 10?

If you are using Windows 10, the way to do this is to hold the Shift key before you right-click the SSMS link. Then you see this instead: And you can then choose the Run as a different user option to log on as someone else just for this one application.