Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: Cannot login to QNE Optimum, system Prompted Named Pipes Provider, error: 40 - Could not open a conn

Cannot login to QNE Optimum, system Prompted Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

Article ID: 60584 Email Print
Question
Cannot login to QNE Optimum, system Prompted Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

Answer

Please make sure the below are well configure:

  1. if this is in a network environment, Your workstation can ping the server
  2. Named pipes/TCP is enabled. - http://support.qne.com.my/article.aspx?cid=3203&aid=60585
  3. Remote connections are allowed. - http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
  4. Created an exception for port 1433 in Windows Firewall.

 

 Other possible reasons:

1. if the above are configured well and still prompt the same error, Please check if SQL Server is actually using port 1433. It may be using something other than the default port. - http://stackoverflow.com/questions/19451490/how-to-identify-port-number-of-sql-server

2. If choose a named instance and you call your named instance SSQDatabase1 and your pc's name is PCX1. You must enter PCX1\SSQDatabase1 not just SSQDatabase1 or you will receive the named pipes error.

3. I spent about an hour trying to figure out what's wrong with SERVER/INSTANCENAME when everything is configured correctly, named pipes, user access rights... and suddenly it struck me, it's not a slash, it's a backslash (\).

The horror, the shame..


related articles

Article Details
Views: 3070 Created on: Jan 06, 2015
Date updated: Jan 06, 2015

Poor Outstanding