SQL Error 17204 when trying to create a new database SAGE ACT

Hi Guys

I am trying to create a new databse on SAGE ACT 2011 new installation, I believe it interogates the MS SQL 2008 R2 in order to initiate the process of creating the database

When I try to create a new database I get the following error in windows app log

Log Name:      Application
Source:        MSSQL$ACT7
Date:          23/03/2011 14:40:13
Event ID:      17204
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      RclSrv01.rcl.local
FCB::Open failed: Could not open file F:\Sage\Sage ACT\rclactdb.ADF for file number 0.  OS error: 5(failed to retrieve text for this error. Reason: 15105).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <Provider Name="MSSQL$ACT7" />
    <EventID Qualifiers="49152">17204</EventID>
    <TimeCreated SystemTime="2011-03-23T14:40:13.000Z" />
    <Security />
    <Data>FCB::Open failed</Data>
    <Data>F:\Sage\Sage ACT\rclactdb.ADF</Data>
    <Data>5(failed to retrieve text for this error. Reason: 15105)</Data>

Open in new window

Who is Participating?
snurkerConnect With a Mentor Commented:

That explains this error. Make sure that the ACT service accoutn can access that file location and has permissions to access the file. If it is on a restricted drive, you may need to add necessary permissions to access it.
Kobe_LenjouConnect With a Mentor Commented:
Does the file/folder F:\Sage\Sage ACT\rclactdb.ADF exist?

And has the SQLEngine permissions to use it?
ridha121Author Commented:
ah I think thats exactly it the file does exist but I think yeah ti doesnt have permission.

Thanks Snurker and Kobe, I will follow the support link to get this working.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

ridha121Author Commented:
I cannot seem to find the specified SQL account to give the permission, when I installed the product it did install Microsot SQL Server 2008 R2.. but I only see accounts for another instance of sql 2005 being used for our backup software..

hmmm a bit stuck
ridha121Author Commented:
Dont worry guys..

It was the system account had no access so gave it full rights
DO you see the SQL server under services?
Jason clarkDBA FreelancerCommented:
Please go this one to know more about the SQL Server Error 17204 FCB Open failed. http://sqltechtips.blogspot.com/2015/12/fcb-open-failed-error-17204.html
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.