Options
.net core web api sql error error while profiling
chitchat
Posts: 17 New member
i am trying to profile .net core web api in staging server. I have selected.net core application,selected dll ,add environment variable as required connection string with Trusted_Connection=True; and selected browser.
When i click on start profiling browser open with localhost:5000. When i do the soap request /curl request to thiis endpoint (with localhost:5000) profiling happens. But response came with 500 internal error.
When i checked the application log .Its giving sql error. (Sql server in another system/server. )
System.Data.SqlClient.SqlException (0x80131904): 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 Server/Instance Specified)
My question here is i am using trusted connection string. Is it because of any permission isuue.
Which account ants profiler is trying to connect sql server. Please help me on this?
When i click on start profiling browser open with localhost:5000. When i do the soap request /curl request to thiis endpoint (with localhost:5000) profiling happens. But response came with 500 internal error.
When i checked the application log .Its giving sql error. (Sql server in another system/server. )
System.Data.SqlClient.SqlException (0x80131904): 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 Server/Instance Specified)
My question here is i am using trusted connection string. Is it because of any permission isuue.
Which account ants profiler is trying to connect sql server. Please help me on this?
Tagged:
Answers
It merely counts wall clock time for:
The time it took the call to execute on the server isn't recorded. This means that no time data is available for SQL calls in CPU time mode.
NET CORE api profiling
1. Select the start up dll
2. add environment variable (connection string trusted one)
3.Select browser
4.start profiling
5. Browser open with localhost:5000
6. profilier showed profiling started
7. Using the same end point in soap execute the post method
8. Profiling started . In response got 500 internal error
9. When i checked application log it says access denied.
please suggest...?do i need specific access for my id in sql db?