Connection could not be established

[jakebudin]

Hi,

We have several users that frequently cannot login to ASG-RD, no matter what they do an error message pops up that says

Connection to your current environment could not be established. The product will use now the cached data to run. You can try to establish a connection again by clicking on the "Offline" label in the status bar. Your changes in offline mode will be lost after reconnecting.

http://imgur.com/jGagy9O

Is this a known glitch, how can we resolve it?

Thanks,
-Jake

[DevOma]

Perhaps some network problems? If sql connection can not be established this pop up is shown... Open SQL Connection is standard .NET code...

[vmcit]

Perhaps some network problems? If sql connection can not be established this pop up is shown... Open SQL Connection is standard .NET code...

I also have the same issue with 2016sp1 version  - It's not a network problem as the Test Connection to the database is successful, AND version
2012 is running perfectly...
Any idea ?

[DevOma]

As we have the automatic offline functionality we call a test stored proc to see if the connection is really running - this was not in version 2012 - if the call of the stored procedure fails we suggest that the sql connection is broken and we offer to switch to offline mode...

[kimchrhansen71]

Hi i have the same problem in our new SQL servers. Could not find stored procedure 'ConnectionTest' is this built into the database? We are trying to move our setup from 2012 to 2018 asg on a new sql server.

[DevOma]

Yes you should find it under Programmability=>Stored Procedures=>dbo.ConnectionTest