How to fix incorrect syntax near 'LOGIN' in SQL Server 2005

Question

ALTER USER [myuser] WITH LOGIN =[myuser]

This query returns error in one of the SQL Server 2005 SP1 installation. Error is

Incorrect syntax near 'LOGIN'

Answer 1

Try

ALTER LOGIN Login WITH name = NewLogin

Answer 2

Several things

• You do not need to use [] around the user name and login you want.
• You seem to be trying to change the login to itself. That can't be right.

Try this:

ALTER USER myuser WITH LOGIN = myLOGIN

See the ALTER USER documentation on MSDN.

Answer 3

The problem seems to be a bug in SQL Server 2005.

It is fixed at SP2. So, The the fix is to upgrade it to SP2 or above.