[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2010-11-17
6
Medium Priority
?
951 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 2000 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Issue: Unstable cursor in Windows XP and Windows runs extremely slow in that any click will bring up the Hour glass (sometimes for several seconds before giving you what you want) . Troubleshooting Process and the FINAL FIX: This issue see…
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 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