Sparx Systems Forum

Pro Cloud Server / Prolaborate / WebEA => PCS Frequently Asked Questions => Topic started by: wivel on December 14, 2021, 08:07:50 am

Title: SOLVED: Database connection error from WebEA using MS SQL Server
Post by: wivel 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
Title: Re: SOLVED: Database connection error from WebEA using MS SQL Server
Post by: wivel 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 (https://sparxsystems.com/enterprise_architect_user_guide/15.2/pro_cloud_server/cloud_server_client_add_sqlsvr.html)

Henrik