ridha121
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
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>
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
hmmm a bit stuck
ASKER
Dont worry guys..
It was the system account had no access so gave it full rights
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
ASKER
Thanks Snurker and Kobe, I will follow the support link to get this working.