application users are not able to connect DB

Question

application users are not able to connect the database.How to  check if server is pining  and accessibility

Of the server also normal? please suggest me some possible causes.

Answer 1

Is SQL Server running?

What error message(s) are users receiving can be helpful in determining it's causes.

---

- Vishal

SqlAndMe.com

Answer 2

Use the SQL Server Configuration Manager program (which is always installed with SQL Server) to see if the database engine is started.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 3

Please sahre the error messages you are getting.

Although, There are many reasons of SQL server connectivity issue. Small checklist that helps to find out the real cause of connectivity issue.

1. Check SQL services are running

2. Check SQL Browser service is running

3. Check remote connections are enabled

4. Network connectivity between database & application servers by TRACERT command

5. Check TCP/IP protocol enabled at SQL server

6. Check talent connectivity – telnet <IP address> <port no on SQL server running>

7. Check UDP port 1434 is open or not on SQL Server

8. Check firewall is running or not Check

9. If firewall running, SQL Server & UDP port must be added in exception in firewall

Refer Link  : http://mssqlfun.com/2012/09/28/check-list-for-sql-server-connectivity-issue/

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.