Category: SQL Server

If you get the following error message, try the autofix option with the password. This is a security hole fix for later versions of SQL Server.

Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login,
Line 96
Terminating this procedure. The Login name ” is absent or invalid.

exec sp_change_users_login 'Auto_Fix', 'user', NULL, 'password'

 

Tags:

SQL server

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: