Dear All,

 Please help me, I am not able to connect Power Server apps with SQL server database. 

info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[0]
User profile is available. Using 'C:\Users\aneesh.s\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
info: PowerServer[0]
PowerServer License
|-- LicenseKey: DSCB-FBJG-BFJJ-FEH0-0541
|-- ProductEdition: Developer
|-- LicenseExpiration: 2022-09-13
|-- Watermark: For Development Use Only

info: Microsoft.Hosting.Lifetime[0]
Now listening on: http://localhost:5000
info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
Hosting environment: Development
info: Microsoft.Hosting.Lifetime[0]
Content root path: D:\Application\PB19\TIMESHEET\PowerServer_gsstimesheet\ServerAPIs
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/CreateSession application/json;charset=UTF-8 514
info: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1]
Authorization was successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'PowerServer.Api.ServerApiController.CreateSessionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "CreateSession", controller = "ServerApi"}. Executing controller action with signature System.Threading.Tasks.Task`1[PowerServer.Core.IBaseResult] CreateSessionAsync(PowerServer.Core.RequestSession) on controller PowerServer.Api.ServerApiController (PowerServer.Api).
dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.CreateSessionAsync (PowerServer.Api)' get request ({
"reqData": {
"Type": 31,
"Content": {
"CreateSession": {
"ApplicationName": null,
"SecureString": "eyJ0aW1lc3RhbXAiOjE2MzM5MzUxODIsInBheWxvYWQiOiJ4QVZtRjN3SE41NlVoZG9Pdi9LbExUODR1djRhN3UrRXZES01aN1BGYWFQcUw0Z0tpUkJKN0VWV3R4UjAwUllZbGV2Vjc3WEdUbHd0Yms2WFBGMys2QT09Iiwic2lnbmF0dXJlIjoiLzA0UXByMGxuU24rVkhFS0F3R0NvTDNlTGxyOGFPeU5oUk5RV2laZFRMWmJKQmJaSjVrTlo5dVc2bUpIaFZSNmRiU3VpaEdvSzA2MW5rQ1k2bTNjdVE9PSJ9",
"SessionId": null
}
},
"ClientIPAddress": "",
"ServerIPAddress": "",
"ServerPort": 0,
"AppName": "GssTimeSheet",
"NamespaceName": "GssTimeSheet",
"SecureSession": "",
"Version": "1.0",
"RequestId": "3712F08A-442E-4a91-803B-D60188F16AAE",
"Transaction": null
}
}).
dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)' get request ({
"reqData": {
"Type": 7,
"Content": {
"Connect": {
"ApplicationName": null,
"CacheName": "DEV_TIMESHEET",
"CacheGroup": "",
"TransactionName": "sqlca",
"Transaction": {
"AutoCommit": false,
"Database": "GSSMobileApp",
"DBMS": "SNC SQL Native Client(OLE DB)",
"DBParm2": null,
"dbparm": "Database='GSSMobileApp',TrustedConnection=1, cachename='DEV_TIMESHEET' , cashegroup = 'Default'",
"DBPass": "",
"Lock": "",
"LogID": "sa",
"LogPass": "**********",
"ServerName": "GSSLAPANE",
"SQLCode": 0,
"SQLDBCode": 0,
"SQLErrText": null,
"SQLNRows": 0,
"SQLReturnData": null,
"UserID": ""
}
}
},
"AppName": "GssTimeSheet",
"NamespaceName": "GssTimeSheet",
"SecureSession": "eyJ0aW1lc3RhbXAiOjE2MzM5MzUxODMsInBheWxvYWQiOiJmcDc5UTBWcU5KUWVNZEZDbGJRL3dmVkh1N2lzZ0VGMldyTHdrZm5DaUw0clhxWlA3akRrRE1DVWp3aFFxK05tT2tPZTVvMjJwaDRhZFg1eUJoenBaRmpDSnBzWnhVSzNvYi9pN1ZZVHJoYnJ6ZTl6TmQzQ09kMDhDVWlFbDRxRXRDU2dsVHBYN0lkTGRaT2FuNk5yRG8rMXRLbWdLZFg1aFhkRFVoSW00QlY2WkR3NitNdURkcmRURGRDSVp1M0IiLCJzaWduYXR1cmUiOiJJL0pzMnZjWFJ0Tzdpc250TExBZ010VGVSMDBnZzJQQmdoVnovaXhjN2dOTGErcHBac2h2WHRleXJyakxUOEtaQ1cwcEpiSGdsUkhKME9hRTlzOVB6UT09In0=",
"Version": "1.0",
"RequestId": "6A951BAE-D254-4e88-A00E-6EE210EC4E6B",
"Transaction": null
}
}).
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/verify application/json;charset=UTF-8 20494
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/api/ServerApi/Verify HTTP: POST'
dbug: PowerServer[0]
Validate Session Id: '7C0E95A3-00A1-4ABE-B72A-F15389E48C90' Session Status: 'Created' Session Last Visit Time: '11/10/2021 6:53:03 AM'
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint '/api/ServerApi/Verify HTTP: POST'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 58.9339ms 200
fail: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)' get result ({
"IsSuccess": false,
"ErrorCode": 0,
"ErrorMessage": "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: SNI_PN11, error: 25 - Connection string is not valid)",
"Version": "1.0",
"RequestId": "6A951BAE-D254-4e88-A00E-6EE210EC4E6B",
"AppName": "GssTimeSheet",
"Session": {
"ErrCode": 0,
"ErrMsg": null,
"SessionId": "7C0E95A3-00A1-4ABE-B72A-F15389E48C90"
},
"Type": 7,
"Transaction": {
"TransactionId": null,
"SQLCode": -1,
"SQLDBCode": -1,
"SQLErrText": "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: SNI_PN11, error: 25 - Connection string is not valid)",
"SQLNRows": 0,
"SQLReturnData": null
},
"Content": {
"ServerConfig": {
"DelimitIdentifier": "no",
"Ojsyntax": null,
"CaseConversion": 0,
"Dbms": null
}
},
"Namespace": "GssTimeSheet"
}).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type '? '.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api) in 14837.9716ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 14869.0219ms 200 application/json; charset=utf-8
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/DestroySession application/json;charset=UTF-8 593
info: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1]
Authorization was successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'PowerServer.Api.ServerApiController.DestroySessionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "DestroySession", controller = "ServerApi"}. Executing controller action with signature System.Threading.Tasks.Task`1[PowerServer.Core.IBaseResult] DestroySessionAsync(PowerServer.Core.RequestSession) on controller PowerServer.Api.ServerApiController (PowerServer.Api).
dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.DestroySessionAsync (PowerServer.Api)' get request ({
"reqData": {
"Type": 32,
"Content": null,
"ClientIPAddress": "",
"ServerIPAddress": "",
"ServerPort": 0,
"AppName": "GssTimeSheet",
"NamespaceName": "GssTimeSheet",
"SecureSession": "eyJ0aW1lc3RhbXAiOjE2MzM5MzUyMjUsInBheWxvYWQiOiJnTm5uWVkrL2NES1FYaFgzeVI2QjZBMzVsQm9hZ21wZStReDRXbFlEdGNIelV0QnJPY2F0TXFLV3lTRUo4cmZYSjhOYVI3eWxyanA4MUFVUmxpRUdvQm9iUmRHSzZ6VUFGK1p0aCt1Z2pXQ2RUYWFKRjNNZ3ZKbWtVL1hwOUpQcFlNVDFwTCtYR0VxVEIvYUVJUU5WM0Y5VnBYaVRVVnVaQkdHbFpYZ21GaXc9Iiwic2lnbmF0dXJlIjoiNHgxMVJDTEVlZkdLa3k0OHFJbGdnd0UyS2FPWXRxM1pWMXFOY0R6TDI3VjBLNjVTVmx3YTEzSTlIbU0vVUdpcjltM3VoQStiRExWOEdJK1Nhc2ZnZWc9PSJ9",
"Version": "1.0",
"RequestId": "3DFA44DE-E89E-489d-8F9B-0BD407495124",
"Transaction": null
}
}).
dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.DestroySessionAsync (PowerServer.Api)' get result ({
"IsSuccess": true,
"ErrorCode": 0,
"ErrorMessage": null,
"Version": "1.0",
"RequestId": "3DFA44DE-E89E-489d-8F9B-0BD407495124",
"AppName": "GssTimeSheet",
"Session": {
"ErrCode": 0,
"ErrMsg": null,
"SessionId": null
},
"Type": 32,
"Transaction": {
"TransactionId": null,
"SQLCode": 0,
"SQLDBCode": 0,
"SQLErrText": null,
"SQLNRows": 0,
"SQLReturnData": null
},
"Content": null,
"Namespace": "GssTimeSheet"
}).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type '? '.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.DestroySessionAsync (PowerServer.Api) in 10.8925ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.DestroySessionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 28.1776ms 200 application/json; charset=utf-8