• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Unable to connect SQL Server database with powerserver.

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Unable to connect SQL Server database with powerserver.

  1. Issue
0
Votes
Undo
  1. Aneesh Sasidharan
    Aneesh Sasidharan
  2. PowerServer
  3. Monday, 11 October 2021 07:09 AM UTC

 

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

   

 

  1. PowerBuilder
  2. PowerServer
Issue running powerserver2021
Error launching cloud app Launcher
Responses (2)
Julie Jiang @Appeon
Julie Jiang @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 October 2021 01:08 AM UTC
  2. PowerServer
  3. # 1

Hi Aneesh,

The PowerServer 2021 GA version does not support using instance names in the Server Host setting.  This will be fixed in the coming 2021 MR (scheduled around the end of this October).

Best regards, Julie

Comment
Aneesh Sasidharan
  1. Aneesh Sasidharan
  2. Tuesday, 12 October 2021 08:04 AM UTC
Thank you Julie, I changed host name with IP and now its working.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 11 October 2021 15:14 PM UTC
  2. PowerServer
  3. # 2

In the Server Host field of the Web API tab specify the machine IP address and no Instance name. 

Comment
Aneesh Sasidharan
  1. Aneesh Sasidharan
  2. Tuesday, 12 October 2021 08:05 AM UTC
Thank you Armeen, I changed host name with IP and now its working.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 12 October 2021 15:34 PM UTC
Glad to hear that! You're very welcome.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.