467,104 Members | 998 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

Named Pipes Provider, error 40 - Sql Exception (0x80131904)

Error:
provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

SqlException (0x80131904)

General Info:
Application is on server1(outside the firewall)
Database is on server2(inside the firewall) SQL Server 2005
Login is server authentication (Windows and Server Authentication is checked)
Remote server is allowed.
TCP/IP and Named Pipes is checked
Login and password has been created in the server security.
Read and write permission are set up.
Login and password has been created for the database.
Select, Update, etc. has been granted for the database user.
Network has both way communications open.

Must the application server1 have SQL server installed (it is not installed) to be able to communicate with the SQL Server database, server2?

Solution very welcome, Thanks.
Sep 24 '08 #1
  • viewed: 10616
Share:
2 Replies
For anyone who has tried all the troubleshooting helps without success.
This was my issue.
Changed the data source from a named server to the IP address and got through the firewall.
Sep 25 '08 #2
THANK YOU simkar!!!!!!!!!! I love u man... I have spend 2 hours looking for it... I have changed everything, webpools, passwords, NT security, etc, etc... and... U have the correct and short and exact answer... U R the man ! 23 ppl was stoping in my work for it !... between as... I'll dont tell to anyboby where I found the solution... :p this will be own little secret... and... I just register in this site to thank U... cheers.
Mar 22 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by glenn.owens@gmail.com | last post: by
2 posts views Thread by Rudolf Bargholz | last post: by
4 posts views Thread by Ken Allen | last post: by
7 posts views Thread by andrewb | last post: by
1 post views Thread by Mufasa | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.