plesk web hosting error on live site

Question

plesk web hosting giving me error that  the instance name is correct and that SQL Server is configured to allow remote connections.

Sachin Singh · Answer

your connection string should be like this (Plesk hosting)   "mycs"  connectionString= "Data Source=your IP(ex:- 148.00.00.00);initial catalog=databaseName;Integrated Security=False;User ID=yourId;Password=YourPwd;Connect Timeout=15;Encrypt=False;Packet Size=4096"  providerName= "System.Data.SqlClient"  />

Rajesh Gami · Answer

Hello Zeshaan,   Check List for you:        1. Check your connection string server name, db name and password in webconfig (In Plesk panel)    2. Check your connetion string name in plesk web config file.    3. Check in your dll file means where you use sql connection that proper way or any syntax issue.    4. Rebuilt your project and Publish again.   Let me know if any other issue. Thanks

Jignesh Kumar · Answer

Hi,
Your connection string has some wrong information. Can you please check server name, database name etc in your Web.Config file.
Have you check your config where application is hosted, connectionstring is updated with correct information.
If you still facing same issue, Please refer this one,
https://support.solarwinds.com/SuccessCenter/s/article/Exception-A-network-related-or-instance-specific-error-while-establishing-a-connection-to-SQL-Server-EDIT?language=en_US