CODEWITHSUNDEEP
sql-serverssmssql-agent
Michelle Santos
Michelle Santos

Reputation: 267

SQL Error Logs not viewable in SQL Server

I am having an issue on viewing the SQL Error logs on SSMS. I'm aware that I'm also able to view the error logs by going to the folder where the error logs are stored. I have tried verifying if my service account has permission to access the error log location (read/write). Also my service account is granted sysadmin in SSMS. Still I'm unable to view the SQL Error Logs in SSMS.

enter image description here

enter image description here

Upvotes: 1

Views: 3283

Answers (3)

Kjon
Kjon

Reputation: 1

There are several service logins that should be checked. NT Service\MSSQL<server or $instance name> NT Service\MSSQLAgent<server or $instance name> NT Service\SQLTelemetry<server or $instance name>

The first two are granted sysadmin privileges at installation. If these permissions didn't get set for some reason, SSMS will not show the SQL logs- No error message, just no logs. Same may apply to the account under which the SQL engine is running.

Upvotes: 0

Chuck
Chuck

Reputation: 139

Restart Sql Server Management Studio.

Upvotes: 1

vvvv4d
vvvv4d

Reputation: 4095

  1. In SQL Server Management Studio, select Object Explorer. ...
  2. In Object Explorer, connect to an instance of SQL Server, and then expand that instance.
  3. Find and expand the Management section (assuming you have permissions to see it).
  4. Right-click SQL Server Logs, select View, and then choose SQL Server Log

enter image description here

https://learn.microsoft.com/en-us/sql/relational-databases/performance/view-the-sql-server-error-log-sql-server-management-studio?view=sql-server-ver15

Upvotes: 1

Related Questions