Home » SQL Server Error : 113, Severity: 15. Missing end comment mark ‘*/’.

SQL Server Error : 113, Severity: 15. Missing end comment mark ‘*/’.

sql server DBA 999

SQL Server Error : 113 Details


SQL Server Error: 113
Severity: 15
Event Logged or not: No
Description:
Missing end comment mark ‘*/’.
Severity 15 Description:
Indicates syntax errors in the Transact-SQL command.

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, NULL, N'asc'
Go

Solution for Resolving the Error

This error occurs when there is some host settings problem, most sources say that this problem is strictly related to settings.
The 113 error shows “no route to host” error. you must configure your ip address on both machines. of course,it must be routable.else, it wont work.

This means that your database probably is not accessible from external machines because of database permissions/ privileges. This can be a part of security settings policy on the server

Make sure that the database user can be connected to database from ip address where is being accessed to where it is hosted

 

SQL Server Error Code and solution summary


SQL Server Error: 113
Severity: 15
Event Logged or not: No
Description:
Missing end comment mark ‘*/’.

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *