Login failed for user ‘sp’. Reason: Password did not match that for the login provided
Please excuse my ignorance of basic SQL Server admin. Any advice much appreciated. I cannot login using passwords. For example:
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat -e
1> create login sp with password=’sp’;
2> go
create login sp with password=’sp’;
1> create user sp for login sp;
2> go
create user sp for login sp;
1> alter server role sysadmin add member [sp];
2> go
alter server role sysadmin add member [sp];
1> exit
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat,1433 -U sp -P ‘sp’
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ‘sp’..
C:Usersjohn>
In the SQL Server log I see this,
Date Sun 21 07 2024 14:26:33
Log SQL Server (Current – Sun 21 07 2024 14:26:00)
Source Logon
Message
Login failed for user ‘sp’. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
I have tried any number of variations on case and quotes. I must be missing something really basic?
Thankyou for any insight.
Please excuse my ignorance of basic SQL Server admin. Any advice much appreciated. I cannot login using passwords. For example:C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat -e
1> create login sp with password=’sp’;
2> go
create login sp with password=’sp’;
1> create user sp for login sp;
2> go
create user sp for login sp;
1> alter server role sysadmin add member [sp];
2> go
alter server role sysadmin add member [sp];
1> exit
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat,1433 -U sp -P ‘sp’
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ‘sp’..
C:Usersjohn>In the SQL Server log I see this,Date Sun 21 07 2024 14:26:33
Log SQL Server (Current – Sun 21 07 2024 14:26:00)
Source Logon
Message
Login failed for user ‘sp’. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]I have tried any number of variations on case and quotes. I must be missing something really basic?Thankyou for any insight. Read More