Connection string not working when moved from IISExpress to IIS

Question

User-892296104 posted

My connection string was working fine when using IIS Express. Now after moving to IIS. I'm getting error as

A network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible. Verify
that the instance name is correct and that SQL Server is configured to allow
remote connections. (provider: Named Pipes Provider, error: 40 - Could not open
a connection to SQL Server)

Not able to figure out the reason for this.  

please suggest

Answer 1

User1873438307 posted

Hello,

You cannot use SqlExpress db in your hosting account. You have to create db through your hosting account (server) and to connect into that after deploying the database.

For connectionstrings reference check the following URL:

www.connectionstrings.com

Answer 2

User-892296104 posted

I'm using SQL Server 2005 not SQLExpress. The database is on a remote server.

Answer 3

User-1454326058 posted

Hi kiranmayi,

According to your description, I would like to know do the IIS Express and IIS in the same machine.

Please provide your connectionstring.

On the other hand, please refer to this link: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c488cf76-2515-440f-b3f8-9cfad689c5b6/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server?forum=sqldataaccess

Thanks

Best Regards  

Answer 4

User-892296104 posted

yes both IIS and IISExpress are on the same machine.

<add name="myConnectionString" connectionString="Persist Security Info=False;User ID=userid;Password=password;Initial Catalog=mydatabase;Data Source=myserver"/>

I tried with IP address also.

Answer 5

User-1454326058 posted

Hi kiranmayi,

Please try to use the connectionString like this:

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;
Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Thanks

Best Regards  

Answer 6

User649579883 posted

Please check that your SQL server is allowing TCP/IP and port is correct.

You can use connection string like

<add name="userDbConnectionString" connectionString="Data Source=XXX.XXX.XXX.XXX;Initial Catalog=YourDB;user id= sa; password =sa" providerName="System.Data.SqlClient"/>

Answer 7

User13850534 posted

Since your database is on live production server, you should check if your hosting server is blocking the connection. Maybe you have to contact hosting support for assistance.