Solved

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

Posted on 2011-03-23
7
1,792 Views
Last Modified: 2016-04-07
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

0
Comment
Question by:ridha121
7 Comments
 
LVL 8

Assisted Solution

by:Kobe_Lenjou
Kobe_Lenjou earned 125 total points
Comment Utility
Does the file/folder F:\Sage\Sage ACT\rclactdb.ADF exist?

And has the SQLEngine permissions to use it?
0
 
LVL 9

Accepted Solution

by:
snurker earned 125 total points
Comment Utility
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
 
LVL 3

Author Comment

by:ridha121
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 3

Author Comment

by:ridha121
Comment Utility
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
 
LVL 3

Author Comment

by:ridha121
Comment Utility
Dont worry guys..

It was the system account had no access so gave it full rights
0
 
LVL 9

Expert Comment

by:snurker
Comment Utility
DO you see the SQL server under services?
0
 
LVL 7

Expert Comment

by:Jason clark
Comment Utility
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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now