Internal Server Error in asp.net website? SQL SERVER

Chandrasekaran C

7y3.2k

How to fix 'Internal Server Error in asp.net website?' SQL Server connection string

I am working on website building the website is ready its work locally great, but I deploy in website it give Internal server error only the database connection

I change connection string and try various method from others solution. but none of them work.

In web.config

401 ERROR { "Message":"There was an error processing the request.", "StackTrace":"", "ExceptionType":"" } unauthorized

I used to show above errors,

My connection string:

I need save data but it impact the db in server qtsihiot.com from run local but I deploy in website the errors shown.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chandrasekaran C7y ago
I added the [WebService(Namespace = "https://qtsihiot.com/")] line but it still not working
Salman Beg7y ago
Hi.
Can you please check, Above your service you added this line,
[WebService(Namespace = "https://qtsihiot.com/")]
Thanks.
Jignesh Kumar7y ago
It related to connection string only you need to try with your correct data source name, Initial catalog and correct username and password related.
Chandrasekaran C7y ago
I need help please ... Any information need contact me,,,,,
Chandrasekaran C7y ago
Both solution is not working on me. please can you find out problem.
Jignesh Kumar7y ago
Hi,

Please try your datasource and username password and initial catlog,
Check your database server instance while opening sql server. If your application and database server is difference then you need to put port number after server IP valuse in
datasource. Your data source value should look like below

Data Source=xxx.xx.xx.xx\MSSQL2016,11111;

xxx.xx.xx.xx - server IP address
\MSSQLServer - server instance
,11111 - port number
"olv" connectionString="Data Source=xxxxxx;Initial Catalog=xxxx;Integrated Security=False;Persist Security Info=True;Trusted_Connection=False;User ID=xxxx;Password=xxxx;" providerName="System.Data.SqlClient"/>
Salman Beg7y ago
Hi.
The problem is in your Default4WebService.asmx service.
You need to add this line in your service,
[System.Web.Script.Services.ScriptService]
and also you need to add some setting in web.config,
        "HttpGet"/>
        "HttpPost"/>



For more you can follow these links,
https://www.aspsnippets.com/Articles/Call-Consume-Web-Service-ASMX-using-jQuery-AJAX-in-ASPNet.aspx

https://stackoverflow.com/questions/12404679/unable-to-call-asmx-web-service-by-jquery-ajax
Thanks.
Chandrasekaran C7y ago
That not a application its website
https://qtsihiot.com/TES/Default4.aspx

link
Salman Beg7y ago
Ok. But i think that might be a problem with that remote server only where you have installed that application. You need to connect with the support team, where you had installed that application in remote server.
Thanks.
Chandrasekaran C7y ago
but the same connection string working my local pc(local pc connect that remote server)
Salman Beg7y ago
It is saying 401 Unauthorized which means it lacks valid authentication credentials for the target resource.
When you are trying to connect with that datasource using username and password then it is unable to authorized that datasource.
So please check at your end about that data source.
Thanks.