Link to home
Start Free TrialLog in
Avatar of ridha121
ridha121Flag for United Kingdom of Great Britain and Northern Ireland

asked on

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

SOLUTION
Avatar of Kobe_Lenjou
Kobe_Lenjou
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ridha121

ASKER

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.
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
Dont worry guys..

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