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
Description:
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">
  <System>
    <Provider Name="MSSQL$ACT7" />
    <EventID Qualifiers="49152">17204</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2011-03-23T14:40:13.000Z" />
    <EventRecordID>317663</EventRecordID>
    <Channel>Application</Channel>
    <Computer>RclSrv01.rcl.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>FCB::Open failed</Data>
    <Data>F:\Sage\Sage ACT\rclactdb.ADF</Data>
    <Data>0</Data>
    <Data>5(failed to retrieve text for this error. Reason: 15105)</Data>
    <Binary>34430000100000000E000000520043004C00530052005600300031005C0041004300540037000000070000006D00610073007400650072000000</Binary>
  </EventData>
</Event>

Open in new window

LVL 3
ridha121Asked:
Who is Participating?
 
snurkerConnect With a Mentor Commented:
http://support.microsoft.com/kb/2015754

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.
0
 
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?
0
 
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.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
0
 
ridha121Author Commented:
Dont worry guys..

It was the system account had no access so gave it full rights
0
 
snurkerCommented:
DO you see the SQL server under services?
0
 
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
0
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.