Author Topic: SOLVED: Database connection error from WebEA using MS SQL Server  (Read 8071 times)

wivel

  • EA User
  • **
  • Posts: 129
  • Karma: +9/-1
  • Driven by Models
    • View Profile
SOLVED: Database connection error from WebEA using MS SQL Server
« on: December 14, 2021, 08:07:50 am »
Hi

I am trying to setup a local installation of EA, PCS, WebEA for testing purposes on my laptop, but I simply cannot get it to connect my MS MS SQL database. I tried the same exercise a little over a year ago where it went without a hitch, so I am rather bewildered as to what I have done wrong. Connecting to a Firebird datavase works perfectly.

When trying to open my model from WebEA, I get the message "A connection to the selected model could not be created, check the connection string in the cloud client'.

[size=78%]The PCS log file gives me the following info:[/size]


Code: [Select]
2021-12-13 21:18:11 [WARNING]: Failed to open database connection to Provider=SQLOLEDB.1;Persist Security Info=False;User ID=EAUSER;Initial Catalog=EAModel;DMAlias=EAModel;.
2021-12-13 21:18:11 [WARNING]: Microsoft OLE DB Provider for SQL Server [-2147217843]
2021-12-13 21:18:11 [WARNING]: Invalid connection string attribute
2021-12-13 21:18:11 [WARNING]: Thread 12  FAIL unable to acquire connection.
2021-12-13 21:18:11 [SYSTEM]:  ConnectionServer::executeOSLCQueryToString - Unable to connect to Database Manager sqloledb.1:eauser@.eamodel

I have tried using both 'SQL Server authentication' and 'Windows Authentication' and also tried using both the 'Microsoft OLE DB Provider for SQL Server' and the 'Microsoft OLE DB Driver for SQL Server' but all combinations results in the same error.

My setup is Windows 10. MS SQL Server Express 15, EA 15.2, XAMPP 3.3 and PCS 4.2.66 and everything runs fine. the PCS and WebEA Web config runs as it is supposed to.

Anyone of you have any bright ideas as to what I am doing wrong?

Henrik
« Last Edit: December 16, 2021, 01:20:34 am by wivel »

wivel

  • EA User
  • **
  • Posts: 129
  • Karma: +9/-1
  • Driven by Models
    • View Profile
Re: SOLVED: Database connection error from WebEA using MS SQL Server
« Reply #1 on: December 16, 2021, 01:23:27 am »
Hi again.

It was a simple case of RTFM. I created a Database user with blank password and granted it the right roles/permissions. Works like a charm now.

https://sparxsystems.com/enterprise_architect_user_guide/15.2/pro_cloud_server/cloud_server_client_add_sqlsvr.html

Henrik