Dear Friends.
I installed SQL Server on my system, but there is a problem with the connection, when I am trying to connect it.
It fails and then an error appears. Details of the error is given below so that you can understand the original problem easily.
Cannot connect to PINAL.
Additional Information:
An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
OK
Thanks
Answered By
odurus
0 points
N/A
#96556
SQL Server Cannot connect to PINAL.
This problem is mostly caused because your muscle TCL/IP is not started. Follow this step by step approach.
*Click on the start menu.
*Right click on the computer and click on manage.
*Click on services and applications.
*Locate TCP/IP and restart the service.
*Go back to your SQL server and log in.
*Your problem is solved.
SQL Server Cannot connect to PINAL.
Normally this problem occurs while trying to access the server from some remote location or from a remote system. To get to the server remotely you must configure SQL server in such a way that it must accept remote connections. To do this, follow these steps:
*Enable the remote connections on the instance of SQL server.
*Turn the Browser service on SQL server ON.
*Configure the firewall in such a way that it will allow/permit the traffic related to SQL.
