XCLN
asked on
How to correct the SQL server error in XP /Office 2007
After updating my XP SP3 workstation to latest patches i see this errror in the event log
Source MSSQL$MSSMLBIZ event ID 17207
FCB::Open:Operating system error 5(Access is denied) occured while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
Is this a critical error that will create problems down the line using web apps?
Source MSSQL$MSSMLBIZ event ID 17207
FCB::Open:Operating system error 5(Access is denied) occured while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
Is this a critical error that will create problems down the line using web apps?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay - that sounds great - thanks . .. let me try these fixes. Will report back ;-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome..
ASKER
timely too
ASKER
http://support.microsoft.com/kb/929665
"To work around this issue, repair Windows Internal Database. To do this, run the following command line at a command prompt:
Msiexec /i SSEE_10.msi CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v <Log_File_Path> "
Trying this return a syntax error. - I can download SSE_10.msi and but it in the directory where i run this command line, but same syntax error.
Any clues how I should be running this command? SQL server 2005 was installed from Office 2007 - and the latest patch for SQL server couldnt install for some reason.