sql server local administrator access

SQL Server Error : 15247, Severity: 16. User does not have permission to perform

VRB
May 14, 2022
SQL Server

SQL Server Error : 15247 Details

SQL Server Error: 15247 Severity: 16 Event Logged or not: No Description: User does not have permission to perform this action. 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 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,… Read the rest

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

VRB
May 10, 2022
SQL Server

SQL Server Error : 15151 Details

SQL Server Error: 15151 Severity: 16 Event Logged or not: No Description: Cannot %S_MSG the %S_MSG ‘%.*ls’, because it does not exist or you do not have permission. Severity 16 Description: Indicates general errors that can be corrected by the user.

Msg 15151, Level 16, State 1, Line 2
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.