SQLServer 2014

Question

SQLServerが、正常に作動しなく、他のアプリが使用できなく困っていて、貴社Microsoftさんに確認する作業だと言われたため、お問い合わせさせていただきました。

Answer 1

If SQL Server 2014 is not functioning properly and is affecting other applications, you may want to verify that the SQL Server instance is running. Here are some steps you can follow:

1. Check SQL Server Services: Use SQL Server Configuration Manager to see if the SQL Server instance is running. A green arrow indicates that it is running, while a red square indicates it is stopped. If it is stopped, you can right-click and select Start to run it.
2. Use PowerShell: You can check the status of SQL Server services using PowerShell commands. For example:

      Get-Service | Where {$_.status -eq 'running' -and $_.DisplayName -like "sql server*"}
   

   This command will list all running SQL Server services.
3. Review Error Logs: Check the SQL Server error log for messages indicating whether the server is ready for client connections. You can search for the message "SQL Server is now ready for client connections" in the error log.

If the problem persists, you may need to contact Microsoft support for further assistance. You can find support options for SQL Server on the Microsoft website.

---

References:

• A network-related or instance-specific error occurred while establishing a connection to SQL Server
• Technical support policy for Microsoft SQL Server