By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

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

P: 2
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
Share this Question
Share on Google+
2 Replies


P: 2
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

P: 1
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.