My project work ok with Asp.net development server, but when i use IIS :
I'm sure i can connect to SQL server by SQL Server Enterprise Manager and my project debug with Asp.net development server ok.
Anyone please help me.
This article should help:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
and if that doesn't then take a look here:
http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx
1 comment:
I just had this error, and here is what you need to do: first, you can probably ignore all the crap out there about your SQL Server conntection string being wrong or even that you have to enable named pipes in your server. For developers, I am betting you had the same problem as me: you used dbmls and some other data providers in your projects. Microsoft hard coded the connection strings in those files, so when you moved your project to a different server, all those connection strings remained the same! So simply go to VS, searching in files for something distinctive about the old connection string, then then make your replacements. The error will go away.
Post a Comment