Knowledgebase: EC Professional
EC Pro 2008: Reports Fail Due to Database Connection Errors
Posted by Barry Kroeker, Last modified by Joel Brickell on 14 July 2015 04:18 PM

EnergyCAP Professional Reports Fail Due to Database Connection Errors

Issue: I can access data in EnergyCAP Professional but when I try to run any report I receive an error concerning Database Connection failure.

Solution: This can occur when Energy CAP databases are attached to SQL Server via SQL Management Studio or Enterprise Manager but not from within EnergyCAP using the SYS option.

You can verify the problem by looking at the database User Properties with your SQL tools.  If the Login name is BLANK, you will have this problem.  The Login name and User name must both be "ecuser".

If the Login name is blank, execute the following one-line script against your EnergyCAP database:

EXEC sp_change_users_login N'auto_fix', 'ecuser'
EXEC sp_change_users_login N'update_one' N'ecuser', N'ecuser'

Then verify that the Login name is present and correct. Log into EnergyCAP Professional. You should be able to run reports.

lasted edited by Joel Brickell  01/27/2010

(388 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: