Solved

How to correct the SQL server error in XP /Office 2007

Posted on 2010-11-17
6
943 Views
Last Modified: 2012-05-10
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\master.mdl"  Diagnose and correct the operating system error and retry the operation.
Is this a critical error that will create problems down the line using web apps?
0
Comment
Question by:XCLN
  • 4
  • 2
6 Comments
 

Author Comment

by:XCLN
ID: 34154127
Microsoft has offered a patch but I can't get that to work ..
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.

0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 500 total points
ID: 34154358
Just change the SQL Server service account to LocalSystem which should help fix the issue.
Else Grant Full privileges to c:\Program Files\Microsoft SQL Server for the user account under which SQL Server service is up and running.

http://pjondevelopment.50webs.com/blog/2008/02/sql-server-2005-troubleshooting.html
0
 

Author Comment

by:XCLN
ID: 34154471
Okay - that sounds great - thanks . .. let me try these fixes.  Will report back  ;-)
0
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 

Accepted Solution

by:
XCLN earned 0 total points
ID: 34154663
Indeed that did it - thanks a lot for your prompt answer !
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34154724
Welcome..
0
 

Author Closing Comment

by:XCLN
ID: 34186348
timely too
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Step by step guide to Clean and Sort your windows registry! Introduction: Always remember: A Clean registry = Better performance = Save your invaluable time In this article we're going to clear our registry manually! Yes, manually! The e…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

740 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