login failed for user ‘sa’

SQL Server Error : 15150, Severity: 16. Cannot %S_MSG the %S_MSG ‘%.*ls’.

VRB
May 15, 2022
SQL Server

SQL Server Error : 15150 Details

SQL Server Error: 15150 Severity: 16 Event Logged or not: No Description: Cannot %S_MSG the %S_MSG ‘%.*ls’. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server SQL server error 15150 from Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master Go xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc' Go

For … Read the rest

SQL Server Error : 18456, Severity: 14. Login failed for user ‘%.ls’.%.ls%.*ls

Vamshi B
August 31, 2021
SQL Server

SQL Server Error : 18456 Details

SQL Server Error: sql server error 18456 Severity: 14 Event Logged or not: Yes Description: Login failed for user ‘%.*ls’.%.*ls%.*ls Severity 14 Description: Indicates security-related errors, such as permission denied.

Details for sql server error 18456

Attribute	Value
Product Name	SQL Server
Event ID	18456
Event Source	MSSQLSERVER
Component	SQLEngine
Symbolic Name	LOGON_FAILED
Message Text	Login failed for user ‘%.ls’.%.ls

When a connection attempt is refused due to an authentication failure involving an incorrect password or user name, the client receives a message that looks like this: “User ‘user name>’ was unable to log in. (Error: 18456 in Microsoft SQL Server) “..

Related errors include:

sql server error 18456
error sql server 18456
error

… Read the rest

SQL Server Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405

Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

when importing a database in your SQL instance you would find yourself with Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 popping out when setting the sa user as the DBO of the database.

To Fix this Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

Open SQL Management Studio and Click New Query. Type:

USE mydatabase
exec sp_changedbowner ‘sa’, ‘true’

To change the owner of the database, you can use sp_changedbowner or ALTER AUTHORIZATION command

Another Cause of Error in SQL Server ” Cannot use the special principal ‘sa’.