Table of Contents
SQL Server Error : 258 Details
SQL Server Error: 258
Severity: 15
Event Logged or not: No
Description:
Cannot call methods on %ls.
Severity 15 Description:
Indicates syntax errors in the Transact-SQL command.
Cannot connect to Server, 1433\InstanceName.
ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – The wait operation timed out.) (Microsoft SQL Server, Error: 258)
The wait operation timed out
Solution for Resolving the Error
- Check that ping the target server from the computer the package is running on? If not, the server may be down or there may be routing or DNS issues
- Try a telnet session to the server using the port number? If not, SQL Server may not be running
- Make sure spelling of the server and instance name is correctly typed?
- Make sure the target server have TCP enabled in SQL Server Configuration Manager?
- Try connect to the server from anywhere else?
- Make Sure SQL Server Browser running on the target computer, or make sure you did supply the port number in the connection string?
Alternate Solutions
-
Restarting SQL Server Service(non production instances only)
- To Restart, Start or Stop the SQL Server instance by right click on sql server instance in SSMS or in SQL. You may need to open SSMS as administrator to start, stop the instance.
-
Other ways for restarting SQL server Service
- Running SQL Configuration manager from Start menu to restart services
- From Services in Windows server
- Running Command prompt Cmd using net start and net stop
SQL Server Error Code and solution summary
SQL Server Error: 258
Severity: 15
Event Logged or not: No
Description:
Cannot call methods on %ls.
Make sure SQL Server is running and reachable. TCP enabled etc..