Programming in vb.net: A network-related or instance-specific error occurred while establishing a connection to SQL Server on newest questions tagged vb.net – Stack Overflow
I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site …
Then following error occurs ….
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: SQL Network
Interfaces, error: 26 – Error Locating
i have changed my connectionstring in web.config file and all webpages to :
<connectionStrings> <remove name="ConnectionString"/> <add name="ConnectionString" connectionString="Data Source=18.104.22.168,1433; Network Library=DBMSSOCN; Initial Catalog=database;Persist Security Info=True;User ID=username;Password=password" providerName="System.Data.SqlClient"/> </connectionStrings>
…before publishing and uploading my website to webserver …
I m confused the problem is from my local computer or the webserver ….and how to fix this error ?
Programming in vb.net: programming-in-vb-net