T-SQL Script: Fix orphaned users in SQL Database Fix orphaned users in the SQL database, provided the SQL Server login for the user is already created. ALTER USER [username] WITH LOGIN = [loginname];